Forum Discussion

Missa_Eaton's avatar
Missa_Eaton
Copper Contributor
Mar 11, 2022

Saving a Custom Sort

I have constructed an Excel spreadsheet for keeping track of the projects I work on throughout the day.  I do quick sorts on Start Time to keep everything in chronological order, but for reporting purposes at the end of the day, I do a Custom Sort on the selection on three specific columns in a particular priority order.  I do this every day.  And every day, I have to re-enter the column letters.  It's not that troublesome, but I am wondering if I can save a Custom Sort somehow?

office 365

1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    Mar 11, 2022

    Missa_Eaton Not sure how you are doing the sorts right now but maybe this could help: if you go to Data -> Sort you will get a pop-up window for a multi-level sort.  You can then put in your custom sort AND your Start Time sort and then just use the up and down arrows to change the sort order so the Start Time is either top (during the day) or bottom (end of the day)?

     

Resources