Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change the column order in Excel table with multiple sort
I have an Excel table, have sorted it on 4 levels. Is there a way to change
the column order in the table so that the information gleaned in the sort is clear? In other words, I'd like the column order to mirror the sorting levels. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change the column order in Excel table with multiple sort
Nothing automatic that's built into excel.
But you could drag and drop the columns where you want them after you sort. Personally, I think I'd find the changing of the layout more confusing that determining how the data was sorted. Kate LeGrand wrote: I have an Excel table, have sorted it on 4 levels. Is there a way to change the column order in the table so that the information gleaned in the sort is clear? In other words, I'd like the column order to mirror the sorting levels. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table sort order | Excel Worksheet Functions | |||
Sort order not being matched in pivot table | Excel Discussion (Misc queries) | |||
In Excel 2000, How can I change the order in a pivot table? | Charts and Charting in Excel | |||
Can I change the sort order to Alpha before Numeric? | Excel Discussion (Misc queries) | |||
Pivot table sort order | Excel Discussion (Misc queries) |