Mobile menu

alphabetical order in excell
Thread poster: Tatty
Tatty  Identity Verified
Local time: 12:55
Spanish to English
+ ...
Mar 29, 2005

Could anyone tell me if it is possible to order a vertical list of subject headings alphabetically in Excell. I know how to do it in Word but I can't find the option in excell but it must exist surely?

Thanks in advance


Direct link Reply with quote
 

Marion Schimmelpfennig  Identity Verified
Local time: 12:55
Member (2003)
English to German
Mark column, click on data, then on sort Mar 29, 2005

Hi, if I understood you correctly, this should be easy to solve:

Simply click on the column you want to sort, for example on the "A" of column A to mark the whole column, then go to "data", then on "sort" in your task line and choose the options you want to have.

Good luck


Direct link Reply with quote
 

Eva Blanar  Identity Verified
Hungary
Local time: 12:55
English to Hungarian
+ ...
If you want to rearrange the whole of the table Mar 29, 2005

There is a simple way to sort the whole of the table, by three different criteria in Data > Sort: in this case, by sorting say, by column B, all the rows will be rearranged, respectively. (If you sort only one column, the table might turn into a mess.)

Direct link Reply with quote
 
Tatty  Identity Verified
Local time: 12:55
Spanish to English
+ ...
TOPIC STARTER
Many thanks Mar 29, 2005

Thank you very much to both of you.

Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

alphabetical order in excell

Advanced search






Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »
Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs