Friday, July 1, 2022
- Advertisement -

How To Alphabetize In Excel

In this article, we will be explaining how to Alphabetize in Excel.

One of the most common functions in an Excel spreadsheet is sorting data alphabetically. In this article, we will be explaining how to Alphabetize in Excel.

How To Sort Alphabetically In Excel

The simplest way to alphabetize a column in Excel is to use the Sort feature.

  1. Highlight the cells you want to sort and make sure the cell are all filed up.
  2. Select Sort & Filter in the Editing section of the Home tab. 
  3. Choose Sort A to Z to alphabetize your list.

In Excel 2003, 2002 (Windows) Or Excel 2008, 2004 (Mac)

  • Highlight the cells you want to sort.
  • Click on any cell in the column you want to sort. 
  • Select Data on the toolbar and choose Sort. The Sort dialog box will open.
  • Choose the column you want to alphabetize in the Sort By box, and select Ascending.
  • Click OK
Alphabetize In Excel

Don’t miss: Best iOS Emulators For PC To Run iOS Apps

How To Sort Alphabetically By Multiple Columns Using The Sort Features

Alphabetize In Excel

  1. Select all of the cells that you want to sort in the range
  2. Click Sort & Filter in the Editing section of the Home tab. 
  3. Select Custom Sort.
  4. When a sort dialog box opens, select the My Data Has Headers checkbox, that is, if your lists have headers at the top. 
  5. Select the primary column where your data is. 
  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 where your second data is.
  10. Choose Cell Values in the Sort On box.
  11. Select A to Z in the Order box. 
  12. Click OK when you are ready to alphabetize your table.

In Excel 2003, 2002 For Windows Or Excel 2008, 2004 For Mac

  1. Select all of the cells that you want to sort 
  2. Select Data on the toolbar and choose Sort. 
  3. When the sort dialog box opens, 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 
  5. Select the Header Row radio button if your list has a header at the top. 
  6. Click OK to sort the list alphabetically.

Also read: Here Is How To Easily Add Money To Venmo

Advanced Sorting In Excel 

Alphabetize In Excel

You could use this if those written above didn’t work for you.

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

In Excel 2003, 2002 For Windows Or Excel 2008, 2004 For Mac, 

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

Alphabetize In Excel

Editor’s picks:

Stella Taylor
Stella Taylor
Stella Temidayo Taylor is a staff writer for Novabach, she is a content writer with years of experience and has written for many websites on a different niche such as Entertainment, Politics, Lifestyle, Health, Business, Technology and well experienced in journalism.
- Advertisement -

Latest Posts

- Advertisement -

Editor's Picks

Related news