Home How to alphabetically sort a list in Google sheets

How to alphabetically sort a list in Google sheets

Data menu in Google sheets
Tutorial
Jan 12 2020

So you want to alphabetically sort your rows in your Google sheet spreadsheet? The sort functionality in a Google sheets is something every spreadsheet user should know. It's really pretty simple, so don't even think about doing it manually! 

Google sheets icon Try sorting with this sample data

Step 1: Get your data ready

Unsorted fruit names in a spreadsheet

Here you can see we have a list of fruit in a random order.

Step 2: Sort the column rows

Sorting rows in a column in Google sheets

Select the column you want to sort on, then click on Data > Sort sheet by column A, A->Z

Step 3: Sort on another column

Sort on column B

If you would like to sort the rows by a different column, select the column and select Data > Sort sheet by column B, A->Z

Related tutorials

Spread the word