How to alphabetize columns in Excel 1. Open the Excel spreadsheet you need to alphabetize on your Mac computer or PC. 2. Select the data you want to sort, or do not highlight anything if you wish ...

Finally, move over to Sort By and choose a Column from the list of options. Hit the OK button to complete the task. As we can see, the colored cells in your Excel spreadsheet should have changed.