How to sort in Google Sheets

Google Sheets packs many convenient features, one of the more vital ones being 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.

See also: How to find, highlight, and remove duplicates in Google Sheets

How to sort in Google Sheets on a computer

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

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.

Scroll down to the option that says Sort range, then click Advanced range sorting options. 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, select the checkbox.

The line that says Sort by is your opportunity to decide how to organize your data. As we’re using a contact list, we’ll 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.

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 triple-dot icon.

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

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

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

FAQs