How to change the column order in Excel table with multiple sort

K

Kate LeGrand

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.
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Multiple Tables 1
List all tables, including document structure 0
Setting column width in a table with a macro is not working 0
Cannot sort a table containing text 5
Dates In Excel 5
Dealing with the error: unable to filter on excel hc home school 0
Merging from an Excel file with graphics 1
Sorting a column based on required order 2

Top