Alphabetize Cells in Excel

Excel is a powerful spreadsheet tool used to store and manage text and numbers, and alphabetizing is one of the many benefits of using Excel since it allows you to quickly organize, access, and reference data. To alphabetize cells in Excel using two clicks, highlight the range of cells and click on the "AZ sort" or "ZA sort" icon on the standard toolbar. To alphabetize cells in Excel using advanced Sort options, highlight the entire worksheet, click on "Sort" from the "Data" menu, then select the columns and order you wish to sort by from the resulting dialog box.

Steps

Alphabetizing in Two Clicks

1. Type the text you wish to alphabetize into the cells of one column.
2. Highlight the text you want to alphabetize. To highlight, click on the first cell and drag down to the last cell you want to alphabetize. You can highlight an entire column by clicking on the lettered column heading.
3. Find the "AZ sort" or "ZA sort" icon found on the standard tool bar, under the Data tab. Click the "AZ sort" icon to sort in ascending alphabetical order. Click the "ZA sort" icon to sort in descending order. Your highlighted cells will now be sorted.
   • If you cannot locate the "AZ sort" icon you can add the standard toolbar by opening the "View" menu on menu bar then select "Toolbars" and check "Standard." The standard toolbar will now be visible and will include the "AZ sort" icon.
4. Finished.

Alphabetizing with Sort

1. Fill the Excel sheet with your text.
2. Highlight the entire worksheet. To do this use the shortcut keys "Control + A" or "Command + A." You can also highlight by clicking the blank box in between the row and column headings on the top left.
3. Open the "Data" menu on the toolbar, then click the "Sort" option. A "Sort" box will appear. If you have labeled the columns, select the "Header row" option under "My list has." If you have not labeled the columns, select the "No header row."
4. Choose the column you want to alphabetize by selecting it under "Sort by." If you selected the "Header row" option, the options under "Sort by" will be your column headings. If you have selected "No header row," the options will be the standard letter column headings.
5. Select "Ascending" to sort the chosen column in ascending order. Or select "Descending" to sort the chosen column in descending order.
6. Click "ok." Your cells will now be alphabetized.

Tips

• You can alphabetize any column no matter where it is in the sheet.

Warnings

• Alphabetizing cells with the "AZ sort" icon will only alphabetize the column you have highlighted. Any data in the following columns will remain static and will not sort in line with the cells you alphabetized. Alphabetizing by using the "Sort" option under the "Data" menu will allow you to alphabetize 1 column and keep any corresponding data in line.

Related Articles

• Add Header Row in Excel
• Print Part of an Excel Spreadsheet
• Plan a Vacation Using a Spreadsheet
• Calculate the Day of the Week in Excel
• Recover a Corrupt Excel File

Sources and Citations

• http://office.microsoft.com/en-us/excel-help/quick-start-sort-data-in-a-worksheet-HA010371383.aspx?CTT=1

See also

• Create a Sin and Cos Circle in Excel
• Add a Header or Footer in Excel 2007
• Calculate CAGR in Excel
• Use Excel for Your Finances
• Parse Data in Excel
• Create Custom Lists in Excel
• Remove Leading or Trailing Zeros in Excel
• Remove Spaces Between Characters and Numbers in Excel
• Use Vlookup With an Excel Spreadsheet
• Create a User Defined Function in Microsoft Excel

Read more ...

What links here

• Add a Drop Down Box in Excel 2007
• Alphabetize in Microsoft Word
• Calculate an Interest Payment Using Microsoft Excel
• Use AutoFilter in MS Excel