Prev: Deleted file
Next: Current date
From: Melissa on 4 May 2010 11:21
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.

"Jacob Skaria" wrote:

> Hi Melissa
>
> CTRL+SPACEBAR selects an entire column in a worksheet.
>
> Refer the below for 2007 shortcuts
> http://office.microsoft.com/en-us/excel/HP100738481033.aspx
>
>
> --
> Jacob (MVP - Excel)
>
>
> "Melissa" wrote:
>
> > 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?
First  |  Prev  | 
Pages: 1 2
Prev: Deleted file
Next: Current date