Alphabetize a whole spreadsheet with A column

Copper Contributor

I want to alphabetize a spreadsheet using the values in column A but don't want the rest of the spreadsheet to be left in original position.  How can I accomplish this?  

2 Replies


If there are no empty rows or columns in between the data, select a single cell in column A.

Otherwise, select the entire range that you want to be sorted, and make sure that the active cell in the selection is in column A.

On the Home tab of the ribbon, in the Editing group, click Sort & Filter > Sort Smallest to Largest (or Sort A>Z, or Sort Oldest to Newest, depending on the data).

@Hans Vogelaar Thank you for your help. I got it. Had to delete empty columns n rows