alphabetical order in excell
Thread poster: Tatty
Tatty  Identity Verified
Local time: 17:06
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: 17:06
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: 17:06
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: 17:06
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






WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »



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