How to Alphabetize an Excel Spreadsheet

The Sort feature in Excel 2010 and 2013 alphabetizes spreadsheets in a single click, sorting data in any column in either alphabetic direction. For more complex situations, such as spreadsheets with some duplicate cells, open the Sort window to customize the task to fit your needs.

Quick Sort

Step

Select the entire range in your spreadsheet to alphabetize. Click and drag across letter headings to select whole columns.

Select data.
credit: Image courtesy of Microsoft
Sort the selection.
credit: Image courtesy of Microsoft

Step

Open the Data tab and click the AZ or ZA icon to alphabetize the selection in either direction.

Advanced Sort

Step

Click Sort on the Data tab after selecting your data to open the Sort window.

Open the Sort window.
credit: Image courtesy of Microsoft
Set levels.
credit: Image courtesy of Microsoft

Step

Click Add Level to add additional tiers of sorting. Add as many levels as you have columns by which you want to sort. Set the Sort By and Then By drop-down menus to the columns you want alphabetized, starting with the first tier and continuing down.

Set the order and headers.
credit: Image courtesy of Microsoft

Step

Set the sorting order on each level. Each sorts separately, so you could sort the first level from A to Z but the second level from Z to A.

Step

Check My Data Has Headers if your columns have a header row above the data that needs sorting. Uncheck this option to sort every row in the selection.

Step

Click OK to sort the spreadsheet.