| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort multiple columns by alphabetical order
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort multiple columns by alphabetical order
To the best of my knowledge that is not supported.
-- HTH... Jim Thomlinson "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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort multiple columns by alphabetical order
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort multiple columns by alphabetical order
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i re-sort multiple worksheets into alphabetical order | Excel Discussion (Misc queries) | |||
| sort last names by in alphabetical order | Excel Discussion (Misc queries) | |||
| Formula to sort names in alphabetical order? | Excel Discussion (Misc queries) | |||
| Using a macro to sort your data in alphabetical order? | Excel Discussion (Misc queries) | |||
| how can i sort excel worksheets in alphabetical order? | Excel Worksheet Functions | |||
Hybrid Mode
