Forum Discussion
Excel Sorting
Is there a way to set the sorting default to sort "largest to smallest"? Every time I sort it makes me hit the pull down menu because the default seems to be "smallest to largest". Thank you.
Hello,
AFAIK, there is no way of changing the default sort order. However, the data ribbon shows the AZ command and also the ZA command, so you can sort ascending or descending with just one click, without using any dropdowns.
Thanks so much for your counsel. It didn't do the trick for me, but I appreciateyour suggestion nonetheless.