Keyboard shortcut to select entire column

  • Thread starter Thread starter Melissa
  • Start date Start date
M

Melissa

I am using Excel 2007. I can select entire row by using Shift+Spacebar.
However, if I press Ctrl+Spacebar to select entire column, nothing happens.
Has the keyboard shortcut changed in Excel 2007?
 
hi
to select column of active cell - Ctrl + spacebar
to select row of the active cell - Shift + spacebar
Ctrl + Shift + Spacebar selects the entire sheet with active cell activated.

Regards
FSt1
 
Thanks to all for responses.
I found out that the reason Ctrl+Space did not work for me was because this
combination was set to toggle keyboard layout from English to Chinese. I
removed this setting and Ctrl+Space now works to select entire column in
Excel.
 
Back
Top