How to Sort By Multiple Columns in Google Sheets

Sorting data in Google Sheets is pretty straight forward.

You can sort a single column (alphabetically or based on the numeric value in ascending/descending order) or multiple columns (based on one of the columns).

But what if you have multiple columns and you want to sort more than one columns at the same time.

For example, suppose you have a dataset as shown below and you want to first sort based on the region and then based on the sales. This way, you would have all the records for each region together and within each region, the sales can be sorted from highest to lowest.

Dataset to sort by multiple columns in Google Sheets

In this tutorial, I will show you how to sort by multiple columns in Google Sheets.

Let’s get started!

Sort by Multiple Columns In Google Sheets

Multi-level sorting can easily be done in Google (as it has in-built functionality to do this).

Below is the data set that I will use in this tutorial.

Here are the steps to sort by multiple columns in Google sheets:

  1. Select the entire dataset (A1:C13 in this example)
  2. Click the Data tab
  3. Click on the Sort range optionClick on Sort Range
  4. In the ‘Sort range’ dialog box, click on the ‘Data has header row option’. No need to check this in case you don’t have a header rowClick Data has header row
  5. In the Sort by drop-down, click on Region and the sort order as A –> ZSelect Region as the column and sort order
  6. Click on ‘Add another sort column’ optionClick on Add another sort column
  7. In the ‘then by’ drop-down, select Sales and the sort order as Z –> A (as we want the sorting from highest to lowest sale value)Set Sort then by settings in the sort dialog box
  8. Click on SortClick on Sort

The above steps would sort the dataset first by the Region column (alphabetically in ascending order) and then each region data is then sorted using the sales value (highest to lowest).

Sorted Data result

In this example, I have shown you how to do this with two columns, but you can sort by more than two columns as well using the same steps. Just repeat steps 6 and 7 for more columns.

Pro Tip: In case you may need to revert back to original data, add an additional column (I call these helper columns) and have serial numbers in it (1 in the first cell, 2 in the cell below it and so on). When you want to revert to the original order, simply sort based on this helper column.

So this is how you can easily sort by multiple columns in Google Sheets.

Hope you found this tutorial useful!

Other Google Sheets tutorials you may find useful:

Most Popular Posts

Sumit

Sumit

Sumit is a Google Sheets and Microsoft Excel Expert. He provides spreadsheet training to corporates and has been awarded the prestigious Excel MVP award by Microsoft for his contributions in sharing his Excel knowledge and helping people.

6 thoughts on “How to Sort By Multiple Columns in Google Sheets”

Leave a Comment