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