Forum Discussion

mike russell's avatar
mike russell
Copper Contributor
Aug 08, 2017

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.

BI & Data Analytics
Need Help

2 Replies

  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    MVP
    Aug 10, 2017

    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.

     

    • mike russell's avatar
      mike russell
      Copper Contributor
      Aug 17, 2017

      Thanks so much for your counsel. It didn't do the trick for me, but I appreciateyour suggestion nonetheless.

Resources