How to create a custom sort in Microsoft Excel

Sometimes you may need to do a sort that is not an alphabetical or ascending sort in Microsoft Excel. Below are the steps to help you create a custom sort in Microsoft Excel to sort the data in the order you want it represented.

1. Open Excel and select all of the data you want to be sorted.

• How to select one or more cells in a spreadsheet program.
• How to select an entire row or column in a spreadsheet.

2. Click the Data tab and then the Sort button (shown below).
3. In the Sort box (shown below) click Custom List under Order.
4. In the List entries box, enter how you want the data sorted. For example, we've entered "2E, 2D, 2S, 3E, 3D, 3S, 4E, 4D, 4S" as our sort order.
5. Once you've completed entering the data into List entries, click the Add button and then OK.