Suppose you have a worksheet that identifies classes as introductory, Intermediate and Advanced? An alphabetic sort would result in Advanced, Intermediate, Introductory or Introductory, Intermediate, Advanced. There is no built-in custom sort for this particular sort in MS Excel.
Follow the steps below to create a custom sort for the three classes:
In version 2010:
- Click the File tab and select Options under Help.
- Select Advanced in the left pane.
- In the General section, click Edit Custom Lists.
- In the List Entries control, enter each class in the sort order and click Enter after each entry.
Should your list be long or already exist as natural data, you can specify the cell reference and click Import.
- Click OK two times.
To apply the custom sort, select the list you want to sort, click the Data tab, and then click Sort in the Sort & Filter group. Click the Order drop-down and select Custom Lists, and select Introductory, Intermediate and Advanced.
- Click the Options button and select the Custom sort from the First Key Sort Order drop-down and click OK two times.
Custom lists are stored in the Windows Registry and so they are available for all workbooks, not just the one you are working in when you create your list. That means your list will not be on other computers. If you are working with the same workbook, the list itself is available. Open the Custom Lists dialog box and select the list in the Custom Lists control and click Add.
Doing this will add the custom sort to the local system’s Registry.