How to Alphabetize in Google Sheets

To alphabetize in Google Sheets, select the data you want to organize, then choose Data > Sort range and sort by the column you want from A to Z. If the values belong to rows of related information, include the full table in the sort so names, details, and other fields stay together. Before sorting, check whether your selection has a header row and make a copy if the original order matters.

What You’ll Need

A Google Sheets spreadsheet open in a web browser with permission to edit it.
A column containing the text you want to alphabetize, such as names, products, or locations.
If the column is part of a table, identify the full range of related columns so each record can be sorted as one row.
For a safer workflow, especially with important data, make a copy of the sheet using File > Make a copy before sorting.

Step-by-Step

Review the worksheet. Find the column you want to sort and check what information belongs to each value. For example, a customer name in column A may be linked to an email address in B and an order date in C. Those cells should remain together as one record. Also look for blank rows, merged cells, and titles above the table; they can affect what Sheets recognizes as the range.
Choose the right sorting method. To alphabetize one list that has no related columns, you can sort just that column. To preserve complete records in a table, sort the entire table range by the chosen column. If you sort a selected name column by itself while adjacent columns contain related data, names can become paired with the wrong details.
Select the range to sort. Click and drag across the cells in the table, including all columns whose rows need to stay together. You can also click the first cell, hold Shift, and click the last cell in the range. If the table has a header, include its row in the selection so you can identify it in the sorting options. Do not include unrelated notes or a second table below it.
Open the range-sorting options. With the range selected, go to Data > Sort range > Advanced range sorting options. If the selected range begins with a header, turn on Data has header row. This tells Sheets to keep the headings at the top rather than sorting them among the records.
Choose the column to alphabetize. In the sort options, select the column whose text determines the order. If the header-row option is on, the list uses the header name; otherwise, identify the column by its letter. Check that the selected column is the one containing the values you intend to sort, not a neighboring field such as an ID or date.
Set the direction to A to Z. Choose A to Z for ascending alphabetical order, then click Sort. The selected rows move as a group according to the values in the chosen column. If you want reverse alphabetical order instead, choose Z to A. Wait for the sheet to finish updating and scan the first few and last few entries.
Sort a complete sheet when appropriate. If the whole worksheet is one table and you want to reorder every row, click a cell in the column to sort by, then choose Data > Sort sheet and select the A-to-Z option for that column. This sorts the sheet rather than only a highlighted block. Do not use this for a sheet containing separate tables or notes that must stay in place.
Use a filter for a sortable table. Select the table, including its header row, and choose Data > Create a filter. Click the filter icon in the header of the column you want to sort, then choose Sort A to Z. This sorts the table rows and leaves the header visible. To remove the filter controls later, choose Data > Remove filter.
Confirm the result. Check a few rows before and after the sort to make sure related values remained together and the header is still at the top. If you used a filter, verify that you are viewing all rows; a filter can hide entries without deleting them. If the result is wrong, use Edit > Undo immediately, then select the correct range and repeat the sort.

Common Mistakes

Sorting only one column in a multi-column table is the most damaging mistake. It rearranges the selected cells without necessarily keeping the rest of each record aligned. Select all columns in the table before sorting by one of them. If only one independent list is being alphabetized, sorting a single column is appropriate.

Forgetting to mark the header row can put a heading such as Name or Department into the alphabetized list. In the advanced range options, enable Data has header row when the selection includes a heading. Conversely, do not enable it if your selected range starts with an actual data record.

Including extra cells or missing part of the table can produce a confusing result. A heading above the table, a blank separator row, or an adjacent second list may be accidentally included; a selection that stops too early may leave some records unsorted. Check the highlighted range before opening the sort options.

Assuming a filter hides or removes data can lead to mistaken conclusions. A filter may display only matching rows, and a sort changes their order, but neither action is the same as deleting records. Clear filter criteria or remove the filter to inspect the full table.

Tips

