Share via

Custom Sort Order in Excel 2016

Anonymous
2022-05-28T12:18:04+00:00

I have got Microsoft Excel 2016, and I have created my own custom sort orders before. However, whenever I try and create any new ones now, my existing orders come up and I can't see the option to create a new one - Does anyone know how to create a custom sort order on Excel

2016?

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2022-05-28T12:26:17+00:00
    1. On the Excel menu, click Preferences, and then under Formulas and Lists, click Custom Lists .
    2. Click Add.
    3. Type the values for your list in the order that you want them sorted, with a comma between each value.
    4. When you are finished, click Add, and then close the Custom Lists box.
    0 comments
  2. Anonymous
    2022-05-28T12:48:05+00:00

    Hi

    Thanks for posting the thread on our forum.

    According to your description, it seems that you want to know how to create a custom sort order on Excel. (If my understanding is incorrect, please feel free to post back)

    The member HansV provided the correct steps!

    According to the article Sort a list of data in Excel for Mac (microsoft.com) , follow the steps mentioned in Create a custom list to sort by to check the result

    In the Excel menu, click Preferences, and then under Formulas and Lists, click Custom Lists .

    Then click Add to create your own Lists.

    Hope the suggestion can help you. And if there have any unclear or misunderstanding, please feel free to post back and we’ll continue to help you all the time!

    Your understanding and patience will be highly appreciated! Hope you have a good day and keep safe!

    Best regards,

    Stacey

    0 comments