How To Sort In Google Sheets

Last Updated on November 1, 2023 by Jake Sheridan

In this tutorial, you will learn how to sort in google sheets.

If your data is out of order in Google Sheets, it can be difficult to find the information you’re looking for and compare values. Fortunately, Google Sheets makes it easy to sort data in just a few clicks. Read on to learn how.

Quick Sorting A Range

If you want to sort a range by a single column, you can typically use the quick sorting menu option which takes only a few clicks to use:

Step 1

Select the range you want to sort, then open the Data menu and hover over the Sort Range submenu and choose between the A-Z and Z-A sort order options

Step 2

Your data will be sorted. Note that the column you select first is the column Google Sheets will use to sort by, so if you want to sort columns A and B by column B, start by selecting column B and then hold down shift and select column A

Step 3

Note also that if you have frozen rows at the top of the sheet, they will be treated as headers and not sorted

Quick Sorting the Entire Sheet

Quick sorting the entire sheet works much the same as quick sorting a range:

Step 1

Instead of selecting the range to sort, select the column you wish to sort by

Step 2

Then open the Data menu and simply hover over the Sort Sheet submenu instead of the Sort Range submenu and choose a sort order

Advanced Sorting

If you need to sort by more than one column or get more control over the sorting, you can use advanced sorting.

Here’s how:

Step 1

Select the range you want to sort by. Open the Data menu, hover over Sort Range and choose Advanced Range Sorting Options

Step 2

If your data contains headers, check the box labeled Data Has a Header Row

Step 3

Choose the first column to sort by from the dropdown and select the desired sort order

Step 4

If you would like to sort by additional columns, click the Add Another Sort Column button and repeat Step 3 for this column

Step 5

Click the green Sort button and your data will be sorted


Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to sort in google sheets. Want more? Check out all the Google Sheets Tutorials.