1. Select the column you want to alphabetize in Excel
Click on any cell within the column that contains the text you want to sort alphabetically in your Excel worksheet.
2. Go to the Data tab
In the Excel ribbon, click the Data
tab to access sorting tools.
3. Choose A to Z or Z to A sort
Click the Sort A to Z
button to sort in ascending order or Sort Z to A
to sort in reverse alphabetical order.
4. Expand the selection if prompted
If Excel asks whether to expand the selection, choose Expand the selection
to sort all related data in the row along with the column.
5. Click Sort to apply
Click Sort
and Excel will alphabetize the column while keeping row data intact.