New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Sort and filter›Sort alphabetically

Google Sheets · Verified tutorial

Sort alphabetically in Google Sheets

Sort the range A1:B5 alphabetically by Name from A to Z, keeping the header row.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Sort the range A1:B5 alphabetically by Name from A to Z, keeping the header row.

Step-by-step

1

Open the practice sheetUse the example data shown below so the result is easy to check.

2

Sort alphabeticallySort the range A1:B5 alphabetically by Name from A to Z, keeping the header row.

3

Check the resultCompare the finished sheet with the expected result and correct the target range if needed.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

The data rows are ordered Anna, Ben, Cara, Dev.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Re-select A1:B5 and repeat the final action. The data rows are ordered Anna, Ben, Cara, Dev.

Example spreadsheet data

This is the clean fixture used for the verified run.

Name	Team
Cara	Blue
Anna	Green
Dev	Blue
Ben	Green

Video transcript

Open the prepared Practice spreadsheet.
Open the practice sheet. Use the example data shown below so the result is easy to check.
Sort alphabetically. Sort the range A1:B5 alphabetically by Name from A to Z, keeping the header row.
Check the result. Compare the finished sheet with the expected result and correct the target range if needed.
The data rows are ordered Anna, Ben, Cara, Dev.