How to Alphabetize in Excel

Content
  1. Sort information exactly the way you want it
  2. How to Sort Alphabetically in Excel
  3. Sort alphabetically by multiple columns
  4. Advanced sorting in Excel
  5. More sorting functions

Sort information exactly the way you want it

Excel’s neat columns, neat rows and compatibility with other MS Office programs make it an ideal application for entering and saving text lists. Once you have entered all this information, you can sort it according to your needs with just a few clicks.

Learning the alphabetical alphabet in Excel, as well as some other ways to sort text, can save you a lot of time and give you more control over the data you need to use.

Check out the instructions for almost every version of Microsoft Excel, including 2016, 2013, 2010, 2007, and 2003 or earlier, and Excel for Mac 2016, 2011, 2008, and 2004. You can even do some basic sorting with Excel online with Office 365.

How to Sort Alphabetically in Excel

The easiest way to alphabetize a column in Excel is to use the Sort function. Where you find this feature depends on the version of Excel you’re using.

V Excel 2003 and 2002 for Windows or Excel 2008 and 2004 for Mac do the following.

  1. Make sure there are no empty cells in the list.

  2. Click a cell in the column you want to sort.

  3. Select Facts on the toolbar and select Kind † The Sort dialog box opens.

  4. Select the column you want to alphabetize in the Sort by box, select Ascending

  5. Click Okay to sort the list alphabetically.

V Excel 2016, 2013, 2010 and 2007 for Windows; Excel 2016 and 2011 for Mac; and Office Excel Online sorting is also simple.

  1. Make sure there are no empty cells in the list.

  2. Click Sort and filter in the Edit section of the Home tab.

  3. Select Sort from A to Z to alphabetize your list.

Sort alphabetically by multiple columns

If you want to alphabetize a range of cells in Excel with more than one column, you can also do it with the Sort function.

V Excel 2003 and 2002 for Windows or Excel 2008 and 2004 for Mac do the following.

  1. Select all cells you want to sort by alphabetizing two or more lists in a range.

  2. Select Facts on the toolbar and select Kind † The Sort dialog box opens.

  3. In the Sort by field, select the primary column you want to alphabetize the data by and select Ascending

  4. Select the second column by which you want to sort the range of cells in the By list. You can sort up to three columns.

  5. Turn the switch title bar if there is a heading in the list at the top.

  6. Click Okay to sort the list alphabetically.

V Sort Excel 2016, 2013, 2010 and 2007 for Windows or Excel 2016 and 2011 for Mac is also simple. (This feature is not available in Office 365 Excel Online.)

  1. Select all cells you want to sort by alphabetizing two or more lists in a range.

  2. Click Sort and filter in the Edit section of the Home tab.

  3. Select Custom Sort † The sorting window opens.

  4. Check box My data with headers if your lists have headings at the top.

  5. Select the main column on which you want to alphabetize the data in the field Sort on.

  6. Select Cell values in the “Sort by” field.

  7. Select a to Z in the Order field.

  8. Press the button Add level at the top of the dialog box.

  9. In the Sort by field, select the second column by which you want to alphabetize the data.

  10. Select Cell values in the “Sort by” field.

  11. Select a to Z in the Order field.

  12. Click Add level to optionally sort by another column. Click Okay when you are ready to alphabetize the table.

Advanced sorting in Excel

In certain situations, sorting alphabetically is simply not appropriate. For example, you may have a long list of the names of the months or days of the week that you want to sort in chronological order. Excel will take care of this too.

V Excel 2003 and 2002 for Windows or Excel 2008 and 2004 for Mac select the list to sort.

  1. Select Facts on the toolbar and select Kind † The Sort dialog box opens.

  2. Press the button parameters: at the bottom of the dialog box.

  3. Click the drop-down arrow in the First Key Sort Order list and select the sort option you want to use.

  4. Click Okay twice to sort the list chronologically.

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

  1. Click Sort and filter in the Edit section of the Home tab.

  2. Select Custom Sort † The Sort dialog box opens.

  3. Click the drop-down arrow in the order list and select Edited list † The Custom Lists dialog box opens.

  4. Select the sort option you want to use.

  5. Click Okay twice to sort the list chronologically.

More sorting functions

Excel offers many ways to enter, sort, and work with almost all types of data. Check out 6 Ways to Sort Data in Excel for more helpful tips and information.

Leave a Reply

Your email address will not be published.