Can You Alphabetize in Google Sheets? Sorting Rows and Columns

Yes. In Google Sheets, select the data you want to organize and use Data > Sort range to sort text A to Z or Z to A. For a table with related columns, sort the whole range by the name column so each person’s other details stay on the same row.

How alphabetizing works in Google Sheets

Alphabetizing is a type of sorting: Sheets compares the values in a chosen column and rearranges cells or rows into ascending order (A to Z) or descending order (Z to A). It works with names, titles, places, product labels, and other text. You can sort a selected range, or sort the sheet by a column when you want its rows to move together.

Sorting is different from changing the text itself. A sort does not rewrite a person’s name or remove duplicates; it changes the order in which the records appear. For example, sorting a list of department names A to Z might place Accounting before Design and Sales, while repeated department names remain repeated.

Google Sheets also sorts numbers, dates, and other values. If a column mixes different kinds of content, the result may not look like a simple dictionary order. A date stored as a real date value is sorted as a date, whereas a date typed as text may be treated as text. Consistent data types make results easier to predict.

Alphabetize a range safely

For a table, select all the columns and rows that belong together, not just the column you want to sort by. Then open Data > Sort range > Advanced range sorting options. In the dialog, choose the sort column, select A to Z, and click Sort. If your selection includes a heading row, check Data has header row so the heading is not sorted in with the records.

Select the complete data range, including related columns such as email, team, or date.
Open Data > Sort range > Advanced range sorting options.
Indicate whether the selected range has a header row.
Choose the column containing the text to alphabetize and choose A to Z or Z to A.
Click Sort and check that a few records still have their original related details beside them.

For example, if a contact table has names in column A, email addresses in B, and cities in C, select all three columns for the data rows and sort by column A. Sorting only A2:A50 could leave the emails and cities in their old positions, pairing people with the wrong information. That mismatch is one of the most important sorting mistakes to avoid.

Sort a whole sheet or only one column

Use Data > Sort sheet when the records occupy the sheet in a consistent table and you want every row to move according to one column. Choose the relevant column and ascending or descending order. This is useful for a simple roster or inventory that spans the sheet. However, a sheet-wide sort can also move other content in those rows, so do not use it casually if the sheet contains separate tables, notes, or summaries.

Use Data > Sort range when you want to limit the operation to a particular block. This is usually the safer option when a worksheet contains multiple datasets. For a one-column list that has no information in adjacent columns, selecting the list and sorting it is straightforward. If adjacent columns hold details belonging to each entry, include them in the selected range even when only one column determines the order.

A header is a label, not a record. Either leave it outside the selected data rows or include it and mark the header-row option in the sort dialog. If the header is accidentally included as ordinary data, it may move into the list, and the first actual record may end up at the top of the range.

Sort by more than one column

Multi-column sorting is useful when the first sort column contains duplicates. In the advanced range sorting options, choose the primary column first, then use Add another sort column to set a secondary order. Sheets sorts by the primary criterion and uses the next criterion to order records that share the same primary value.

For example, a staff list could be sorted first by department A to Z, then by last name A to Z. Everyone in Accounting stays together, and the names within Accounting are alphabetized. You could add a third criterion, such as first name, if people share the same last name. Before applying several rules, confirm that the selected range includes every field in each record and that the header row is identified correctly.

Keep an automatically sorted copy with SORT

If you want to preserve the original order and show a sorted view elsewhere, the Google Sheets SORT function can return a sorted copy. It updates when the source data changes, unlike a one-time menu sort. Place the formula in an empty area with enough room for the results to expand; cells blocking the output can prevent it from displaying.

With names in A2:A5 and their teams in B2:B5, put this formula in an empty cell, such as D2, to return the complete two-column range alphabetized by the first column: =SORT(A2:B5,1,TRUE). If the rows are Mia—Sales, Arjun—Support, Chloe—Finance, and Zoya—Operations, the output is Arjun—Support, Chloe—Finance, Mia—Sales, and Zoya—Operations. The 1 tells Sheets to sort by the first column within the supplied range; TRUE requests ascending order. Use FALSE for descending order.

