Forum Discussion
OLSD237
Jun 29, 2023Copper Contributor
Excel Ctrl + Up Arrow and Ctrl + Down Arrow Not Working
I've looked through the other posts in the forum, but still cannot get this working in my Excel for some reason. Ctrl + left arrow or right arrow works, taking me to end of the horizontal data set, y...
- Jul 11, 2023So the answer here was to reinstall Microsoft office. Now it works again. Pretty frustrating and time consuming, but it's critical functionality I need for financial modeling.
Thanks all!
NikolinoDE
Jun 30, 2023Gold Contributor
If the Ctrl + Up Arrow or Ctrl + Down Arrow shortcuts are not working in Excel, there are a few additional troubleshooting steps you can try:
Check your keyboard: Ensure that the Ctrl key on your physical keyboard is functioning properly. Try using a different keyboard or testing the Ctrl key with other applications to rule out any hardware issues.
Check Excel options: Verify that the Ctrl + Up Arrow and Ctrl + Down Arrow shortcuts are not disabled in Excel options.
Here is how to check:
Click on the "File" tab in Excel.
Select "Options" from the menu.
In the Excel Options dialog box, click on "Advanced" on the left.
Scroll down to the "Editing options" section.
Make sure the "Enable Ctrl + Arrow key shortcuts" option is checked.
Click "OK" to save the changes.
Check for conflicting keyboard shortcuts: It's possible that another keyboard shortcut is conflicting with Ctrl + Up Arrow or Ctrl + Down Arrow. You can check and modify the keyboard shortcuts in Excel options:
Follow the steps mentioned in point 2 to open Excel Options.
Click on "Customize Ribbon" on the left.
At the bottom, click on the "Keyboard shortcuts: Customize" button.
In the "Categories" list, select "All Commands".
In the "Commands" list, look for "EditGoTo" or "EditGoToSpecial".
Select the shortcut you want to use (Ctrl + Up Arrow or Ctrl + Down Arrow) in the "Press new shortcut key" field.
Click "Assign" and then "Close" to save the changes.
Repair or reinstall Office: If the issue persists, you may consider repairing or reinstalling Microsoft Office. This can help resolve any underlying software conflicts or issues.
If none of these solutions work, it is possible that there may be an issue with your Excel installation or the operating system. The texts, steps and functions were created with the help of AI for reasons of time.
Hope this will help you.
Gnana_Sambandham
Dec 29, 2023Copper Contributor
NikolinoDE I Couldn't find the Enable Ctrl + option where you mentioned, or Editgoto option as you mentioned what should i do now?