Jump to content

Worksheet column sorting levels

Recommended Posts


Is there an easy way to change the "sort order - order" in a worksheet?

In Excel ,Microsoft refers to sort order "levels" which can be moved up and down (e.g. sort by Column A first, then by column B and then by column C) You have a relatively friendly dialogue box where you can move those levels up and down. I can see the little numbers within the worksheet column header icons that show the order levels, so I can see the order in which they are applied, but the only way I can change the 'levels' is to remove all the sorting completely and start again.


I looked here - but nothing mentioned - notably bullet option 5 doesn't work (perhaps this is an older feature now removed (I'm using 2021)



I know there are movements afoot to update worksheets significantly for the next release - so here's hoping 🙂



Link to comment

Except by scripting it 😃


Try these.  Make any cell in a database column active.  Run the script that sounds like it will do what you want.  It will sort up, sort down, summarize, sum values, or remove any or all of the above.


(I too miss the old way of quickly moving "badges" between columns to reorder sorts.  But I have to admit the new way is WAY WAY WAY more discoverable.  Nobody could figure out the old way on their own.  These scripts are almost as good as the old way.)



Worksheet Sort Scripts.vwx

  • Like 2
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...