How To Alphabetize In Excel?

Select the range of cells you want to alphabetize

Go to the Data tab

Click Sort A to Z to sort alphabetically ascending

Click Sort Z to A to sort alphabetically descending

If your data has headers, check My data has headers

Choose the column you want to sort by if prompted

Click OK to apply the sort

For a single column list, select the column before sorting

For multiple columns, use Custom Sort to sort by one or more fields

To keep rows together, select the entire table before sorting

Suggested for You

Trending Today