Keyboard shortcut to select entire column

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?
 
F

FSt1

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
 
M

Melissa

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top