How to Perform a Custom Sort in Excel

Last Updated: September 08, 2023
puneet-gogia-excel-champs

- 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.

custom-sort

Part-1: Create a Custom List

  1. Go to the Home Tab > More > Options > Advanced > Edit Custom List.
    2-create-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-custom-list-dialog-box
  3. Or you can also get it from the range using the range selection and import buttons.
    4-range-selection
  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.
    5-custom-sort-in-excel
  2. From the “Sort by” dialog box, select the column “Age Category”.
    6-select-sort-by-custom-list
  3. After that, from the “Order” dialog box, select “Custom List”.
    7-order-dialog-box
  4. And then select the list you have just created new.
    8-newly-created-list
  5. Finally, click OK twice to sort the data using the selected custom list.
    9-custom-list-wise-sorted-data

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

Get the Excel File