How to Alphabetize in Excel and Google Sheets

To alphabetize a list, select a cell in the column and choose an A-to-Z sort; to keep related details attached to each name, sort the entire table or expand the selection when prompted. In Excel for Microsoft 365 on Windows, use the Data tab’s sort controls. In Google Sheets, use Data > Sort sheet or Sort range. Before sorting, check that your data has clear headers and that each row’s details belong together.

What You’ll Need

An Excel workbook open in Microsoft 365 for Windows, or a Google Sheets spreadsheet open in a web browser.
A list or table with the text you want to alphabetize. If each item has related information, such as an email address or department, keep that information in the same row.
A header row, if your list has one. A label such as “Name” helps you identify the column and prevents it being sorted as an ordinary entry.

You do not need a special formula or add-on for a standard A-to-Z sort. If other people are editing the file, make sure you have permission to change the data and, in Sheets, consider whether they may be sorting or editing at the same time.

Step-by-Step

Check the layout before sorting. Look across several rows and confirm that each record is complete: for example, a person’s name is in one column and that person’s phone number is in the next. Remove completely empty rows from the middle of the data if they divide the list into separate blocks. Keep the header at the top, and do not include unrelated notes or totals in the range you plan to sort.
Choose whether to sort one column or the whole dataset. If the column contains standalone items, such as a list of book titles with no matching information, sorting just that column is fine. If adjacent columns contain details for each item, sort the full table so that a row remains intact. For instance, sorting only the names in a contact list could leave each name beside someone else’s email address.
In Excel, click a cell in the column you want to sort. For a simple contiguous table, click any populated cell in the target column rather than highlighting only its text cells. On the Windows ribbon, open Data and, in the Sort & Filter group, choose Sort A to Z. Excel will generally detect the surrounding data and ask whether to expand the selection if sorting the chosen column could separate it from other columns.
Keep Excel rows together when prompted. In the sort warning, choose Expand the selection, then click Sort, if the neighboring columns belong to the same records. Choose Continue with the current selection only when you deliberately want to rearrange that column by itself. If Excel does not show a warning and you are unsure what it selected, undo the sort with Ctrl+Z and select the full table before trying again.
Use Excel’s Sort dialog for headers or more control. Select the table, including its header row, then go to Data > Sort. In the dialog, check My data has headers if the first row contains labels. Set Sort by to the column name, set Sort On to Cell Values, and set Order to A to Z. Click OK. If you selected only the data rows, leave the header out of the selection and do not treat the first data row as a header.
In Google Sheets, sort an entire sheet when the records fill the sheet. Click a cell in the column you want to use as the key, then choose Data > Sort sheet and select the A-to-Z option for that column. This sorts rows across the sheet based on the chosen column. If your sheet has a header row, use a filter or the range-sorting options below so the header is not mixed into the data.
In Google Sheets, sort a specific table or range. Select the complete range, including all columns that belong to each record. Choose Data > Sort range > Advanced range sorting options. Check Data has header row if the selected range includes headers. Choose the column to sort by, choose A → Z, and click Sort. If you selected only data rows, omit the header and leave the header-row option unchecked.
Use a filter for a convenient repeat sort in either app. In Excel, select the dataset and choose Data > Filter; use the arrow in the target column’s header to choose an ascending sort. In Sheets, select the range with its header row and choose Data > Create a filter; open the filter icon in the target header and choose Sort A to Z. The filter menu makes it easy to switch the sort key without selecting the range again.
Verify the result. Check the first and last few entries and scan across the rows to confirm related details stayed with the right item. If the order looks wrong, use Undo immediately (Ctrl+Z on Windows) and check the selected range, header setting, and values before sorting again. In Sheets, changes are saved automatically, but Undo still reverses the most recent action.

On Excel for Mac, the sorting options are also on the Data tab, although the ribbon layout may differ. On Excel for the web, use its Data tab and sort controls; wording or placement can vary slightly by interface. For Mac, Ctrl+Z is usually Command+Z. Google Sheets in a browser uses its own menu paths described above; do not follow Excel ribbon directions when working in Sheets.

Common Mistakes

Sorting only one column in a multi-column table. This is the most damaging error because it disconnects entries from their related details. Sort the whole table or expand Excel’s selection when asked.
Including the header as a data item. A header such as “City” may end up in the middle of the list. In Excel’s Sort dialog, mark My data has headers; in Sheets’ range options, mark Data has header row.
Selecting an incomplete range. A sort can leave some rows behind if the table has blank columns, blank rows, or notes that make the data boundary unclear. Select the entire dataset deliberately and check the first and last row in the selection before applying the sort.
Expecting a sort to understand parts of a name. An A-to-Z sort orders the cell contents as they are stored. It does not automatically sort a “First Last” entry by last name. If you need surname order, put surnames in a separate column and sort by that column.
Assuming visually similar values are identical. Leading spaces, inconsistent punctuation, spelling variations, and numbers stored as text can make a list appear out of order. Clean up inconsistent entries before sorting, and check the underlying cell values if the result is surprising.

