Skip to content

How to Sort and Alphabetize Columns in Excel

< 1 minute read

academy bg

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.

Sign up for our newsletter