Bruce Kieffer Posted July 24, 2023 Share Posted July 24, 2023 Is there a fast way to change the sort order of columns in a worksheet? I added the Layers column and I want it to sort first without changing the sort order the rest of the columns. I see no way to so this but to unsort all the columns and start over. Quote Link to comment
michaelk Posted July 24, 2023 Share Posted July 24, 2023 @Bruce Kieffer No, there isn't a shortcut. I wrote a bunch of scripts to make this less painful. You can use them as scripts or as menu commands: https://www.verysmallgroup.com/worksheet-formatting-scripts 1 Quote Link to comment
Bruce Kieffer Posted July 24, 2023 Author Share Posted July 24, 2023 @michaelk, I installed your scripts. Thanks. What is remove all suppose to do? I hoped it would remove all the previously set sorts, but I still have to remove the sorts one column at a time, unless I'm doing something wrong. Quote Link to comment
michaelk Posted July 24, 2023 Share Posted July 24, 2023 Yes. It only works on the column that has a cell selected. Remove All means that it removes the Sort, Sum Values, and Summarize from that column. Would you be interested in one that clears everything from the database? Quote Link to comment
Bruce Kieffer Posted July 25, 2023 Author Share Posted July 25, 2023 1 hour ago, michaelk said: Would you be interested in one that clears everything from the database? Sure, but not if it takes you some time to make since I have very little need for it. Quote Link to comment
michaelk Posted July 25, 2023 Share Posted July 25, 2023 That's what I felt too. I usually only sort by 3 columns so with the script/menu command it's only a couple clicks to undo. If I revisit these again I'll add that one. 1 Quote Link to comment
Simon Bonami Posted January 16 Share Posted January 16 Hi ! Just wanted to write my most sincere gratitude for writing all these absolutely amazing scripts and handing them out for free ! Great, great video tutorial as well ! 1 Quote Link to comment
Recommended Posts
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.