Excel 2007 Cell Selection using Control Key

andrewlamb1402 · 09-19-2007, 02:05 PM

When using Excel 2007, I am unable to select blocks of data using control + shift + arrow keys. Control + shift + right arrow selects 19 columns. Control + shift + down does nothing. Have I inadvertently changed some keyboard option in Excel? Or what?

Zazula · 09-20-2007, 02:04 AM

ARROW KEYS Move one cell up, down, left, or right in a worksheet.

CTRL+ARROW KEY moves to the edge of the current data region (data region: A range of cells that contains data and that is bounded by empty cells or datasheet borders.) in a worksheet.

SHIFT+ARROW KEY extends the selection of cells by one cell.

CTRL+SHIFT+ARROW KEY extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.

LEFT ARROW or RIGHT ARROW selects the tab to the left or right when the Ribbon is selected. When a submenu is open or selected, these arrow keys switch between the main menu and the submenu. When a Ribbon tab is selected, these keys navigate the tab buttons.

DOWN ARROW or UP ARROW selects the next or previous command when a menu or submenu is open. When a Ribbon tab is selected, these keys navigate up or down the tab group.

In a dialog box, arrow keys move between options in an open drop-down list, or between options in a group of options.

DOWN ARROW or ALT+DOWN ARROW opens a selected drop-down list.

andrewlamb1402 · 09-20-2007, 09:48 AM

That's exactly what used to happen, and mostly still does.

CTRL+SHIFT+ARROW KEY extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.

Does not work. Instead, since 4pm yesterday:

CTRL+SHIFT+RIGHT ARROW KEY extends the selection by 19 columns
CTRL+SHIFT+DOWN ARROW KEY does nothing

What's changed?

Zazula · 09-20-2007, 10:05 AM

I haven't experienced that before, so I can't know for sure what has changed or happened... I suspect an add-on messing with your Excel, or a corrupt template. Does this happen when you start Excel in safe mode? (Run "C:\Program Files\Microsoft Office\Office12\Excel.exe" /s)

xavierkress · 01-22-2009, 06:03 AM

Iv'e found an answer to this as I was having this trouble on a user's PC that I was supporting at work. Below is the fix.

Click on the Circle (top left "Ribbon")
Click Excel Options bottom of the window
Click Advanced
And scroll to the bottom.
Uncheck under Lotus Compatibility -> Transition navigation keys
I checked it and it wouldn't let me use CTRL + SHIFT + Down or Up arrows. Then unchecked it and it works fine now.

09-19-2007, 02:05 PM	#1 (permalink)
andrewlamb1402 Registered User Join Date: Sep 2007 Location: Norhumberland, UK Posts: 2 OS: Vista	Excel 2007 Cell Selection using Control Key When using Excel 2007, I am unable to select blocks of data using control + shift + arrow keys. Control + shift + right arrow selects 19 columns. Control + shift + down does nothing. Have I inadvertently changed some keyboard option in Excel? Or what?

09-20-2007, 02:04 AM	#2 (permalink)
Zazula Manager Emeritus, I'm blond, James Blond Join Date: Apr 2006 Location: Athens, Greece Posts: 7,667 OS: Win XP Pro SP2	Excel 2007 arrow-key shortcuts ARROW KEYS Move one cell up, down, left, or right in a worksheet. CTRL+ARROW KEY moves to the edge of the current data region (data region: A range of cells that contains data and that is bounded by empty cells or datasheet borders.) in a worksheet. SHIFT+ARROW KEY extends the selection of cells by one cell. CTRL+SHIFT+ARROW KEY extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell. LEFT ARROW or RIGHT ARROW selects the tab to the left or right when the Ribbon is selected. When a submenu is open or selected, these arrow keys switch between the main menu and the submenu. When a Ribbon tab is selected, these keys navigate the tab buttons. DOWN ARROW or UP ARROW selects the next or previous command when a menu or submenu is open. When a Ribbon tab is selected, these keys navigate up or down the tab group. In a dialog box, arrow keys move between options in an open drop-down list, or between options in a group of options. DOWN ARROW or ALT+DOWN ARROW opens a selected drop-down list. __________________ "Time is the wisest because it discovers everything" Thales of Miletus (ca.624BC-ca.546BC) "Everything flows, nothing stands still." Heraclitus of Ephesus (ca.535BC-475BC) "One thing I know, that I know nothing" Socrates of Athens (ca.470BC–399BC)

09-20-2007, 09:48 AM	#3 (permalink)
andrewlamb1402 Registered User Join Date: Sep 2007 Location: Norhumberland, UK Posts: 2 OS: Vista	Re: Excel 2007 Cell Selection using Control Key That's exactly what used to happen, and mostly still does. CTRL+SHIFT+ARROW KEY extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell. Does not work. Instead, since 4pm yesterday: CTRL+SHIFT+RIGHT ARROW KEY extends the selection by 19 columns CTRL+SHIFT+DOWN ARROW KEY does nothing What's changed?

09-20-2007, 10:05 AM	#4 (permalink)
Zazula Manager Emeritus, I'm blond, James Blond Join Date: Apr 2006 Location: Athens, Greece Posts: 7,667 OS: Win XP Pro SP2	Re: Excel 2007 Cell Selection using Control Key I haven't experienced that before, so I can't know for sure what has changed or happened... I suspect an add-on messing with your Excel, or a corrupt template. Does this happen when you start Excel in safe mode? (Run "C:\Program Files\Microsoft Office\Office12\Excel.exe" /s) __________________ "Time is the wisest because it discovers everything" Thales of Miletus (ca.624BC-ca.546BC) "Everything flows, nothing stands still." Heraclitus of Ephesus (ca.535BC-475BC) "One thing I know, that I know nothing" Socrates of Athens (ca.470BC–399BC)

01-22-2009, 06:03 AM	#5 (permalink)
xavierkress Registered User Join Date: Jan 2009 Posts: 2 OS: XP SP2/3	Re: Excel 2007 Cell Selection using Control Key Iv'e found an answer to this as I was having this trouble on a user's PC that I was supporting at work. Below is the fix. Click on the Circle (top left "Ribbon") Click Excel Options bottom of the window Click Advanced And scroll to the bottom. Uncheck under Lotus Compatibility -> Transition navigation keys I checked it and it wouldn't let me use CTRL + SHIFT + Down or Up arrows. Then unchecked it and it works fine now.