Custom Sort Order

 

You can use Excel to sort data in a custom order. In the example below, we would like to sort by Priority (High, Normal, Low).

1. Click any cell inside the data set.

Sort by a Custom List Example

2. On the Data tab, in the Sort & Filter group, click Sort.

Click Sort

The Sort dialog box appears.

3. Select Priority from the 'Sort by' drop-down list.

4. Select Custom List from the 'Order' drop-down list.

Select Custom List

The Custom Lists dialog box appears.

5. Type the list entries.

6. Click OK.

Type List Entries

7. Click OK again.

Custom Sort Order

Result. Records are sorted by Priority (High, Normal, Low).

Sort by a Custom List in Excel