Office Settings & Configuration

Fix Excel Ctrl+Up and Ctrl+Down Arrow Navigation Problems

Chanuka GeekiyanageChanuka Geekiyanage Nov 13, 2026 869 views

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.

Fix Excel Ctrl+Up and Ctrl+Down Arrow Navigation Problems
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Excel Options

Click File in the top-left corner, then select Options at the bottom of the left menu.

2
Open Advanced options

In the Excel Options dialog, click Advanced in the left pane.

3
Clear Transition navigation keys

Scroll to the Lotus compatibility section, uncheck Transition navigation keys, and click OK.

Clear the Transition Navigation Keys setting in Excel Options
Navigation restored: After clearing this setting, test Ctrl+Up, Ctrl+Down, Ctrl+Shift+Up, and Ctrl+Shift+Down in your worksheet.
Free Microsoft Office alternative

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. 1. Download WPS Office: Go to wps.com and download WPS Office Free for Windows or macOS.
  2. 2. Open your Excel workbook: Launch WPS Spreadsheets and open the .xlsx or .xls file you were working with.
  3. 3. Test Ctrl+Arrow navigation: Use Ctrl+Up, Ctrl+Down, Ctrl+Left, and Ctrl+Right to move through data boundaries as expected.
Restore expected Ctrl+Up, Ctrl+Down, and Ctrl+Shift+Arrow navigation in a familiar spreadsheet gridOpens and saves .xlsx, .xls, and .csv files with full Microsoft Excel format compatibilityFree, lightweight interface without Office repair or add-in troubleshooting overheadFamiliar ribbon UI and shortcut keys make migration from Excel seamless
microsoft office alternative - wps office

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.