Forum Discussion

FCatalano's avatar
FCatalano
Brass Contributor
Dec 22, 2021
Solved

WRONG the CTRL + down arrow key combination

Please help me! I have a problem with Excel for a few days. The CTRL + down arrow key combination no longer works correctly for me. Instead of bringing the focus to the last line of the sheet, I a...
excel
  • FCatalano's avatar
    FCatalano
    Dec 28, 2021

    FCatalano 

    FOUND IT...
    On closer inspection I found that it was software installed for an external keyboard that conflicted with the CTRL + arrow key combinations
    I thank the whole community and I apologize for not having identified the problem in a more timely manner.
    Greetings

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Dec 27, 2021

FCatalano 

With the permission of everyone, if I may additionally recommend these approaches.

 

The sheet could possibly be protected. Then you can only activate cells that have been explicitly unlocked. However, this would then only affect this corresponding worksheet. On other Excel files, you should then be able to navigate through the cells with the arrow keys.

 

Another issue/problem with Ctrl+Down function is associated with Transition Navigation Keys.

If the key combination is not at all working, try changing the settings by going to

Excel Options> Advanced> Tools>Options>Uncheck Transition Navigation Keys.

 

Also, this could be because it stops at the first empty cell in the column. One solution to avoid this problem is to fill in the blank cells with a value of 0 (zero) if it doesn't interfere with the purpose of the sheet.

 

*The knowledge of the Excel version and the operating system would be of great advantage for an exact solution :).

 

 

Hope I could help

  • FCatalano's avatar
    FCatalano
    Brass Contributor
    Dec 27, 2021

    NikolinoDE 

    unfortunately all the tests had negative results
    I specify that there are no empty cells
    I attach image with the version of excel

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Dec 27, 2021

      FCatalano 

      Is it for any file or for some specific one, and does it work in safe mode?

      • FCatalano's avatar
        FCatalano
        Brass Contributor
        Dec 27, 2021
        SergeiBaklan
        i also tried in safe mode with no success
    • NikolinoDE's avatar
      NikolinoDE
      Platinum Contributor
      Dec 27, 2021

      FCatalano 

      What I can add to you as information for possible causes is ..

      The scroll lock is activated

      An Excel add-in conflict is causing the problem

      Corrupted add-in or add-in conflict

      In the event of a Sticky Keys error, the scroll lock will remain on

      Freeze Panes has blocked the visible area of the sheet

      Excel table is protected

      Complex formulas are processed

      Excel is in formula entry mode

       

      It should actually be one of these topics

       

      Thank you for your understanding and patience

      • FCatalano's avatar
        FCatalano
        Brass Contributor
        Dec 27, 2021

        NikolinoDE
        The scroll lock is activated (NONE)
        An Excel add-in conflict is causing the problem (i don't have Excel add-in)
        Corrupted add-in or add-in conflict (NONE)
        In the event of a Sticky Keys error, the scroll lock will remain on (NONE)
        Freeze Panes has blocked the visible area of the sheet (NONE)
        Excel table is protected (NONE)
        Complex formulas are processed (NONE)
        Excel is in formula entry mode (NONE)

        unfortunately I had already done most of these tests without success

Resources