How to alphabetize in Google Sheets
Click any cell in the column you want to alphabetize, then go to Data → Sort sheet → Sort sheet by column A to Z (or Z to A). To sort only part of the sheet, select the range first and use Data → Sort range. Turn on “Data has header row” so titles stay put. For a live sorted copy, use the SORT formula instead of permanently rearranging the sheet.
Steps
-
1
Click a cell in the column to alphabetize.
-
2
Open Data → Sort sheet → A to Z (or Z to A).
-
3
For a partial list, select the range → Data → Sort range.
-
4
Check “Data has header row” when your first row is labels.
Related tutorials
These videos might help you go deeper on this topic.
Ian Asks: How to sort dates by year/month (can't do with filter)
How To Sort A Filter
Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
sorting data in Sheets
Sorting reorders rows by one or more columns. The Data > Sort range menu sorts selection in place. The SORT function ...
Open →SORT
SORT reorders rows from an input range and spills the result elsewhere. Source data stays put, unlike Data > Sort ran...
Open →Google Sheets formulas
A formula is an instruction in a cell that calculates a result from other cells, ranges, or built-in functions. Every...
Open →Google Sheets formula syntax
Every formula starts with = followed by a function name and arguments in parentheses. Ranges use A1 notation, text si...
Open →Freeze rows and columns
Freezing locks the top rows or left columns in place while the rest of the sheet scrolls. View > Freeze lets you pin ...
Open →COLUMN()
Google Sheets COLUMN() function guide
Open →SORT()
Google Sheets SORT() function guide
Open →Related questions
How to alphabetize a column in Google Sheets
Click a cell in the column to alphabetize, then Data → Sort sheet → A to Z (or Z to A). For part of the sheet, select the range and use Data → Sort range with “Data has header row” checked. Use the SORT formula when you want a sorted view that stays linked to the source.
Get the answer →How to alphabetize rows in Google Sheets
Click a cell in the column to alphabetize, then Data → Sort sheet → A to Z (or Z to A). For part of the sheet, select the range and use Data → Sort range with “Data has header row” checked. Use the SORT formula when you want a sorted view that stays linked to the source.
Get the answer →How to auto alphabetize in Google Sheets
Click a cell in the column to alphabetize, then Data → Sort sheet → A to Z (or Z to A). For part of the sheet, select the range and use Data → Sort range with “Data has header row” checked. Use the SORT formula when you want a sorted view that stays linked to the source.
Get the answer →How to alphabetize by last name in Google Sheets
Click a cell in the column to alphabetize, then Data → Sort sheet → A to Z (or Z to A). For part of the sheet, select the range and use Data → Sort range with “Data has header row” checked. Use the SORT formula when you want a sorted view that stays linked to the source.
Get the answer →How to alphabetize in Google Sheets and keep rows together
Click a cell in the column to alphabetize, then Data → Sort sheet → A to Z (or Z to A). For part of the sheet, select the range and use Data → Sort range with “Data has header row” checked. Use the SORT formula when you want a sorted view that stays linked to the source.
Get the answer →How to merge cell in Google Sheets
Select the cells, then Format → Merge cells (or the toolbar Merge icon). Choose Merge all, horizontally, or vertically. Only the top-left value is kept. Avoid merging inside data tables you still sort or filter.
Get the answer →Need more than a quick answer?
Membership unlocks 636+ tutorials, unlimited generators, and every template.