Follow these steps to create your own custom list for sorting: In a column of a worksheet, type the values to sort by. Arrange them in the order that you want to define the sort order—from top to bottom. For example: Select all of the cells in that list, and then click File > Options > Advanced.
This tutorial demonstrates how to sort with a custom list in Excel. Sort Data With a Custom List In Excel, you have the option to sort data by custom lists. There are standard lists – like days and months – and you can also create a custom list for your data.