How to Sort Multiple Columns in Excel

puneet-gogia-excel-champs

- Written by Puneet

In Excel, when you open the sorting dialog box, it allows you to sort multiple (two, three, or even more) columns. And in this tutorial, we will learn to do this multiple-column sorting.

sort-multiple-columns

Steps to Sort Multiple Columns

  1. First, go to the Data Tab > Sort.
    2-sort-icon-1
  2. In the dialog box, click on the “Sort By” drop down and select the column you want to use to sort as the first order. You can also change the order from “Smallest to Largest” to “Largest to Smallest”.
    3-sort-by-dialog-box
  3. Now, click the Add Level button to add the second column for sorting. And again, click on the “Sort by” drop-down and select the column name. At this point, you have used two columns for sorting.
    4-add-level-button
  4. In the end, click OK to sort the data.

When you click OK, it will sort the data using the two columns, age and then Date Joined. You can see in the below snapshot; you have the age sorted from lower to higher age and then “Date Joined”.

age-sorted

And if you want to sort data by using more than two columns, you need to add one more level or any number of levels you want.

sorted-data-by-multiple-columns

You can also change the level of the columns you have already added by using the move-up and down buttons.

change-level-of-columns

Get the Excel File

Last Updated: April 28, 2024