How to Sort and Alphabetize Columns in Excel
November 30, 2015 / / Comments Off on How to Sort and Alphabetize Columns in Excel
< 1 minute read

ABC is easy as 123 in Excel 2013/2016. With the click of a button, you’re able to sort and alphabetize any column you please. Whether you’re sorting through an attendance list for a recent webinar, or need to organize your inventory from A to Z, you’ll memorize these steps faster than you learned the alphabet.
Above is a video demonstrating two different methods for alphabetizing columns and below are the listed steps.
Method 1
- In an excel spreadsheet, find and highlight the column you want to alphabetize.
- Select the button Sort and Filter
- Click the drop down menu and select Sort A to Z
- A window will appear.
- Make sure Expand the selection is the chosen option.
- Click Sort
- Your selected column will sort.
Method 2
A second method to sort and alphabetize is to apply a filter.
- Highlight the column headers.
- Click Sort and Filter.
- A drop down menu will appear.
- Select Filter.
- Small grey squares will appear in the column headers.
Click the small square from the column you want to alphabetize, and select Sort A to Z.