How to Alphabetize in Excel

Sort information exactly as you need it

Marnie Burkhart/Corbis/Getty Images

Excel’s neat columns, tidy rows and compatibility with other MS Office programs make it the ideal application for entering and storing text-based lists. Once you have all that information entered, you can sort it to meet your needs with no more than a few clicks of the mouse. 

Learning how to alphabetize in Excel as well as some other ways to sort text can save you tons of time and give you more control over the data you need to use. 

Discover the steps for virtually every version of Microsoft Excel including 2016, 2013, 2010, 2007 and 2003 or earlier as well as Excel for Mac 2016, 2011, 2008 and 2004. You can even perform some basic sorting using Excel online with Office 365.

How to Sort Alphabetically in Excel

The simplest way to alphabetize a column in Excel is to use the Sort feature. Where you find this feature depends on which version of Excel you are using.

In Excel 2003 and 2002 for Windows or Excel 2008 and 2004 for Mac, follow these steps.

  1. Make sure there are no blank cells in the list.
  2. Click on any cell in the column you want to sort. 
  3. Select Data on the toolbar and choose Sort. The Sort dialog box will open.
  4. Choose the column you want to alphabetize in the Sort By box, select Ascending
  5. Click OK to sort the list alphabetically.

In Excel 2016, 2013, 2010 and 2007 for Windows; Excel 2016 and 2011 for Mac; and Office Excel Online, sorting is simple as well.

  1. Make sure there are no blank cells in the list.
  2. Click Sort & Filter in the Editing section of the Home tab. 
  3. Select Sort A to Z to alphabetize your list.

Sort Alphabetically by Multiple Columns

If you want to alphabetize a range of cells in Excel using more than one column, the Sort feature enables you to do so, as well.

In Excel 2003 and 2002 for Windows or Excel 2008 and 2004 for Mac, follow these steps.

  1. Select all of the cells that you want to sort by alphabetizing two or more lists in the range.
  2. Select Data on the toolbar and choose Sort. The Sort dialog box will open.
  3. Select the primary column by which you want to alphabetize the data in the Sort By box and select Ascending
  4. Choose the second column by which you want to sort the range of cells in the Then By list. You can sort by up to three columns.
  5. Select the Header Row radio button if your list has a header at the top. 
  6. Click OK to sort the list alphabetically.

In Excel 2016, 2013, 2010 and 2007 for Windows or Excel 2016 and 2011 for Mac, sorting is simple as well. (This feature is not available in Office 365 Excel Online.)

    1. Select all of the cells that you want to sort by alphabetizing two or more lists in the range.
    2. Click Sort & Filter in the Editing section of the Home tab. 
    3. Select Custom Sort. A Sort dialog box will open.
    4. Select the My Data Has Headers check box if your lists have a headers at the top. 
    5. Select the primary column by which you want to alphabetize the data in the Sort By box.
    6. Choose Cell Values in the Sort On box.
    7. Select A to Z in the Order box. 
    8. Click the Add Level button at the top of the dialog box. 
    9. Select the second column by which you want to alphabetize the data in the Sort By box.
    10. Choose Cell Values in the Sort On box.
    11. Select A to Z in the Order box. 
    12. Click Add Level to sort by another column, if desired. Click OK when you are ready to alphabetize your table.

    Advanced Sorting in Excel

    In certain situations, sorting alphabetically just won’t do. For instance, you may have a lengthy list containing the names of months or weekdays that you would like to sort chronologically. Excel will tackle this for you, as well.

    In Excel 2003 and 2002 for Windows or Excel 2008 and 2004 for Mac, select the list you want to sort.

    1. Select Data on the toolbar and choose Sort. The Sort dialog box will open.
    2. Click the Options button at the bottom of the dialog box.
    3. Click the dropdown arrow in the First Key Sort Order list and choose the sort option you want to use. 
    4. Click OK twice to sort your list chronologically.

    In Excel 2016, 2013, 2010 or 2007 for Windows and Excel 2016 and 2011 for Mac, select the list you want to sort. sorting is simple as well. (This feature is not available in Office 365 Excel Online.)

    1. Click Sort & Filter in the Editing section of the Home tab. 
    2. Select Custom Sort. The Sort dialog box will open.
    3. Click the dropdown arrow in the Order list and choose Custom List. The Custom Lists dialog will open.
    4. Choose the sort option you want to use. 
    5. Click OK twice to sort your list chronologically.

    Even More Sort Features

    Excel provides numerous ways to enter, sort and work with virtually any kind of data. Check out 6 Ways to Sort Data in Excel for more helpful tips and information.