The formula does not rearrange the source cells. That distinction matters for reports, shared data-entry sheets, and any workflow where the original sequence carries meaning. If you need to physically reorder the source records, use the menu sort; if you need a live presentation of them, a formula-based copy may be a better fit.

Alphabetize with filters

Filters offer another convenient way to sort a table from its header. Select the table, choose Data > Create a filter, and use the filter icon in the heading of the column you want to sort. Choose Sort A to Z or Sort Z to A. The filter controls are also useful for temporarily hiding rows that do not meet a condition, while keeping the remaining records in the sheet.

A regular filter changes the visible sort order of the shared sheet, so collaborators may see that order too. If people need their own view without changing the view for everyone else, consider a filter view: use Data > Filter views > Create new filter view, then sort from the relevant column’s filter control. Filter views are helpful for reviewing a shared list in different ways without making separate copies of the data.

Common sorting problems and how to avoid them

Only one column moved: Sort the full record range, not an isolated field, whenever neighboring cells belong to the same records.
The heading appeared among the results: Exclude it from the selection or enable the header-row setting in the advanced range sort dialog.
The order looks unexpected: Check for leading spaces, inconsistent spelling, numbers stored as text, or dates entered in different formats. Clean up inconsistent values before sorting.
Some rows did not move: Confirm that the selected range includes every data row. Blank rows or separate blocks can make it easy to select only part of a table.
The sort seems inconsistent for accented or unusual characters: The spreadsheet’s locale can affect regional conventions. Review File > Settings and the spreadsheet locale if the expected language-specific order matters.

Also consider whether the current row order has a purpose. A list may be sorted by date, priority, or a manually assigned sequence. If you need to restore that order later, add a helper column containing an original sequence number before sorting. You can then sort by that helper column to return to the previous sequence, provided the number stays attached to each record.

Sorting usually reorders the selected cells; it is not the same as filtering or deleting. Still, for important shared data, consider making a copy or confirming that collaborators are not relying on the current order. If a result looks wrong, use the undo control promptly, before making further edits that you do not want to reverse.

Frequently Asked Questions

Can I alphabetize a single column without moving the other columns?
Yes, but do this only when the other columns do not contain details tied to each list item. If they do, sort the full table by that column instead; otherwise, the entries can become attached to the wrong details.

How do I sort names by last name?
If each cell contains a full name, a basic A-to-Z sort orders the text from the beginning of each cell, usually by first name. To sort by last name, put last names in a separate column or create a helper column that extracts them, then sort the complete range by that helper column.

Can I alphabetize in reverse order?
Yes. In the sort options, choose Z to A rather than A to Z. In a SORT formula, use FALSE for the ascending-order argument to return descending order.

Will new entries automatically stay alphabetized?
A menu sort is a one-time action; adding a new entry does not necessarily place it in the correct position. A SORT formula can show an automatically updated sorted copy, while leaving the original entries in their entry order.

Does Google Sheets have the same sorting steps as Excel?
The general idea is similar, but the menus differ. This guide uses Google Sheets in a web browser and its Data menu. Excel has its own Sort controls and dialogs, so do not assume the Google Sheets menu path is the same there.

Choosing the right method

For a quick, permanent rearrangement, select the whole table and sort the range by the desired column. For a very simple sheet-wide list, sorting the sheet can be convenient, provided there is no unrelated content that should stay put. Use a filter or filter view when you want sorting controls alongside temporary filtering, and use SORT when you need an automatically updated copy that leaves the source order untouched.

The essential rule is to keep each record together. Once you identify the complete range, mark its header correctly, and choose the appropriate A-to-Z or Z-to-A order, alphabetizing in Google Sheets is a built-in operation rather than a separate add-on or paid feature.

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.