Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

How to Perform Multi-Level Data Sorting in Excel?

  • Difficulty Level : Expert
  • Last Updated : 24 May, 2021

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:

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

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
Recommended Articles
Page :

Start Your Coding Journey Now!