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.

Video of the Day

Quick Sort

Select data.
credit: Image courtesy of Microsoft

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

Sort the selection.
credit: Image courtesy of Microsoft

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

Advanced Sort

Open the Sort window.
credit: Image courtesy of Microsoft

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

Set levels.
credit: Image courtesy of Microsoft

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

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.


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.


Click OK to sort the spreadsheet.

Show Comments