AjapaReporter

Home life · Updated

How to Alphabetize a Column in Excel

Time it takes5 min
Steps6in the list below
LevelEasyno special skills
Official sourceMicrosoft Supportcheck it for changes

Quick answer Select the column, go to the Data tab, and click the A→Z button to sort alphabetically. For more control, use the Sort dialog to sort by that column while keeping other data in place.

What You’ll Need

  • Microsoft Excel (desktop, web, or mobile) with your data already in a worksheet.
  • Your data should be in a single column or a table where each row represents one record.
  • If your column has a header row, note it—you’ll need to tell Excel whether to include it in the sort.

Step-by-Step

  1. Select the column – Click the letter at the top of the column (e.g., “A”) to highlight the entire column. If you only want to sort a few cells, select just those cells instead.
  2. Open the Sort options – Go to the Data tab on the ribbon. In the Sort & Filter group, you’ll see buttons labeled A→Z and Z→A. For alphabetical order (A to Z), click A→Z.
  3. Confirm the sort warning – If your column has adjacent data, Excel will show a dialog asking whether to expand the selection. Choose Expand the selection to keep rows together, then click Sort. If you choose Continue with the current selection, only the selected column will be sorted, which can scramble your data.
  4. Check the result – Your column should now be sorted alphabetically. If you used the expand option, all other columns in each row moved with it, so your records remain intact.
  5. Use the Sort dialog for more control – For a more precise sort, click Data → Sort. In the dialog, choose the column you want to sort by from the Sort by dropdown. Set Sort On to Values and Order to A to Z. If your data has headers, check the My data has headers box at the top right. Click OK.
  6. Sort by multiple columns if needed – In the Sort dialog, click Add Level to add a second column to sort by. For example, sort by Last Name first, then by First Name. This is useful when you have duplicate values in the first column.

Common Mistakes

  • Sorting only one column – If you select just a single column and sort, Excel will reorder that column independently, breaking the links to other columns in the same row. Always expand the selection or use the Sort dialog.
  • Including the header in the sort – If you don’t tell Excel your data has a header, the header row will be sorted along with the data, moving it to the middle of your list.
  • Sorting cells with formulas – If your column contains formulas, sorting will recalculate them based on their new positions. Make sure the formulas are relative and not referencing cells that will move unexpectedly.
  • Hidden rows or columns – Sorting will reorder hidden rows too, which can cause confusion if you forget they are there. Unhide everything before sorting.

Tips

  • Use a Table – Convert your data range to an Excel Table (Ctrl+T) before sorting. Tables automatically keep rows together and make sorting more intuitive.
  • Sort by cell color or icon – In the Sort dialog, you can change Sort On to Cell Color or Font Color to sort by formatting, not just text.
  • Sort numbers as text – If your column has numbers stored as text, they may sort as 1, 10, 2, 20 instead of 1, 2, 10, 20. To fix this, convert them to numbers first (select the column, click the warning icon, and choose Convert to Number).
  • Undo quickly – If you make a mistake, press Ctrl+Z (or Cmd+Z on Mac) immediately to undo the sort.
  • Sort by custom list – For non-alphabetical orders (like months or weekdays), use Data → Sort → Order dropdown → Custom List to choose a predefined list.

Troubleshooting

Data got scrambled – If your rows are mixed up, you likely sorted only one column. Undo (Ctrl+Z) and redo the sort with Expand the selection or use the Sort dialog. If you already closed the file, you may need to restore from a backup.

Header moved into the data – This happens when Excel doesn’t recognize your header. In the Sort dialog, check the My data has headers box. If you used the quick A→Z button and the header got sorted, undo and then select only the data range (not the header) before sorting.

Sort doesn’t work on merged cells – Merged cells can block sorting. Unmerge all cells in the column before sorting. Select the column, go to Home → Merge & Center and choose Unmerge Cells.

Numbers sort incorrectly – If numbers are stored as text, they sort alphabetically (1, 10, 2). Select the column, click the warning icon that appears, and choose Convert to Number. Or use the Text to Columns wizard to convert them.

Sort is grayed out – This usually means the sheet is protected or the range is part of a table with filters. If the sheet is protected, go to Review → Unprotect Sheet. If it’s a table, click anywhere in the table and use the filter arrows in the header row to sort.

Frequently Asked Questions

How do I sort a column alphabetically without messing up other columns?

Select the entire data range (all columns and rows) before sorting, or use the Sort dialog and choose Expand the selection when prompted. That way, Excel moves whole rows together.

Can I sort by the second word in a cell?

Yes. Use the Sort dialog, choose the column, then in Sort On select Values. In the Order dropdown, choose Custom List and then Options. There you can set the sort to be case-sensitive or choose a different delimiter, but for sorting by the second word, you’d need to split the text into separate columns first (using Text to Columns).

Why does Excel sort “10” before “2”?

Because those numbers are stored as text. Excel sorts text alphabetically, so “10” comes before “2”. Convert the cells to numbers (select the column, click the warning icon, choose Convert to Number) to fix it.

How do I sort a column in descending order (Z to A)?

Click the Z→A button on the Data tab, or in the Sort dialog set Order to Z to A.

Can I sort by multiple columns at once?

Yes. In the Sort dialog, click Add Level to add more columns. Excel will sort by the first column, then by the second within ties, and so on.

What if my column has blank cells?

Blank cells are typically placed at the bottom when sorting ascending (A to Z) and at the top when descending (Z to A). If you want to move blanks elsewhere, you can use a helper column with a formula like =IF(A2=””,1,0) and sort by that first.

Sources: Microsoft Support. Menus and buttons can differ slightly by version. Spotted something out of date? Tell us.