Google Sheets Alphabetize Function: Sort Data A to Z

Google Sheets does not have a function named ALPHABETIZE; use the SORT function to create an alphabetized result, or use the Data menu to sort your existing table. For example, with names in A2:A5, enter =SORT(A2:A5,1,TRUE) in an empty cell to return them in A-to-Z order.

What the Google Sheets alphabetize function means

People searching for an alphabetize function usually want one of two things: a formula that displays text in alphabetical order, or a command that rearranges rows in a sheet. Google Sheets supports both tasks, but they work differently. The formula is called SORT, while the menu options are under Data.

SORT does not change the source cells. It reads a range and returns an ordered copy elsewhere. Menu sorting, by contrast, rearranges the selected range or sheet itself. Knowing which result you want matters: a formula is useful for a live view that updates as source entries change, while a menu sort is useful when you want the original table put in order.

There is no need to install an add-on for ordinary alphabetizing. The built-in function handles text, numbers, and multiple sort keys. It can also sort complete rows, which is essential when names are associated with addresses, scores, or other details.

Use SORT to return an A-to-Z list

The basic syntax is SORT(range, sort_column, is_ascending, [sort_column2, is_ascending2, ...]). The first argument is the cells to sort. The next argument identifies the column to sort by, and the third sets the direction. Use TRUE for ascending order and FALSE for descending order.

With the names Maya, Liam, Ava, and Noah in A2:A5, enter this in an empty cell outside that source range:

With names in A2:A5, this formula returns Ava, Liam, Maya, and Noah in that order: =SORT(A2:A5,1,TRUE)

Because the range contains only one column, the sort-column value is 1. The resulting list appears down the cells below the formula. Leave those cells empty so the result can expand; existing content in the output area can prevent the formula from displaying its full result.

For reverse alphabetical order, use FALSE. With the same names in A2:A5, the output is Noah, Maya, Liam, and Ava: =SORT(A2:A5,1,FALSE)

A formula can be placed on another sheet as well. For example, enter it in a cell on a separate tab and refer to the source tab in the range, such as =SORT(Contacts!A2:A100,1,TRUE). This keeps the sorted view apart from the original list.

Sort full rows without separating related data

If a name is in one column and its associated details are in other columns, sort the whole rectangular range. Sorting just the name column can detach names from their phone numbers, scores, or other row values. Include every column that belongs together in the range argument.

Suppose A2:C5 contains these records: Maya, Blue, 82; Liam, Red, 91; Ava, Blue, 88; and Noah, Red, 79. To sort the complete rows by the name in the first column, use:

With records in A2:C5 and names in column A, this returns Ava, Blue, 88; Liam, Red, 91; Maya, Blue, 82; and Noah, Red, 79: =SORT(A2:C5,1,TRUE)

The value 1 means the first column within the supplied range, not necessarily column A on the sheet. If the range were B2:D5, a sort-column value of 1 would mean column B, and 2 would mean column C. This relative numbering is a common source of mistakes when the selected range starts partway across a sheet.

Sort by more than one column

Multiple sort keys let you alphabetize within groups. Using the same records, sort first by Team and then by Name. In this range, Team is the second column and Name is the first, so the formula has two column-and-direction pairs.

With the records in A2:C5, this sorts Team A to Z and then Name A to Z within each team: =SORT(A2:C5,2,TRUE,1,TRUE)

The result puts the Blue rows together, with Ava before Maya, followed by the Red rows, with Liam before Noah. You can set each direction separately; for example, a later key could be descending while the first key remains ascending. In a formula, each additional sort key is another column number followed by TRUE or FALSE.

Multiple keys are especially helpful for contact lists organized by department and surname, or inventory arranged by category and product name. If two records have identical values for every sort key, their relative order may not be a useful way to distinguish them; add another key, such as an ID column, when a consistent tie-breaker is important.

Use the Data menu to alphabetize in place

To rearrange existing cells rather than create a formula result, select the data and choose a sort command from the Data menu in Google Sheets in a web browser. For a table with a header row, include the full table in the selection and use Data > Sort range > Advanced range sorting options. Enable the option indicating that the data has a header row, choose the column, and select A to Z.

