How to Sort Microsoft Excel Columns Alphabetically

Sorting Alphabetically

1. Format the header row. The header row is the top row of your spreadsheet, with the names of your columns. Excel will sometimes sort this row thinking it is part of your data, especially if your spreadsheet is entirely text. Here are a few ways to prevent this:

   1. Format your header row differently. For example, bold the text or make it a different color.^[1]
   2. Make sure there are no blank cells in your header row.^[2]
   3. If Excel still screws up the sort, select the header row and use the top ribbon menu to click Home → Editing → Sort & Filter → Custom Sort → My data has headers.^[3]

2. Select the column you wish to alphabetize. You can click the header cell for that column, or the letter above it (A, B, C, D, etc.).

3. Open the Data tab. Click Data in the top menu to view Data options in the ribbon menu above your spreadsheet.

4. Look for the Sort and Filter section. The ribbon menu is divided into related areas, with the name under each one. Look for the area labeled Sort & Filter.

   1. If you don't see it on the Data menu, try returning to the Home tab and looking for a Sort & Filter button in the Editing section.

5. Click the A → Z button. To sort the spreadsheet in alphabetical order, just click the A → Z symbol in the Sort and Filter section. This will rearrange the spreadsheet in alphabetical order of the selected column. On most versions of Excel, this button is in the top left corner of the Sort and Filter section.

   1. To sort it in reverse alphabetical order instead, click the Z → A symbol instead.