# How to Create Custom Sort List in Excel

Today I will be showing how to create a custom sort list in Excel. While working in Excel, we often have to sort a range of cells according to our needs. Sorting these manually may take a lot of time, and it is quite troublesome too. Creating your custom sort list comes in very handy in these situations. In this article, I am going to demonstrate 2 simple ways to create a custom sort list in Excel. If you are also curious about it, download our practice workbook, and follow us.

## 2 Simple Methods to Create Custom Sort List in Excel

Here we have a data set with the Names, Marks, and Grades and some students in an examination of Saint Xavierâ€™s High School. The grades are divided into 6 categories, A+, A, A-, B, C, and F. To see clearly, I have given them six different colors.

The order of the grades is A+, A, A-, B, C, F. Our objective today is to create a custom sort list of the grades to sort the students according to their grades.

ðŸ“š Note:

All the operations of this article are accomplished by using Microsoft Office 365 application.

### 1. Creating from Excel Toolbar

In the first method, we are going to create the custom sort list from the Excel Toolbar. The steps of this approach are given below:

ðŸ“Œ Steps:

• First of all, select the range of cells B5:D24.
• Now, in the Data tab, click on the Sort command from the Sort & Filter group.

• As a result, a small dialog box called Sort will appear.
• Then, click on the drop-down arrow of the Order section and choose the Custom List option.

• Another dialog box called Custom Lists will appear.
• After that, select the NEW LIST option and write down our 6 categories sequentially in the empty List entities section.
• Finally, click on the Add button.

• You will notice that our custom sort list will add at the bottom of all lists.
• Click OK to close the dialog box.

• Afterward, we will apply our custom sort list to our dataset.
• For that, click on the drop-down arrow of the Sort by section and choose Column D.
• Next, in the Order section, choose the Custom List option.

• The Custom Lists dialog box will appear again.
• Now, select our custom sort list and click OK.

• Again, click OK to apply the custom sort to our dataset.

• You will notice within a second the dataset will be sorted with our custom sort list.

Thus, our procedure works perfectly, and we are able to create a custom sort list in Excel using the Sort command.

### 2. Generating from Excel File Menu

In this approach, we will create the custom sort list from the Excel File menu. The procedure of this approach is explained below:

ðŸ“Œ Steps:

• First, click on the File > Options option.

• As a result, the Excel Options dialog box will appear.
• Now, click on the Advanced option.
• Then, scroll down with your mouse and find out the General section.
• After that, click on the Edit Custom Lists option.

• Another dialog box called Custom Lists will appear.
• Next, select the NEW LIST option and write down our 6 categories sequentially in the empty List entities section.
• At last, click on the Add button.

• You will figure out that our custom sort list will add at the bottom of all lists.
• Thus, click OK to close the dialog box.

• Again, click OK to close the Excel Options dialog box.
• Now, we will apply our custom sort list to our dataset.
• For that, select the range of cells B5:D24.
• Then, in the Data tab, click on the Sort command from the Sort & Filter group.

• Next, click on the drop-down arrow of the Sort by section and choose the Grade option.
• After that, in the Order section, choose the Custom List option.

• As a result, the Custom Lists dialog box will appear again.
• Select our custom sort list and click OK.

• Again, click OK to apply the custom sort to our dataset.

• You will see that the dataset will be sorted with our custom sort list.

Finally, we can say that our procedure works successfully, and we are able to create a custom sort list from Excel Options.

## Add Custom Sort List in Excel 2016

Excel 2016 is a widely used Microsoft Office version. Now-a-day if you buy a new laptop or computer, you will get this office version from the seller complementary. So, you get Excel 2016 on your device easily. Now, you may be curious about how to add a custom list to your Excel 2016 version. The procedure of adding a custom sort list in Excel 2016 is almost similar. Even both approaches are available in Excel 2016 version. You can use any of them to add a custom sort list in Excel 2016.

## Conclusion

Thatâ€™s the end of this article. I hope that this article will be helpful for you and you will be able to create a custom sort list in Excel. Please share any further queries or recommendations with us in the comments section below if you have any other questions or suggestions.

Donâ€™t forget to check our website, ExcelDemy, for several Excel-related problems and solutions. Keep learning new methods and keep growing!