For a quick sort of a complete sheet by one column, use Data > Sort sheet and choose the column and direction. Check the selection before sorting: a range sort affects the selected range, whereas a sheet sort is intended to order the sheet’s rows. If a table contains related values in adjacent columns, include those columns so the complete records move together.

A menu sort is often more convenient when you want a one-time, permanent rearrangement. It is also a good choice when the data includes formatting or layout details that a formula-generated view would not reproduce as a simple sorted list. If you need a live sorted copy that preserves the original order, use SORT instead.

Headers, blanks, and changing data

For a formula, exclude the header row from the sorted range unless you deliberately want the header treated as data. For example, if row 1 contains Name and the entries begin in row 2, use A2:A rather than A1:A. The open-ended range can include future entries added farther down the column, but it may also include empty cells. A bounded range such as A2:A100 is easier to control when you know the expected size of the list.

With a menu sort, mark the header row when using the advanced range sorting options. Otherwise, the heading can be treated as an ordinary value and moved into the records. When sorting a whole sheet, frozen rows help keep headings visible, but freezing a row is not a substitute for correctly identifying a header in a range sort.

Formula results update when values in the referenced range change, but the formula needs room to display the updated result. If new source data is added below a bounded range, expand the range or use an open-ended reference. Also check that the destination cells are clear if the formula reports that its array result could not expand.

Alphabetical order, duplicates, and unique values

SORT sorts; it does not remove duplicates. If the goal is a clean list of distinct names in alphabetical order, combine the Google Sheets functions UNIQUE and SORT. For example, with Maya, Liam, Ava, and Liam in A2:A5, this returns Ava, Liam, and Maya once each:

With names in A2:A5, this formula removes repeated values and sorts the remaining names A to Z: =SORT(UNIQUE(A2:A5),1,TRUE)

Duplicates may be meaningful in a dataset, so do not remove them merely to make a sorted table look cleaner. Two identical names could represent two different customers or transactions. If you need to preserve every record, sort the complete rows instead of applying UNIQUE to a name column.

Alphabetical sorting is not the same as sorting by a hidden meaning in the text. A product code such as Item 12 is still text, and the sort does not necessarily interpret the number as a numeric value in the way a person would expect. If codes need a special order, use a separate numeric or category column as a sort key. Accented characters and other language-specific text can also be ordered according to the spreadsheet’s locale. You can review that setting through File > Settings.

Common problems and how to fix them

The formula gives a parse error: Check commas, parentheses, and the spelling of SORT. Depending on spreadsheet locale, a sheet may expect different formula argument separators; use the separator accepted by that file.
The result is not visible: Clear cells beneath and beside the formula where its array output needs to appear. The formula cannot overwrite existing values.
Only one column moved: The selected range may have included only that column. Sort the full table range so each row’s related values remain together.
The heading moved into the data: Start a formula range below the heading, or mark the header row in the advanced range sorting options.
The order looks unexpected: Confirm the sort-column number is relative to the range, check whether the direction is ascending, and consider whether the values are text, numbers, or locale-specific characters.

In Google Sheets, formula argument names and menu choices are distinct from Excel’s interface. Excel also offers sorting features, but its menu paths and behavior can differ; the steps above refer to Google Sheets in a web browser.

Frequently Asked Questions

Does Google Sheets have an alphabetize function?
No. There is no built-in function named ALPHABETIZE. Use SORT in a formula for an ordered output, or use the Data menu to rearrange existing data.

How do I alphabetize a column in Google Sheets?
For a formula result, with entries in A2:A, put =SORT(A2:A,1,TRUE) in an empty cell. To sort the original data, select the relevant range and choose an A-to-Z sort from Data.

How do I alphabetize a list but keep the rows together?
Include the complete table in the formula range or menu selection, then sort by the column containing the names. Sorting only the names column can separate them from their related row data.

Can I sort a list in reverse alphabetical order?
Yes. In SORT, set the ascending argument to FALSE. In the Data menu, choose the Z-to-A direction.

Can Google Sheets alphabetize automatically when I add a name?
A SORT formula recalculates its displayed result as source values change, provided the referenced range includes the new entry and the output area is clear. A menu sort does not create a live sorted view; run it again when you want to reorder the data.

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.