Alphabetize Google Sheets: Sort Data the Right Way

Yes. In Google Sheets, select the data you want to organize and use Data > Sort range to arrange it from A to Z or Z to A; for a table, include every related column so each row stays intact. You can also use the SORT function to create an automatically ordered copy of a range.

Alphabetize a range in Google Sheets

For a basic sort in a browser, select the cells to arrange, then open Data > Sort range > Advanced range sorting options. In the dialog, choose the column that should determine the order and select A to Z for ascending order or Z to A for reverse order. If your selection includes a header row, check Data has header row so the heading is treated as a label rather than a record.

For example, if a list of customer names is in column A from A1 to A30 and row 1 contains the heading Name, select the data range and mark that it has a header. Choose Name as the sort column and A to Z. Google Sheets moves the rows into alphabetical order while keeping the heading at the top. The same approach works for a selected block of cells containing a smaller list.

A to Z sorts text in ascending order and is usually the option for alphabetizing.
Z to A reverses that order.
For dates and numbers, the same controls sort by date or numeric value rather than by the characters in their display.

Sort a complete table without separating its rows

If names are in column A and each person’s email, department, and start date are in columns B through D, sort the full table—not just the name cells. Select the table range, including the related columns, and then choose the name column as the sort key. Sheets will rearrange complete rows, so each person remains paired with their own details.

Another option is sorting the entire sheet by a column. Click a cell in the column you want to use, then choose Data > Sort sheet > Sort sheet by column A (A to Z), substituting the relevant column for A. This is useful when the worksheet is one continuous table and you want its rows kept together. Be cautious if the sheet contains separate tables or notes elsewhere: sorting the sheet can move those cells too. For a specific table within a larger worksheet, select that table and use Sort range instead.

Before sorting, check whether the table has a single header row and whether there are blank rows or columns splitting it into sections. A selection that stops short of a related column can make the records appear mismatched afterward, even though the sort itself worked as requested.

Choose the right sort range and header setting

The sort range is the set of cells Sheets will rearrange. A common safe practice is to select the complete rectangular table, from its first heading through its last record and last related column. In the advanced sort dialog, identify whether the first selected row contains headings. If you leave the header option unchecked, the heading may be sorted into the data. If you check it when the range has no header, Sheets may leave the first actual record out of the sort.

For a simple one-column list with no associated information, selecting just that list is fine. But when a column belongs to a wider record, selecting only that column is risky: names could move while emails or other values stay put. If the sheet contains multiple independent blocks, sort only the intended block rather than the whole sheet. A clear, consistently shaped table makes these choices much easier.

Use SORT to make an automatically ordered copy

The SORT function produces a sorted result in a separate area, leaving the original data in place. This is helpful when new entries are added to a source list and you want a second view in alphabetical order. The function sorts rows based on a selected column in the range; its sort-column number is relative to the range, so 1 means the first column of that range, not necessarily worksheet column A.

Assume A2:C5 contains these records: Mina, 18, Seattle; Ava, 21, Boston; Noah, 16, Denver; and Leo, 20, Austin, with names in column A and the other details in B and C. Enter this formula in an empty cell outside the source range: =SORT(A2:C5,1,TRUE). It returns the four complete rows in name order: Ava, Leo, Mina, and Noah, with each person’s number and city staying on the same row.

Leave enough blank cells below and to the right of the formula for the result to expand. If those cells are occupied, Sheets cannot display the full sorted output. Because this is a formula result, edit the original records rather than trying to type over individual cells in the output. Function argument separators can depend on spreadsheet locale; if Sheets reports a formula parse error, check the locale’s expected separator in the spreadsheet settings.

Sort by more than one column

A-Z sorting can also use secondary criteria. In Advanced range sorting options, set the primary sort column first, then add another sort column if the first values repeat. For example, sort a staff list by Department A to Z, then by Last name A to Z. Sheets groups the same departments together and alphabetizes names within each group.

Multiple sort keys are useful for inventories and schedules too. A product list could be sorted first by category, then by product name; a booking table could be sorted first by date, then by time. The first key has priority, so the second key only determines the order among rows tied under the first key. Make sure each chosen column has consistent data: a mixture of actual dates and text that merely looks like dates can produce an order that seems unexpected.

What alphabetical order means for different data

Alphabetizing is straightforward when every cell contains a plain text name, but real sheets often mix text with numbers, dates, blanks, or values entered in different formats. Sorting is based on the underlying cell values and types, not always on how a value looks on screen. For example, a real date is treated as a date value, while a date typed as plain text may be treated as text. Similarly, a number stored as text may not sort like a numeric value.

Leading spaces, inconsistent spelling, and extra punctuation can also affect where entries appear. A name with an unintended space at the beginning may not fall where you expect, and two visually similar entries may be different strings because one contains an extra character. If the result looks wrong, inspect a few of the underlying cells and standardize the data before sorting. Avoid deleting punctuation or spaces indiscriminately, though: characters may be meaningful in product codes, addresses, or names.

Blank cells deserve attention as well. They can appear at an end of the sorted results, and an empty row inside a table may make it less obvious which records belong together. Remove or fill gaps only when appropriate, and do not assume that a visually blank cell is truly empty; it might contain a formula that returns an empty string.

Common sorting problems and how to prevent them

The header moved into the list: reopen the sort options and set the header-row checkbox correctly, or select the data rows without the heading.
Names no longer match their details: undo the sort immediately if possible, then sort the entire table range rather than a single column.
Only part of the table changed: check the selected range. Include all columns that belong to those records.
The order looks inconsistent: check for mixed data types, leading spaces, blank rows, or text that looks like a number or date.
The formula result will not appear: clear cells in the output area so the sorted array can expand.

After a manual sort, Google Sheets’ Undo command can reverse the latest action, but it is safer to inspect the selected range before sorting, especially in a shared or important spreadsheet. If you are unsure, make a copy of the sheet first. Sorting changes where records appear, so it can affect what collaborators see, even though it does not delete the records.

Manual sorting versus a formula

A manual sort is best when you want to change the order of the original records—for example, to prepare a roster for printing or arrange an inventory for review. It is direct and does not require a formula output area. A formula sort is better when the original order should remain untouched, or when a sorted view should update as the source range changes. The formula view is a separate result, not a replacement for the source data.

Filters offer another way to work with a table. Use Data > Create a filter to add filter controls to the header row, then open the control for the relevant column and choose a sort order. A filter is useful when you also want to narrow which records are shown. Keep in mind that sorting through a filter still affects the order of the underlying rows; it is not the same as making a separate formula-based copy.

Frequently Asked Questions

Can Google Sheets alphabetize a column automatically?
Yes. Use SORT in an empty area to create a sorted result that updates when its source range changes. If you want to rearrange the original records instead, use the Data menu to sort the range or sheet.

How do I sort names A to Z without moving the header?
Select the full table, open Data > Sort range > Advanced range sorting options, check Data has header row, and choose the name column with A to Z order.

Can I sort rows by last name?
Yes, if last names are in their own column: choose that column as the sort key. If full names are stored together in one cell, Sheets sorts the text in that cell; it does not automatically identify which part is a first or last name.

Why did sorting one column scramble my table?
You likely sorted a range that contained only that column while related information was outside the selection. Undo if you can, then select the complete table and sort it by the desired column so each row moves together.

Can I alphabetize in reverse order?
Yes. Choose Z to A in the sort options for a descending text order. The corresponding descending option can also be used when sorting dates or numbers.

Does sorting change the original order permanently?
A manual sort changes the row order in the sheet, though Undo can reverse the latest change. A SORT formula instead displays a sorted copy while leaving the source range in its existing order.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.