How to Sort Using Two or More Columns in Google Sheets

Learn how to set two or more sort columns in Google Sheets

Table of Contents

1. How to sort using two or more columns in Google Sheets

Table of contents
Chapter 1
Chapter 2
Chapter 3

1. How to sort using two or more columns in Google Sheets

2 Minutes

Structured data often contains several columns for identifying information that can be used to sort the data. These include dates, locations, and customer groups. Google Sheets allows users to set two or more sort columns. In this tutorial, we will learn how to set two or more sort columns. Are you ready?


How to sort using two or more columns in Google Sheets

Step 1. Select all the data to be sorted.

Data to be sorted.


We want to sort by Country first (stored in Column A) then by City (stored in Column B). 


Step 2. Click Data in the main menu, then click Sort range in the drop-down box. Another list will appear to the right. Click Advanced range sorting options

Data option in main toolbar, Sort range option, Advanced range sorting options.


Step 3. The box labeled Sort range for *selected range* will appear.

Sort range options.


If the data has a header row, click the checkbox Data has header row. The label will change to the headers stored in the header rows.

Sort range options. Data has header row checkbox ticked.


By default, the first column is selected. As the country information is in Column A (now shown as Country in the drop-down box), we will keep the option as is.


Additionally, by default, the sort is in ascending order, indicated as A -> Z in the box. To sort the list in descending order, click the button besides Z -> A.


Step 4. The important step: click Add another sort column. The same options will appear. IN this case, we then sort by the City, which we select in the drop-down box. We will keep the default ascending order as well.

Sort range options. Two columns set. Both in ascending order.


Step 5. Repeat Step 4 to add a third sort column or more. For our example, we just need two columns. After adding all the necessary columns, click the Sort button.


Our table is now sorted.

Same data after sorting.


Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

March 10, 2022

How to Sort Using Two or More Columns in Google Sheets

Google Sheet spreadsheet

Structured data often contains several columns for identifying information that can be used to sort the data. These include dates, locations, and customer groups. Google Sheets allows users to set two or more sort columns. In this tutorial, we will learn how to set two or more sort columns. Are you ready?


How to sort using two or more columns in Google Sheets

Step 1. Select all the data to be sorted.

Data to be sorted.


We want to sort by Country first (stored in Column A) then by City (stored in Column B). 


Step 2. Click Data in the main menu, then click Sort range in the drop-down box. Another list will appear to the right. Click Advanced range sorting options

Data option in main toolbar, Sort range option, Advanced range sorting options.


Step 3. The box labeled Sort range for *selected range* will appear.

Sort range options.


If the data has a header row, click the checkbox Data has header row. The label will change to the headers stored in the header rows.

Sort range options. Data has header row checkbox ticked.


By default, the first column is selected. As the country information is in Column A (now shown as Country in the drop-down box), we will keep the option as is.


Additionally, by default, the sort is in ascending order, indicated as A -> Z in the box. To sort the list in descending order, click the button besides Z -> A.


Step 4. The important step: click Add another sort column. The same options will appear. IN this case, we then sort by the City, which we select in the drop-down box. We will keep the default ascending order as well.

Sort range options. Two columns set. Both in ascending order.


Step 5. Repeat Step 4 to add a third sort column or more. For our example, we just need two columns. After adding all the necessary columns, click the Sort button.


Our table is now sorted.

Same data after sorting.


Suscribe to get more data and analytics tips!

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.