May 02 2024 08:50 AM
Hello,
I have a spreadsheet of data with 1500+ rows and 4 columns. I want to sort the spreadsheet alphabetically by the data in column A. The data in columns B, C, and D correlate to the data in the cell from the A column. I can't figure out how to sort the spreadsheet while keeping the data associated correctly. I hope I'm explaining this well. I essentially want to take the info from each of the A, B, C, and D cells and sort it according to what is in cell A. If anyone can help me with this, I'd be very grateful, as I can't find the how-to on Microsoft Help pages.
aylaGrace43
May 02 2024 09:07 AM
Option 1: select a cell (any cell) in column A.
Option 2: select the entire range that you want to sort, and make sure that the active cell in the selected range is in column A.
Then: On the Home tab of the ribbon, in the Editing group, select Sort & Filter > Sort A to Z.
May 02 2024 11:35 AM
Thank you for that information, but I think that info is for only sorting one column.
I need to sort 4 columns.
May 02 2024 11:45 AM
So, your first text is not true?
"I want to sort the spreadsheet alphabetically by the data in column A."
May 02 2024 01:18 PM
Have you tried the suggestions that I posted?