Forum Discussion
Solved
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...
- So 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!
After reading all the responses to this post and countless other on other sites, here is a quick summary of my configuration, what fails for me, and what worked for me:
Configuration
- Excel 365 with all the latest updates
- Razer Kiyo Pro - using the webcam but did not install the software!
- No unnecessary add-ins and/or de-activating any had no impact
- YouTube Music is not the issue in my scenario
- Excel Tools -> Options -> [any suggested configuration options] had no impact
Behaviour
- fails on one worksheet, but not the entire workbook!
- new workbooks do not have this issue
- Ctrl-[left][right] works
- Ctrl-[end] works
- Ctrl-[up][down] does NOT work
- Ctrl-[home] does NOT work
- Conclusion: problem is isolated to the configuration of one worksheet
Based on this, I researched more in terms of how the sheet was designed/developed (not by me). In my scenario, the problem stemmed from the worksheet being protected. Once I turned that off, navigation was back to normal!
Thankfully my scenario was a lot simpler than discovering the conflicts with YT Music/Razer. But since I wasn't the designer/developer, I knew the problem was localized within the spreadsheet.
Review -> Protect -> Protect/Unprotect [Sheet][WorkBook]