Office Settings & Configuration

Fix Excel Ctrl+Left and Ctrl+Right Moving One Screen at a Time

Muhammad Talha Oct 9, 2026 868 views

Question details

The user needs to restore the default functionality of the Ctrl+Left and Ctrl+Right keyboard shortcuts so they jump to the edge of a horizontal data range rather than scrolling one full screen at a time.

Fix Excel Ctrl+Left and Ctrl+Right Moving One Screen at a Time

Product: Microsoft Excel
Device & OS: not provided
Scenario: Navigating horizontally across a data range using keyboard shortcuts.
Observed behavior: Pressing Ctrl+Left or Ctrl+Right moves the view one full screen horizontally instead of jumping to the next data edge, even though Ctrl+Up and Ctrl+Down function normally and Scroll Lock is disabled.

Before you start

Verify that your physical keyboard is working properly by testing the Ctrl and arrow keys in another text application. Additionally, double-check your keyboard to ensure no other modifier keys (like Fn or Alt) are physically stuck.

Solution 1Recommended

Run Excel in Safe Mode to Disable Interfering Add-ins

Launch Excel in Safe Mode to determine if a third-party add-in is hijacking or modifying your default keyboard shortcuts.

Sometimes, installed COM or Excel add-ins can interfere with native keyboard shortcut behaviors. Running Safe Mode bypasses these add-ins.

Open the Run Dialog

Press the Windows Key + R on your keyboard to open the Run command window.

Launch Safe Mode

Type 'excel /safe' into the text box and press Enter or click OK.

Test the Shortcuts

Open a workbook and test Ctrl+Left and Ctrl+Right. If they work correctly, navigate to File > Options > Add-ins to identify and disable the problematic add-in.

Run Excel in Safe Mode to Disable Interfering Add-ins

Add-in Identification: If Safe Mode resolves the issue, disable all add-ins and re-enable them one by one to find the exact add-in causing the problem.

Solution 2

Repair Your Microsoft Office Installation

Use the built-in Office repair tool to fix corrupted application files that may be causing erratic keyboard behavior.

Solution 3

Test a Different Windows User Profile

Determine if the issue is tied to your specific Windows user profile settings or registry configurations.

Free Microsoft Office alternative

Experience Flawless Spreadsheet Navigation with WPS Office

If persistent Microsoft Office bugs are interrupting your workflow, consider switching to WPS Office. It is a highly compatible, free alternative that ensures standard keyboard shortcuts work flawlessly right out of the box, saving you from tedious troubleshooting.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx or .csv files seamlessly.
3. Navigate Effortlessly: Use your standard Ctrl+Left and Ctrl+Right shortcuts to instantly jump to the edges of your data range without glitches.

Completely free and lightweight office suitePerfect compatibility with Microsoft Excel (.xlsx) filesFamiliar interface requiring zero learning curveReliable and standardized keyboard shortcut functionality

Frequently Asked Questions

Why does Excel scroll instead of moving cells when I use arrow keys?

This is almost always caused by the Scroll Lock (ScrLk) key being toggled on. When enabled, the arrow keys scroll the worksheet view rather than moving the active cell selection.

How do I turn off Scroll Lock if my keyboard doesn't have a ScrLk key?

You can turn off Scroll Lock using the Windows On-Screen Keyboard. Press the Windows key, type 'On-Screen Keyboard', open the app, and click the 'ScrLk' button so it is no longer highlighted.

Can Transition Navigation Keys affect how Ctrl+Arrow shortcuts work?

Yes. If 'Transition navigation keys' (a legacy Lotus 1-2-3 compatibility setting) is enabled, shortcuts may behave unexpectedly. You can disable this by going to File > Options > Advanced, scrolling to the bottom, and unchecking 'Transition navigation keys'.

Office App Problems