How to Perform a Custom Sort in Excel


- Written by Puneet

In Excel, you can use a custom order to sort data. For this, you need to use the custom list. There are a few pre-made lists that you can use, or you can create a new list also.

Let’s use the data that we have in the example here. In this data, we have a list of names and need to sort based on the age category.


Part-1: Create a Custom List

  1. Go to the Home Tab > More > Options > Advanced > Edit Custom List.
  2. In the custom list dialog box, enter the list entries in a sequence in which you want to sort the data.
  3. Or you can also get it from the range using the range selection and import buttons.
  4. In the end, click OK.

Part-2: Steps to Custom Sort in Excel

  1. Select the data and open the SORT dialog box. Data > Sort. Or you can also use the keyboard shortcut Alt > A > S > S.
  2. From the “Sort by” dialog box, select the column “Age Category”.
  3. After that, from the “Order” dialog box, select “Custom List”.
  4. And then select the list you have just created new.
  5. Finally, click OK twice to sort the data using the selected custom list.

And the moment you click OK, it sorts data using the age category you created before sorting.

Get the Excel File

Last Updated: April 28, 2024