Tips

Make the data easy to recognize. Keep one header row, avoid merged cells in the dataset, and do not insert decorative blank rows between records. Simple rectangular data is easier for both apps to detect and sort reliably.
Use a secondary sort for ties. In Excel’s Data > Sort dialog, choose Add Level to sort first by one column and then by another, such as last name followed by first name. In Sheets’ advanced range sorting options, use Add another sort column for a second key. The first key remains the primary order.
Remember that A-to-Z is ascending, not necessarily “letters only.” A column containing numbers, punctuation, blanks, or mixed types may not look like a simple dictionary list. Excel and Sheets can order mixed content according to the values and data types they detect. If the expected order matters, keep each column’s contents consistent and inspect unusual entries.
Check locale-dependent ordering. Accented characters and language-specific letters may appear in an order that differs from an English alphabet. Google Sheets uses the spreadsheet’s locale for regional settings; check File > Settings if the order seems unexpected. Excel’s behavior can also depend on the text and sorting settings available in the app.
Keep a copy before a major rearrangement. For a small, reversible sort, Undo is usually enough. For a shared or important dataset, duplicate the sheet or save a copy of the workbook first, especially if you are unsure whether all associated columns are included.
Use filters when you sort often. An enabled filter keeps column headings visible and provides a sort menu on each heading. It is useful for changing between alphabetical order and other views without repeatedly selecting the whole range.

Troubleshooting

The rows no longer match their names. Undo the sort immediately. Then select the full table, including every column that belongs to each record, and sort again. In Excel, choose Expand the selection if a warning appears. In Sheets, use Sort range on the complete table rather than sorting a single isolated column.

The header was sorted into the list. Undo, then repeat the sort with the header option enabled in Excel’s Sort dialog or Google Sheets’ advanced range options. Alternatively, select only the data rows beneath the header and sort that range, making sure not to include the heading.

The list still looks out of order. Look for leading spaces, hidden characters, inconsistent spellings, or entries with different data types. A cell that looks like a name may contain a space before the first letter. Edit or standardize the values, then sort again. For numbers that are meant to be numeric, make sure they are stored as numbers rather than text.

Only part of the list moved. Check for blank rows or columns that split the dataset, and inspect the selected range. Select the full rectangular table explicitly before sorting. If the sheet contains separate tables, sort each one separately rather than including unrelated content.

The A-to-Z option is unavailable or the sort is blocked. Confirm you have selected a cell or range, and check whether the sheet or range is protected or view-only. In a shared Google Sheet, request edit access if needed. In Excel, check whether the workbook is protected and whether the selected cells are part of a structured table with restrictions.

The order differs for accented letters or symbols. Check the file’s locale and the exact characters in the cells. Different regional sorting rules can place accented letters and punctuation differently. If you need a particular language’s dictionary order, use consistent text and confirm the spreadsheet’s regional settings rather than assuming English A-to-Z rules apply.

Frequently Asked Questions

Can I alphabetize a single column without changing the other columns?
Yes, but do this only when the column is independent. In Excel, choose to continue with the current selection if the sort warning appears. In Sheets, sort only the selected range. If neighboring cells describe the same records, keep the rows together instead.

How do I sort by last name when first and last names share one cell?
A normal A-to-Z sort uses the beginning of the whole cell, so it sorts “Alex Rivera” by Alex, not Rivera. Put last names in a separate column, then sort the complete table by that column. This also handles compound surnames more reliably than trying to split every name by a space.

Can I alphabetize from Z to A?
Yes. Choose the descending option: Z to A in Excel, or the reverse-order sort option in Google Sheets. In a filter menu, choose the descending sort for the target column.

Will sorting change the original order permanently?
Sorting rearranges the cells in the current range or sheet. Use Undo immediately to restore the previous order. If you need to preserve the original sequence as well, add an index column with the original row numbers or make a copy before sorting.

Why are blank cells or numbers appearing in unexpected places?
Blank cells and mixed types do not behave like ordinary words in an alphabetic list. The apps sort based on the values and types they recognize, and blank entries may be grouped separately. Remove unwanted blanks and keep each column consistent; verify the result after sorting.

Can I alphabetize automatically as I add new entries?
A standard sort does not continually reorder a list as you type. Sort again when the list changes, or use a filter’s sort command. In Google Sheets, a formula-based sorted view is another option, but it displays a separate result rather than rearranging the original entries.

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.