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

1. In an excel spreadsheet, find and highlight the column you want to alphabetize.
2. 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.
3. Click Sort
   • Your selected column will sort.

Method 2

A second method to sort and alphabetize is to apply a filter.

1. Highlight the column headers.
2. Click Sort and Filter.
   • A drop down menu will appear.
   • Select Filter.
3. 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.