How to Sort Data in Google Sheets

Use the sort function to sort through your spreadsheet.
Michael Michael (174)

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.

Google WorkspaceGoogle Workspace ×1

Howchoo is reader-supported. When you buy through links on our site, we may earn a small affiliate commission at no cost to you.

Right-click to of column Google Sheets

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

Sort sheet Google Sheets

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

  1. Sort sheet A—Z: This will sort the sheet alphabetically or from lowest to highest, numerically.
  2. Sort sheet Z—A: This will sort the sheet reverse alphabetically or from highest to lowest, numerically.
  3. Randomize range: This will randomize the given column's data (reorder randomly).
To create a drop-down list, you "group" the rows.
Michael Michael (174)

In Google Sheets, you create a drop-down list by "grouping" the rows of your spreadsheet.