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
Select the entire range in your spreadsheet to alphabetize. Click and drag across letter headings to select whole columns.
Open the Data tab and click the AZ or ZA icon to alphabetize the selection in either direction.
Click Sort on the Data tab after selecting your data to open the Sort window.
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 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.