How to Sort Data in Google Sheets

Jun 7, 2021

In this guide, we'll show you how to use Google Sheets' sort function to sort data in a column of your spreadsheet.

What ways can data be sorted in Google Sheets?

Data or text can be sorted alphabetically (both ways) or numerically (both ways). You can also randomize data across a column, as well. In our guide, we'll show you how to do each of these.

Did you know you can create a CSV file from a Google sheet? Check out our guide to see how it's done.

Google Workspace

Howchoo is reader-supported. As an Amazon Associate, we may earn a small affiliate commission at no cost to you when you buy through our links.

Right-click the corresponding letter of the column that you're looking to sort in Google Sheets.

Select how you want to sort the data in the column of your Google Sheet.

Sort sheet A—Z: This will sort the sheet alphabetically or from lowest to highest, numerically.
Sort sheet Z—A: This will sort the sheet reverse alphabetically or from highest to lowest, numerically.
Randomize range: This will randomize the given column's data (reorder randomly).

If you found this article useful, visit our guide on how to get the sum of a column in Google Sheets and check out the latest list of keyboard shortcuts to help optimize your workflow.

NEXT UP

Michael (175)

Mar 23, 2021

In this guide, we'll show you how to add both a column and a row to your spreadsheet in Google Sheets. Can I add a blank column or row in Sheets without formatting?

How to Sort Data in Google Sheets

What ways can data be sorted in Google Sheets?

Right-click the top of the column you want to sort

Choose how you wish to sort the data