Skip to content
Related Articles

Related Articles

Improve Article

Custom Lists in Excel

  • Last Updated : 20 May, 2021
Geek Week

Custom lists are a tool from where we can sort data either by days of the week or months of the year. We can create our own custom lists In this article we will look at how we can do Sorting using Custom Lists in Excel. 

Sorting data using built-in custom lists:

To do so follow the steps below:

Step 1: Start by formatting our data.

Step 2: Highlight the data which we want to sort.



Step 3: Then, click to Data on the Ribbon. In the Sort & Filter group, click Sort.

Step 4: In the Sort box, select Custom List… in Order.

Step 5: In the Custom Lists box, we will select the list which we want and then click Ok to sort.

Now, data are sorted.



Sorting data by creating our own custom lists:

To do so follow the steps below:

Step 1: Start by formatting our data.

Step 2: Highlight the data which we want to sort.

Step 3: Then, click to Data on the Ribbon. In the Sort & Filter group, click Sort.

Step 4: In the Sort box, select Custom List… in Order.

Step 5: In the Custom Lists box, we will select NEW LIST, then click on Add then we will write the order in List entries to sort and then click Ok.

Now, data are sorted.

Attention reader! Don’t stop learning now. If you are an Excel beginner (or an intermediate) and want to learn Excel, Geeksforgeeks brings the perfect course for you to start, Diving Into Excel

My Personal Notes arrow_drop_up
Recommended Articles
Page :