In this article:

How to Sort in Google Sheets (The Easy Way!)

May 8, 2024

In this article we will show you exactly how to sort in Google Sheets. We cover how to sort data using the built in sort feature and by using the SORT function. Just follow the simple steps below:

How to Sort in Google Sheets using the Sort Feature

1. Select the range of data to sort

Data tables usually contain a header row. For this example we include them in the range. We will set the first Column with label Name as the reference for sorting the range. 

Sort data google sheets, select range

2. Click Data, choose Sort range, then select Advanced range sorting options

When you choose Sort range,  you will also get the two options Sort range by column A (A to Z) and Sort range by column A (Z to A). You can select either of them if you don’t include the header row in the range.

However, since we will include the header row in our range, select Advanced range sorting options.

Sort data google sheets, click data, choose sort range, select advanced range sorting options

3. Selected Advanced Sorting Options

A box will appear where you can set sorting options. You have several options to tweak the way you sort the selected range. 

Sort data google sheets, sorting options

If the range includes a header, tick the checkbox labeled Data has header row.

There is a header row in our example so we will tick this one. This will also change the list of columns to select as reference for sorting.

Sort data google sheets, tick data has header row

Next, you need to select which column to use as reference for sorting. Click the drop-down box and select the column. 

Sort data google sheets, select column labeled Name

Finally we set whether to sort in ascending or descending order.

For our example, we choose A->Z for ascending order. If you want to choose descending order, click Z->A. By default ascending order A->Z is selected.

Sort data google sheets, select ascending order A->Z

4. Click Sort

Sort on google sheets, click sort


Sort on google sheets, range sorted after clicking sort

The range is now sorted.

how to sort google sheets, sorted range

How to Sort Data in Google Sheets using the SORT Function


=SORT(Range, Column1, is_ascending1, Column2, is_ascending2)


=SORT: Calls the feature in Google Sheets

Range: The range with data to sort

Column1: The column in the range that will serve as reference for sorting. The count starts at 1, from left to right.

Is_ascending1: Specifies whether the rows are arranged in ascending or descending order. There are two possible values:

TRUE: ascending order (A->Z)

FALSE: descending order (Z->A)

Column2, is_ascending2: These are optional and are only applied when sorting multiple columns

You can specify more than one criterion using the function. Google Sheets will sort the range using column1 first, then column2, and so on. Check the example below to learn how to use this function.

1. Select an empty cell adjacent to the data

Make sure the adjacent cells to the data are blank.

sort function in google sheets, select cell for formula

2. Use the formula =SORT(RANGE,Column,is_ascending)

We identify the inputs to the SORT function:


Column: 1

Is_ascending: true

The formula becomes 

=sort(A2:A14, 1, TRUE)

The sheet now looks like below:

sort function in google sheets, insert formula to cell

3. Press enter to see the results

The sorted list will be displayed in ascending order (A-Z).

sort function in google sheets, sorted list alongside original list

More information about the function

Learn more about how to use the SORT function in Google Sheets here.

Conclusion: Which method should you use?

Now which of the two methods should you use in your Google Sheets? It really depends on what you need. 

If you want to permanently change the data, use the Sort feature.

If you want to keep the original list, use the Sort function.

This is not the only Google Sheets Sort article that we have here. Just search “google sheets sort” here in Lido and you will see more!

If you enjoyed this article, you might also like our article on how to extract a domain from email in Google Sheets or our article on how to count cells with specific text in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->