Google Sheets Alphabetize a Column: A Practical Guide

To alphabetize a column in Google Sheets, select a cell in your data and choose Data > Sort sheet > Sort sheet by column [letter] (A to Z). If the column belongs to a table with other information, sort the whole table or its complete range so each row stays together.

Alphabetize a sheet with the quick sort command

The quick sort is useful when your data forms one table and you want every row rearranged according to one column. Click a cell in the column you want to sort, open Data, choose Sort sheet, and select the option for that column in A to Z order. For reverse alphabetical order, choose the corresponding Z to A option. The column letter in the menu depends on where your data is.

For example, if a contact list has names in column A and phone numbers in column B, sorting the sheet by column A puts the names in alphabetical order while moving each phone number along with its name. A to Z is ascending order; Z to A is descending order. Sorting changes the order of the existing rows rather than making a separate copy of the list.

Before sorting, check whether unrelated data sits elsewhere on the same sheet. A sheet-wide sort is intended to rearrange rows together, but separate blocks, notes, or summaries on the same sheet can make the result confusing. If the sheet contains multiple independent tables, use a range sort on only the relevant table instead.

Sort a selected range and keep rows together

Use a range sort when you want to control exactly which cells are included. Select all columns and rows that belong to the table, including the column you want to sort by. Then go to Data > Sort range. In the sorting options, choose the sort column and A to Z or Z to A. If the menu offers Advanced range sorting options, that opens the dialog where you can identify a header row and add further sort columns.

Suppose a table occupies A1:C20, with names in A, departments in B, and start dates in C. Selecting only A1:A20 and sorting can separate names from their departments and dates. Instead, select A1:C20, open the range-sorting options, indicate that the first row contains headers, and sort by the name column. Each complete row then moves as a unit.

A good rule is to select the full rectangle of related data, not just the values you want to alphabetize. Include the header if you want to tell Sheets that the first row is labels, and include every column whose values must remain associated with each record. Avoid including a neighboring table that should not be rearranged.

Tell Sheets whether the first row is a header

A header is a label such as Name, City, or Product, not an ordinary value in the list. When sorting a selected range, use the option that says the data has a header row if the first selected row contains those labels. Sheets can then sort by the named field without treating the label as a regular entry. If the range has no header, leave that option off and choose the appropriate column by its letter or position.

For example, if row 1 contains Customer, Region, and Order, and customer records begin in row 2, mark the first row as a header before sorting. If you select only rows 2 through 20, the header is already outside the range, so the header-row setting is not needed. Getting this distinction right prevents a label from being moved into the body of the list or excluded from the intended sort in an unexpected way.

If the table has more than one header row, merged cells, or decorative title rows above the data, consider selecting just the actual data range and its single field-name row. A simple rectangular table is easier for Sheets to sort reliably than a layout designed mainly for printing.

Use the SORT function for a separate alphabetized copy

If you want to preserve the source order and display a sorted copy elsewhere, Google Sheets has the SORT function. With names in A2:A10, enter =SORT(A2:A10,1,TRUE) in an empty cell. The result is an ascending sorted list; change TRUE to FALSE for descending order. The first argument is the range, the second identifies the sort column within that range, and the third sets the direction.

For a table with names in A and departments in B, and records in A2:B10, put =SORT(A2:B10,1,TRUE) in an empty area. The formula sorts the rows by the first column of the range and returns both columns together. That is often safer than sorting a names-only copy if the department needs to remain paired with each person.

The formula output expands into the cells it needs, so keep that destination area clear. Do not place it on top of the source data or other values. A formula-based sort updates when the source values change, whereas a menu sort rearranges the current data in place. Use a bounded range such as A2:A100 when you know the list size; an open-ended range can include many blank cells and may be less convenient to manage.

Sort by more than one column

Alphabetizing by one field is not always enough. A directory might need to be grouped by city and then alphabetized by last name within each city. In the range-sorting dialog, add a second sort column after the first: choose City as the primary sort and Last Name as the next sort. Sheets applies the first criterion to group the records, then uses the second to order records that share the same first value.

For example, a sheet with City, Last Name, and First Name can be sorted first by City A to Z and then by Last Name A to Z. If several people have the same last name, add First Name as another criterion. Select the entire related table before applying the sort, and identify the header row where appropriate. This produces a stable, readable directory without manually sorting each city’s subset.

