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