Open In App

Custom Lists in Excel

Improve
Improve
Like Article
Like
Save
Share
Report

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.


Last Updated : 20 May, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads