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