Fix Excel Ctrl+Up and Ctrl+Down Arrow Navigation Problems
Question details
The user needs to troubleshoot Excel when Ctrl+Left and Ctrl+Right work but Ctrl+Up and Ctrl+Down do not move through data correctly.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Navigating a worksheet with Ctrl+Arrow shortcuts to jump between data regions.
- Observed behavior
- Ctrl+Left and Ctrl+Right move through data correctly, but Ctrl+Up and Ctrl+Down do not move through vertical data regions as expected.
Open the affected Excel workbook and make sure you are testing in Normal view with the worksheet active. If possible, have the Windows On-Screen Keyboard available so you can check Scroll Lock and Num Lock without relying only on a physical keyboard.
Clear the Transition Navigation Keys setting in Excel Options
Use this first when Ctrl+Up and Ctrl+Down fail but Ctrl+Left and Ctrl+Right work; the Lotus compatibility option often overrides vertical navigation.
Excel includes a legacy Lotus compatibility setting that can change how Ctrl+Arrow shortcuts behave. Turning off this option restores the default Excel navigation commands.
Click File in the top-left corner, then select Options at the bottom of the left menu.
In the Excel Options dialog, click Advanced in the left pane.
Scroll to the Lotus compatibility section, uncheck Transition navigation keys, and click OK.

Check Scroll Lock and Num Lock status
Use this when the Transition navigation keys setting is already clear or the problem persists; locked keys can block vertical arrow shortcuts.
Disable add-ins and repair Microsoft Office
Use this if the navigation issue continues after checking the above settings; add-ins or an Office installation problem may be interfering.
Use WPS Office Spreadsheets for Reliable Ctrl+Arrow Navigation
If Excel navigation remains unreliable, WPS Office is a free, lightweight Microsoft Office alternative with familiar spreadsheet shortcuts, full Excel format compatibility, and an interface that makes switching easy—no complex repair or Lotus compatibility settings required.
- 1. Download WPS Office: Go to wps.com and download WPS Office Free for Windows or macOS.
- 2. Open your Excel workbook: Launch WPS Spreadsheets and open the .xlsx or .xls file you were working with.
- 3. Test Ctrl+Arrow navigation: Use Ctrl+Up, Ctrl+Down, Ctrl+Left, and Ctrl+Right to move through data boundaries as expected.

Frequently Asked Questions
Why does Ctrl+Up or Ctrl+Down not work but Ctrl+Left and Ctrl+Right do in Excel?
This is often caused by the Lotus compatibility setting. Go to File > Options > Advanced, find the Lotus compatibility section, and clear Transition navigation keys if it is enabled.
How do I turn off Scroll Lock if my keyboard has no Scroll Lock key?
Open the Windows On-Screen Keyboard from the Start menu, then click the ScrLk key to disable Scroll Lock.
Can Num Lock affect Ctrl+Up and Ctrl+Down shortcuts?
Yes. On some keyboards and laptops, toggling Num Lock can resolve input conflicts that affect vertical Ctrl+Arrow navigation.
What should I do if Excel still won't navigate after clearing Transition navigation keys?
Run Excel in Safe Mode by typing excel /safe in the Run box. If the shortcut works, disable COM add-ins under File > Options > Add-ins and restart Excel. If not, repair Microsoft Office from Windows Settings > Apps.
Will WPS Spreadsheets support my Excel files and Ctrl+Arrow shortcuts?
Yes. WPS Spreadsheets opens and saves .xlsx, .xls, and .csv files and supports standard Ctrl+Arrow navigation shortcuts, so you can continue working with familiar spreadsheet behavior.




