• Home

  • Productivity

  • App tips

App tips

4 min read

How to sort in Google Sheets

By Jessica Lau · January 22, 2024
A hero image for Google Sheets app tips with the Google Sheets logo on a green background

Scrolling through endless rows of data in Google Sheets is a surefire way to give yourself a headache. The powers-that-be anticipated this, which is why Google Sheets offers plenty of built-in functionality to help you find the information you need. 

One of those tools: the sort function. With it, you can quickly reorganize data alphabetically, by date, or by numerical order. Here's how to sort in Google Sheets. 

If you need to narrow down your data even further, check out our guide on applying filters.

Table of contents

  • How to alphabetize in Google Sheets

  • How to sort by date in Google Sheets

  • How to sort by multiple columns in Google Sheets

How to sort in Google Sheets

For this tutorial, I'm using a simple spreadsheet containing a handful of Marvel movies, along with their release date and opening box office numbers. 

Marvel box office data in Google Sheets.

Types of sorting

Google Sheets offers two basic data sorting options:

  • Sort sheet organizes all the data in your spreadsheet based on a specific column, keeping related information across each row together. In the example below, I applied Sort sheet in ascending alphabetical order to column B. Notice how the movie titles are listed alphabetically, along with their corresponding rank, opening weekend sales, and release date. 

    Example of data organized using the sort sheet function in Google Sheets.

  • Sort range organizes only the selected cell range without altering the rest of the sheet. In the example below, notice how the movie titles in column B are sorted alphabetically, but the other information—rank, opening numbers, and release date—stayed in their original cells. 

    Example of how to organize data using the sort range function in Google Sheets.

One other thing: Let's say you highlight two columns and apply Sort sheet or Sort range. By default, Google Sheets will organize everything based on the data in the leftmost column of your selection. 

In the example below, there's a new column with names of actors next to the Movie column. 

Updated Marvel box office data including a column of actors' names in Google Sheets.

When I sort the spreadsheet alphabetically based on the cell range B3 to C12 (movie titles and actors' names), Google Sheets organizes the information based on movie titles—not actors' names. 

Example of data organized in a Google Sheets spreadsheet using the leftmost column of data in a cell range.

Now let's get into the steps of how to sort in Google Sheets. 

How to alphabetize in Google Sheets 

Since you're most likely to organize data across your entire spreadsheet—not just within a cell range—here's the easiest way to sort your spreadsheet by alphabetical order.

For this demo, I want Google Sheets to reorganize my spreadsheet based on movie titles in ascending alphabetical order.

  1. Open your spreadsheet. 

  2. If your spreadsheet includes a header row or column titles, freeze these rows. This way, Google Sheets won't consider that data when reorganizing. 

    Google Sheets spreadsheet with the row of column headers frozen.

  3. Highlight the cell range you want to sort.

  4. Click Data, and then select Sort sheet. If you want to sort only a cell range, click Sort range

  5. Select Sort sheet by [selected column] (A to Z) or Sort sheet by [selected column] (Z to A).  

    How to sort in Google Sheets using the sort sheet function.

That's it. 

How to sort by date in Google Sheets

It's not obvious how to sort by date in Google Sheets, but I swear it's easy to do.  

Follow the same steps as above, but click Sort sheet by [selected column] (A to Z) to organize your dates from least to most recent (as shown in the example below); click Sort sheet by [selected column] (Z to A) to organize from most to least recent.

Example of how to sort by date in Google Sheets.

The same concept applies if you want to organize data by numerical value, too. A is considered the lowest number, and Z is considered the highest number.

How to sort by multiple columns in Google Sheets

Now that we've covered the basics, it's time to go over more advanced sorting options.  

Let's say a few movies in our Marvel spreadsheet share the same release date. Now I want to list the movies from newest to oldest release, and if any films share the same release date, I want them listed from highest to lowest opening box office numbers. 

Here's how to sort by multiple columns in Google Sheets. 

  1. Highlight your cell range, including the column headers. 

  2. Click Data > Sort range > Advanced range sorting options

  3. Click Data has header row. This allows you to sort your data without first freezing the header rows. It also automatically populates the column headers for you to choose from in the Sort by dropdown in the next step. 

  4. Click the dropdown next to Sort by and select the first column you want to sort on. In this scenario, that's Release date. Then select the order you want the data listed in: A to Z or Z to A

  5. Click Add another sort column

  6. Click the dropdown next to then by and select the next column that you want to sort by. In this scenario, that's Opening. Then select the order you want the data listed in. 

  7. Click Sort

    Example of how to sort multiple columns in Google Sheets.

You're all set. 

Example of Google Sheet spreadsheet sorted using data from multiple columns.

Automate Google Sheets

Google Sheets is a great app for storing and making sense of data—that is, if you can stay on top of entering the data you need into your spreadsheets in the first place.

With Zapier, you can connect Google Sheets with your other apps, so you can automatically do things like add form responses to your spreadsheet or sync your data across different spreadsheet apps. Learn more about how to automate Google Sheets, or get started with one of these workflows.

Collect new Typeform responses as rows on Google Sheets

Collect new Typeform responses as rows on Google Sheets
  • Typeform logo
  • Google Sheets logo
Typeform + Google Sheets

Add new Airtable records in views to Google Sheets

Add new Airtable records in views to Google Sheets
  • Airtable logo
  • Google Sheets logo
Airtable + Google Sheets

Add new Excel rows to Google Sheets

Add new Excel rows to Google Sheets
  • Microsoft Excel logo
  • Google Sheets logo
Microsoft Excel + Google Sheets

To get started with a Zap template—what we call our pre-made workflows—just click on the button. It only takes a few minutes to set up. You can read more about setting up Zaps here.

Related reading: 

  • How to use conditional formatting in Google Sheets

  • How to add a dropdown list in Google Sheets

  • How to use pivot tables in Google Sheets

  • How to use VLOOKUP in Google Sheets

  • How to make a table in Google Sheets

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
See how Zapier works
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'