Use the order of the criteria intentionally: the first sort field has the greatest effect on the overall order. Sorting first by first name and then by city will not create city groups in the same way as sorting first by city.

Sort with a filter when you want to explore data

For a table you will sort or filter repeatedly, choose Data > Create a filter after selecting the table or placing the active cell in it. Filter controls appear in the header row. Open the control for the target column and choose its A-to-Z or Z-to-A sort option. The filter menu also lets you filter which records are shown, so you can narrow a list and sort the visible data for review.

A filter is not the same as a separate sorted copy: it works with the table and can hide rows that do not match selected conditions. If you need a saved alternative ordering while leaving the shared sheet’s current view undisturbed, consider a filter view where available from the Data menu. This is useful in collaborative sheets because people may need different temporary views of the same records. Check which view is active before making edits or sharing instructions with collaborators.

Common sorting problems and how to avoid them

Only one column moved: You may have sorted a single column instead of the full table. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then sort the complete range. Undo is most useful before you make more changes.
The header appears among the results: Reopen the range sort options and set the header-row option correctly, or exclude the header by selecting only the data rows.
Some entries look out of place: Check for leading spaces, inconsistent spelling, or values stored in different formats. For instance, a value with an accidental space before its first letter may not behave as expected in a clean alphabetical list. Clean or standardize the source values before sorting.
Numbers and text are mixed: A column containing entries such as 2, 10, and text labels may not sort like a column of consistently formatted names. Decide whether the values should be treated as numbers or text, then standardize them as needed.
Only part of the table was sorted: Confirm that the selected range includes every relevant row. Blank rows or separated sections can make a table boundary harder to identify, so select the exact range deliberately.

For names with accents, non-Latin characters, or language-specific ordering conventions, the spreadsheet’s locale can affect how data is interpreted and sorted. You can review the file’s locale under File > Settings. Avoid assuming that every language’s alphabetic conventions match English A-to-Z ordering. If a result matters for publication or official records, inspect the sorted output and confirm that it follows the ordering convention your audience expects.

Choose the right method for your task

Use a sheet sort when the sheet is one coherent table and you want its rows reordered in place. Choose a range sort when the sheet has separate blocks or you need to specify headers and multiple sort keys. Use the SORT function when you need a live, separate result that does not rearrange the source. Use a filter when sorting is part of reviewing a larger table or narrowing it to particular records.

Before choosing, ask three questions: Do related values in other columns need to move with each item? Should the source data itself change order? Is there a header row? Those answers usually identify the safest method. For a one-time cleanup of a simple contact list, a sheet or range sort is quick. For a report that should update as source values change, a formula-generated copy is more suitable.

How Google Sheets sorting differs from Excel

The central idea is the same in Google Sheets and Microsoft Excel: sort the complete set of related rows by the selected field, and indicate whether the first row is a header when the dialog asks. The menu paths differ. In Google Sheets in a browser, use the Data menu and its sheet, range, or filter sorting options. In Excel for Microsoft 365 on Windows, sorting is on the Data tab, where A-to-Z and Z-to-A controls and the Sort dialog are available. Excel may also ask whether to expand the selection if only one column is selected; choose the full selection when the columns belong together. Do not assume that the same menu labels or dialog wording appear in both products.

Frequently Asked Questions

Can I alphabetize one column without changing the other columns?

Yes, but only do that when the column is genuinely independent. If each row represents a record with related information, sorting one column alone breaks those relationships. Sort the complete table or range instead.

How do I sort a column from Z to A?

Choose the descending option: Data > Sort sheet for a sheet-wide sort, or the relevant range or filter sort option, then select Z to A. In a SORT formula, use FALSE for the ascending-direction argument.

Can Google Sheets alphabetize automatically when I add a new name?

A menu sort does not automatically maintain alphabetical order after later edits. A SORT formula can display an updated sorted copy when its source range changes, provided its output area is clear and the formula’s range includes the new entry.

Why did my header move when I sorted?

The selected range may not have been marked as containing a header, or you may have sorted a range that excluded the header. Set the header-row option correctly in the range sort, or select only data rows and keep the header outside the range.

Can I alphabetize a list and keep duplicate names?

Yes. Sorting orders the entries; it does not remove duplicates. If duplicate values occur, they remain in the list. To distinguish records with the same name, sort by another field as a second criterion, such as department or email address.

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.