Keep a consistent header row. Use one clear label per column and avoid merged header cells. A simple, uninterrupted table is easier to select and sort accurately.
Use a filter when you expect to sort repeatedly. The column menu gives you quick A-to-Z and Z-to-A options, and the header stays visible while you work. Filters are especially useful for shared lists that people need to inspect in different orders.
Sort by more than one field when names repeat. In Data > Sort range > Advanced range sorting options, use Add another sort column to set a secondary order. For example, sort by Last name A to Z, then by First name A to Z. The second rule organizes entries that have the same value in the first sort column.
Decide how to handle blanks before sorting. Empty cells can appear separately from populated entries, depending on the sort and selected range. If blank rows divide the list into sections, remove or fill those gaps where appropriate before sorting, or select only the continuous table rather than the entire column.
Be consistent about names and text. Alphabetical sorting uses the cell contents as stored. A leading space, inconsistent spelling, or a value stored differently from the rest can make an entry appear out of place. Clean up the data if you need a precise, predictable list, and check the boundary cases after sorting.
Know the Excel difference. These instructions use Google Sheets in a browser. In Excel for Microsoft 365 on Windows, select the table and use the Data tab’s sort controls or the Sort dialog; the menu paths and options are not identical to Google Sheets.

Troubleshooting

The heading moved into the list. Undo the sort with Edit > Undo. Select the table again, open Data > Sort range > Advanced range sorting options, and enable Data has header row. Then choose the correct column and sort again.

Names no longer match their email addresses or other details. Undo as soon as possible. Reselect the full table, not just the name column, and sort that range by the name field. If Undo is no longer available, use version history via File > Version history > See version history to inspect or restore an earlier version. Check the version carefully before restoring, because doing so can also reverse other edits.

Some rows did not move. Look for a selection that ended before the last record, a blank row splitting the data, or a filter that is showing only part of the list. Clear filter criteria, inspect the table boundaries, and sort the complete continuous range. If a blank row is intentional, sort separate sections independently rather than moving unrelated content.

The order looks incorrect even though A to Z is selected. Inspect the actual cell contents for leading spaces, misspellings, inconsistent punctuation, or values that are not plain text. Click a few entries and review the formula bar to see what is stored. Correct the inconsistent values and repeat the sort. If the list contains accented letters or mixed scripts, review the result carefully because expected dictionary order may depend on how the characters are interpreted.

The sort controls are unavailable. Confirm that you have edit access, that a range or relevant cell is selected, and that the sheet is not protected against the changes you are trying to make. If the file is open in view-only mode, request editing permission from its owner. In a filtered table, use the filter icon in the header rather than looking for a sort option on an unrelated cell.

Frequently Asked Questions

How do I alphabetize a single column without changing other columns?
For an independent list, select only the cells in that column and sort the selected range A to Z. If the values are connected to information in adjacent columns, do not sort the column alone; select the full table so each row stays intact.

Can I alphabetize a column but keep the header at the top?
Yes. Select the table including its header, choose Data > Sort range > Advanced range sorting options, and enable Data has header row. Then sort by the column heading you want.

How do I sort names by last name?
If each cell contains a full name, a basic A-to-Z sort orders by the first characters in the cell, usually the first name. To sort by surname reliably, put last names in a separate column, then sort the full table by that column. This also handles names with multiple parts more predictably.

Can I sort in reverse alphabetical order?
Yes. In the range-sorting options choose Z to A, or use the filter menu for the column and select Sort Z to A. This puts entries in descending alphabetical order.

Will sorting change the data permanently?
Sorting changes the current row order, but it does not erase the values. Use Edit > Undo right after a sort to reverse it. For an important worksheet, make a copy first or check version history if you need to recover an earlier arrangement.

Can I alphabetize several columns in sequence?
Yes. In the advanced range sorting options, choose the primary column and use Add another sort column for a secondary rule. For example, sort a staff list by department first and by last name second, making sure the full table is selected.

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.