Cant custom sort on Excel 365

Question

Hi! I cannot figure out how to create a custom list for sorting on Excel 365. These are my only two sort options. I'm trying to sort 'Month Hired' column not alphabetically, but with a custom list for Jan, Feb, March... etc. I opened another book and the same thing happened, only giving me two sort options. What am I missing?

Answer 1

You don't need to create a Custom Sort for this... It's built in.

On the web page Andreas pointed you to expand the Sort by a custom list topic which will guide you through what you see in this screen shot: By Month in either A=Z or Z-A order:

However, it depends to some extent on how your data is stored. The Day, Month & Year are individual data items, so if all 3 are jammed into a single cell it can make it more complicated to sort based on multiple criteria, especially if the records span more than one year.

Answer 2

Take a look here https://support.microsoft.com/en-us/office/sort-a-list-of-data-in-excel-for-mac-3b0e62c1-ef88-4176-babb-ccf1cb1e6145

Andreas.

Answer 3

Dear TJohnson13,

Thank you for posting in Microsoft Community. We are happy to help you.

Based on the description, you only have two sort options. I did the testing on my side and this is currently expected behavior if we want to use sort by color > customer sort. You can use custom List.

We look forward to your response. Thanks for your cooperation. Stay safe and healthy always.

Sincerely,

Zee | Microsoft Community Moderator