The Excel software automatically expands rows and columns when you sort data and more room is needed for the extra data. You can stop this feature from occurring in the Excel AutoCorrect properties ...
You can alphabetize data in an Excel spreadsheet by row or column using the "Sort" feature, or through the "Data" and "Home" tabs.