You can sort data easily from A to Z, or 0 to 9, in ascending or descending order. But what if you want to sort data in a different way, say starting with "Low", then "Medium", and "High"? In this article, we're going to show you how to sort in Excel in a custom order.

Steps

1. Begin by selecting your data.
    
2. Click the Sort icon under the DATA tab.
    
3. Select the column name you want to sort.
    
4. Select the Custom List… option under the Order drop-down.
    
5. In the Custom List window, enter the items to form your custom list, and remember to put a comma in between items.
    
6. Select the list you just created from the Custom List menu and click Add.
    
7. Click OK. Now, you should see your custom list selected under the Order column.
    
8. Click OK to apply your settings.