LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Sort multiple columns by alphabetical order

You do understand that you may continue the sort on additional sets of
three columns to gain additional ordering of the data.

hello wrote:

Thank you very much for your help, I also got to the three column limit.

"Bob I" wrote:


Nope, you can sort on 3 columns at a time, just keep sorting from the
least significant 3 to the most significant 3 columns.

hello wrote:


Hello

I have many columns (100 or so) in a spreadsheet, and I want to sort them
all by alphabetical order. Can this be done easily? The Data, Sort menu seems
to only sort one column at a time. I an using Excel 2003 on Windows XP.
Thanks very much.






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can i re-sort multiple worksheets into alphabetical order Stuart Excel Discussion (Misc queries) 3 May 22nd 10 07:35 AM
sort last names by in alphabetical order Jackie Excel Discussion (Misc queries) 1 May 24th 06 08:45 PM
Formula to sort names in alphabetical order? Fredrik Jonsson Excel Discussion (Misc queries) 0 September 1st 05 04:33 PM
Using a macro to sort your data in alphabetical order? Carrie Excel Discussion (Misc queries) 1 April 14th 05 03:07 PM
how can i sort excel worksheets in alphabetical order? Birichica Excel Worksheet Functions 1 February 14th 05 06:25 PM


All times are GMT +1. The time now is 01:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"