Prev: Deleted file
Next: Current date
From: Melissa on 3 May 2010 23:17
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?
From: grizzly6969 on 3 May 2010 23:28
Ctrl + Shift + Down arrow
--
grizz


"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?
From: ozgrid.com on 3 May 2010 23:34
Ctrl+Shift+Spacebar.



--
Regards
Dave Hawley
www.ozgrid.com
"Melissa" <Melissa(a)discussions.microsoft.com> wrote in message
news:6EE36AE1-E2E5-460C-8042-3FF2CA1D6BE3(a)microsoft.com...
>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?

From: FSt1 on 4 May 2010 00:16
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

"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?
From: Jacob Skaria on 4 May 2010 00:34
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?
 |  Next  |  Last
Pages: 1 2
Prev: Deleted file
Next: Current date