Method #1 – Sort. To alphabetize in Excel using Sort, select the data, go to the Data Ribbon, click Sort, then select the column you want to alphabetize by. Step 1. Select the data you want to alphabetize with your cursor. You can select just one column

Alphabetize and keep rows together. If your data set contains two or more columns, you can use the A-Z or Z-A button to put one of the columns in alphabetical order and Excel will automatically move the data in other columns, keeping the rows intact.

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 workshee