+ Reply to Thread
Results 1 to 6 of 6

Ctrl Shift Down no longer working correctly

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit
    Posts
    3,676

    Ctrl Shift Down no longer working correctly

    My normal process for selecting a column of data is to click in the top cell, hit Ctrl Shift and the Down arrow to select from top cell to bottom cell.

    For the past week I've had an intermittent issue where running through that sequence merely moves my cursor from top cell to bottom cell, NOT selecting the intervening cells.

    I looked online and found one suggestion, ensure Scroll Lock is turned off. Mine was, but I then turned it on and then back off. After that, Ctrl Shift Down worked for a few minutes, then quit again.

    Any bright ideas?

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,234

    Re: Ctrl Shift Down no longer working correctly

    I will be interested in what others have to say. I have found that there are a few users on this forum (I think they are all from the Middle East) whose files, when I open them, "break" the shift-ctrl-arrowkey behavior. I can close and reopen Excel to recover my normal behavior. I have wondered if some versions/international settings out there don't don't have or allow that shift-ctrl-arrowkey behavior, and that gets carried over with the workbook. My only suggestion is to see if the loss of this behavior is consistently tied to opening a certain workbook. If so, then you might be able to explore what that workbook is importing into your Excel settings/options that takes away this behavior. (For example, I know that checking the transition navigation under Lotus compatibility changes the behavior of this key combination).
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    08-04-2004
    Location
    Amsterdam
    MS-Off Ver
    2016
    Posts
    186

    Re: Ctrl Shift Down no longer working correctly

    try this
    n Excel 2007 and Excel 2010-

    Click on Office button/File ->Excel Options ->Advanced. Scroll down to "Lotus Compatibility" and uncheck the ‘Transition Navigational Keys’.

  4. #4
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit
    Posts
    3,676

    Re: Ctrl Shift Down no longer working correctly

    All already unchecked; that was the only other solution I found online.

    I tried turning on/off Scroll Lock
    I tried checking/unchecking "Transition Navigational Keys"
    I rebooted a few times.

    NOW I think I've got it fixed. The solution?
    Picked up my keyboard and banged it on my desk. A staple fell out. Now Excel is happy again. Go figure.

  5. #5
    Forum Contributor
    Join Date
    08-04-2004
    Location
    Amsterdam
    MS-Off Ver
    2016
    Posts
    186

    Re: Ctrl Shift Down no longer working correctly


    Odd that keyboards are the one thing that have not really changed in design over the years and still have raised keys with gaps all around. I'd have thought by now we'd have totally sealed keyboards to stop dust, crumbs and staples getting in

  6. #6
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit
    Posts
    3,676

    Re: Ctrl Shift Down no longer working correctly

    Maybe some day. In the meantime I'll just have to remember to bang my keyboard every now and then. HOPEFULLY this solution will help others

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 04-27-2021, 11:49 AM
  2. [SOLVED] Shift+Space and Ctrl+Space shortcuts intermittently working
    By yumyumdimsum in forum Excel General
    Replies: 8
    Last Post: 10-14-2017, 11:54 AM
  3. CTRL + SHIFT + DOWN ARROW not working
    By kxkxkxx in forum Excel General
    Replies: 4
    Last Post: 09-30-2014, 01:40 PM
  4. [SOLVED] CTRL+SHIFT+ENTER array formula not working
    By frusterated in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-05-2012, 12:02 AM
  5. Replies: 11
    Last Post: 07-18-2012, 02:32 PM
  6. CTRL Spacebar no longer works
    By demosthenes in forum Excel General
    Replies: 4
    Last Post: 06-09-2008, 10:58 PM
  7. Macro's with Ctrl or Ctrl-Shift?
    By Al Franz in forum Excel General
    Replies: 6
    Last Post: 09-05-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1