As the result, the first row in our table is sorted in alphabetical order, and the rest of the data is rearranged accordingly, preserving all correlations between the entries: Problems with sorting alphabetically in Excel. Excel sort features are amazing,

Excel Methods: This tutorial provides two examples on how to sort data in an alphabetical order, in a column. The first method can be achieved in 8 steps and gives you more functionality through the Sort window. The second method can be achieved in 4 step

To sort the spreadsheet in alphabetical order, just click the A → Z symbol in the Sort and Filter section. This will rearrange the spreadsheet in alphabetical order of the selected column. On most versions of Excel, this button is in the top left corner