| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keyboard shortcut to select entire column
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keyboard shortcut to select entire column
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keyboard shortcut to select entire column
Ctrl+Shift+Spacebar.
-- Regards Dave Hawley www.ozgrid.com "Melissa" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keyboard shortcut to select entire column
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keyboard shortcut to select entire column
Hi Melissa
CTRL+SPACEBAR selects an entire column in a worksheet. Refer the below for 2007 shortcuts http://office.microsoft.com/en-us/ex...738481033.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? |
|
#6
|
|||
|
|||
Quote:
looks like your control keys are hanged on your laptop/PC. try this press alt+ctrl+fn. It will be fixed. Thanks Bala |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keyboard shortcut to select entire column
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/ex...738481033.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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keyboard Shortcut to move to top of column in worksheet? | Excel Discussion (Misc queries) | |||
| Keyboard Shortcut "Select All of the Same" | Excel Discussion (Misc queries) | |||
| keyboard shortcut for $(row)$(column) | Excel Worksheet Functions | |||
| What is Excel keyboard shortcut for adding column? | Excel Worksheet Functions | |||
| Keyboard shortcut or selecting entire column | Excel Worksheet Functions | |||
Hybrid Mode
