Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding more sort fields to the SORT Dialog Box
Does anyone know if there is a way to add more sort fields to the sort dialog
box? I have a spreadsheet that I need to sort and it would be a lot easier if I could sort four different columns. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding more sort fields to the SORT Dialog Box
I don't think it can be done...
Suppose you want to sort on AxBxCxDxE You need to sort on the lower importance columns (D and E) first and then on the higher importance (A and B) to get what you want "Doug V." wrote: Does anyone know if there is a way to add more sort fields to the sort dialog box? I have a spreadsheet that I need to sort and it would be a lot easier if I could sort four different columns. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding more sort fields to the SORT Dialog Box
Actually, it can be done, but you need to create a custom sort order. It is
fairly well detailed in the HELP section, do a search on SORT, then select USE YOUR OWN DATA AS THE SORT ORDER. -- John C "Doug V." wrote: Does anyone know if there is a way to add more sort fields to the sort dialog box? I have a spreadsheet that I need to sort and it would be a lot easier if I could sort four different columns. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding more sort fields to the SORT Dialog Box
To clarify, it doesn't add more sort fields to the dialog box, but it does
allow a single sort for more than 3 fields at one time. -- John C "John C" wrote: Actually, it can be done, but you need to create a custom sort order. It is fairly well detailed in the HELP section, do a search on SORT, then select USE YOUR OWN DATA AS THE SORT ORDER. -- John C "Doug V." wrote: Does anyone know if there is a way to add more sort fields to the sort dialog box? I have a spreadsheet that I need to sort and it would be a lot easier if I could sort four different columns. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Sort Dialog Box in Excel keeps growing. | Excel Discussion (Misc queries) | |||
Retaining Sort order in the Sort Dialog box | Excel Discussion (Misc queries) | |||
Excel Open Dialog Improper Sort | Excel Discussion (Misc queries) | |||
How can I sort 4 fields at a time | New Users to Excel | |||
Can I sort a list with more than three fields? | Excel Discussion (Misc queries) |