Apr 28 2024 11:09 AM
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?
Apr 28 2024 12:03 PM
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).
Apr 28 2024 02:46 PM
@HansVogelaar Thank you for your help. I got it. Had to delete empty columns n rows