How to Alphabetize Cells in Excel

Method 1 of 2:

Alphabetizing in Two Clicks

Type the text you wish to alphabetize into the cells of one column.
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.
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.
1. 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.
Finished.

Method 2 of 2:

Alphabetizing with Sort

Fill the Excel sheet with your text.
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.
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."
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.
Select "Ascending" to sort the chosen column in ascending order. Or select "Descending" to sort the chosen column in descending order.
Click "ok." Your cells will now be alphabetized.

Isabella Humphrey

Update 05 March 2020

You should read it

May be interested

How to Insert a Page Break in an Excel Worksheet
if you've ever tried printing a large microsoft excel worksheet, you've undoubtedly encountered some awkward-looking print jobs. excel's automatic page breaks don't exactly take your custom data views into consideration. in order to...
How to Move Columns in Excel
this wikihow teaches you how move a column to another location in microsoft excel for windows or macos. click the letter above the column you want to move. this selects the column.
How to Convert Measurements Easily in Microsoft Excel
excel's convert function ('=convert()') converts a measurement from one unit to another. to use this function, you will enter data and units into the formula: =convert(number, 'from_unit', 'to_unit'). first learn how to enter the convert...
How to Remove Leading or Trailing Zeros in Excel
this wikihow teaches you how to remove zeros from the beginning (leading) or end (trailing) of numbers in excel. highlight the cells with leading zeros. if you're working with numbers in a column, you can highlight the whole column by...
How to Run Regression Analysis in Microsoft Excel
regression analysis can be very helpful for analyzing large amounts of data and making forecasts and predictions. to run regression analysis in microsoft excel, follow these instructions. if your version of excel displays the ribbon (home,...
How to Add Up Columns in Excel
this wikihow teaches you how to add two or more columns together in an excel document. you can use the sum command on both windows and mac versions of excel to do so. open your excel document. double-click the excel document that you want...

How to Alphabetize Cells in Excel

Alphabetizing in Two Clicks

Alphabetizing with Sort

You should read it

May be interested

Office information