Sort By Multiple Columns In Excel

Let’s see how we can sort by multiple columns in excel.

We will see a quick example to understand how to sort the data by more than one column in excel

In the below given data, we want to sort first by column A and then by column B descending (highest to lowest) and then by column E.

Capture

Step 1

Select the data and apply sorting from menu or you can use shortcut Alt+D+S.

Capture

Step 2




First we have to sort by column A so select Credit Card Product from Sort by box.

Capture

Step 3

Click on Add Level to introduce the remaining columns on which we want to do the sorting, in our case its Limit and also by descending.

So select Limit from the Sort by column and select “Largest to Smallest” from Order drop down.

Capture

Step 4

Now we have to introduce the third column “Segment” so again Add level and select “Segment”.




Capture

Now we are done with the sorting orders, press OK and our data is sorted as per our requirement.

Capture

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply