I'm Trying to Sort 1500 Rows and 4 Columns: Please Help!

Copper Contributor

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 

4 Replies

@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.

@Hans Vogelaar 

Thank you for that information, but I think that info is for only sorting one column.

 

I need to sort 4 columns. 

@aylaGrace43 

So, your first text is not true?

"I want to sort the spreadsheet alphabetically by the data in column A."

@aylaGrace43 

Have you tried the suggestions that I posted?