Forum Discussion
I'm Trying to Sort 1500 Rows and 4 Columns: Please Help!
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
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.
Thank you for that information, but I think that info is for only sorting one column.
I need to sort 4 columns.
So, your first text is not true?
"I want to sort the spreadsheet alphabetically by the data in column A."
