Best daily deals
Best daily deals

Links on Android Authority may earn us a commission. Learn more.

How to sort in Google Sheets

Don't get out of sorts scouring your spreadsheets.
By
February 28, 2022

Google Sheets packs many convenient features to help you through your tasks. For instance, one vital feature is the ability to sort your data in alphabetical and numerical order to make sense of it all. Here’s how to sort in Google Sheets to save you time.

Read more: How to find, highlight, and remove duplicates in Google Sheets

QUICK ANSWER

To sort in Google Sheets, select Data--> Sort range-->Advanced range sorting options.


KEY SECTIONS

How to sort in Google Sheets on a computer

One everyday use for a spreadsheet is keeping track of your contact list, so for this example, we’ll demonstrate how to alphabetize a contact list. Before you can begin sorting, you’ll have to decide what data is important. Start by selecting all of the rows and columns you plan to use.

sort in google sheets 1 1200x564 1
Adam Birney / Android Authority

Now head up to the Data tab. This is where you’ll manage your sorting, whether you choose to sort your Google Sheet by column or other criteria.

sort in google sheets 2 1200x562 1
Adam Birney / Android Authority

Scroll down to the option that says Sort Range. This should open a menu box. In our case, we’ve chosen not to highlight the header line, but if your data has a header line, select the checkbox.

sort in google sheets 3 1200x561 1
Adam Birney / Android Authority

The line that says Sort By is your opportunity to decide how to organize your data. As we’re using a contact list, we will sort by last name (Column B). Open the dropdown list to select the column and choose between the A → Z or Z → A buttons. Then click Sort.

sort in google sheets 4 1200x564 1
Adam Birney / Android Authority

You should now see all of your contacts organized alphabetically by last name, making locating clients or staff easy. You can follow the same steps if you’re looking to sort by date too.

How to sort in Google Sheets on Android or iOS

To select a column, tap a letter at the top. Then tap the column again to open the menu. From there, tap More, represented by the three-dot icon.

more mobile sheets
Adam Birney / Android Authority

Scroll down and tap SORT A-Z or SORT Z-A.

sort A-Z mobile
Adam Birney / Android Authority

As you can see, Google will then sort the data accordingly.

sorted column
Adam Birney / Android Authority

A quick sort can help you save plenty of time finding specific information in spreadsheets.

FAQs

Is there a sort function in Google Sheets?

Yes, a basic example of the sort function would be =SORT(range, column_index, ascending_order).

Why can’t I sort by date in Google Sheets?

Make sure all of your date values are valid. One easy way to do this is to use the DATEVALUE function.