How to Alphabetize Cells in Excel
Type the text you wish to alphabetize into the cells of one column., Highlight the text you want to alphabetize., Find the "AZ sort" or "ZA sort" icon found on the standard tool bar, under the Data tab., Finished.
Step-by-Step Guide
-
Step 1: Type the text you wish to alphabetize into the cells of one column.
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. , 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. , -
Step 2: Highlight the text you want to alphabetize.
-
Step 3: Find the "AZ sort" or "ZA sort" icon found on the standard tool bar
-
Step 4: under the Data tab.
-
Step 5: Finished.
Detailed Guide
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. , 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. ,
About the Author
Anna White
Dedicated to helping readers learn new skills in DIY projects and beyond.
Rate This Guide
How helpful was this guide? Click to rate: