Forum Discussion

WILLIAMW700's avatar
WILLIAMW700
Copper Contributor
Aug 11, 2024

Excel Help

In MS Home and Student 2016, I'm trying to group a couple of rows at a time and then alphabetize the rows According to the names listed in Column A maintaining all of the information in the rows.

 

I then want to copy this page to a new sheet and the alphabetize the rows according to names in Column C.  

 

Is there a keyboard shortcut to group rows? Am I using the right word, GROUP?

 

Thanks, Old Dog

excel
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Aug 12, 2024
    If you select three cells (vertically) by holding down the Shift key and then pressing the down arrow key, you can subsequently select the entire three rows by pressing Control+Spacebar.

Resources