Skip to content
Related Articles

Related Articles

How to Perform Multi-Level Data Sorting in Excel?

Improve Article
Save Article
  • Difficulty Level : Medium
  • Last Updated : 24 May, 2021
Improve Article
Save Article

Multi-Level Data Sorting is the process of arranging the data of more than one column in ascending or descending order. In this article, we will look into how we can do Sorting in Excel. 

To do so follow the steps below:

Step 1: First format the data.

Step 2: Converting data from unsorted to sorted order.

First, 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 one row of Level is inbuilt by Excel so, click two times on Add Level to add two rows of Level.

Step 5: After that in three rows of Level select column name which we want to sort first in Column then 2nd column name and then 3rd column name. To sort in ascending order select A to Z in Order for strings and select Smallest to Largest for Integers, and then click Ok.

Now, data are sorted in ascending order according to the Name column which was selected first. 

Step 6: To sort data in descending order. In three rows of Level select column name which we want to sort first in Column then 2nd column name and then 3rd column name. To sort in descending order select Z to A in Order for strings and select Largest to Smallest for Integers, and then click Ok.

Now, data are sorted in descending order according to the Name column which was selected first. 

My Personal Notes arrow_drop_up
Related Articles

Start Your Coding Journey Now!