Office Settings & Configuration

Fix Excel Arrow Keys Not Navigating Between Worksheets

Ayan Masood Oct 10, 2026 872 views

Question details

The user is attempting to use the standard arrow keys to switch between worksheet tabs at the bottom of the workbook, but the keys are unresponsive for this action. Common Scroll Lock fixes do not solve the problem.

How to Fix Excel Arrow Keys Not Navigating Between Worksheets

Product: Excel
Device & OS: not provided
Scenario: Navigating between multiple worksheet tabs using keyboard inputs to speed up workflow.
Observed behavior: The left and right arrow keys do not switch to the adjacent worksheet tabs, and disabling Scroll Lock does not change this behavior.

Before you start

Verify if your arrow keys are failing to move the selection between individual cells, or if you are specifically trying to switch between the bottom worksheet tabs, as these actions require completely different keystrokes.

Solution 1Recommended

Use the Correct Keyboard Shortcuts to Switch Sheets

Excel is not designed to use arrow keys for switching worksheet tabs. You must use the dedicated Page Up and Page Down keyboard shortcuts instead.

By design, Microsoft Excel dedicates the arrow keys exclusively to moving the active cell selection within a single spreadsheet. To switch between multiple worksheet tabs, you need to use the Ctrl key modifier in combination with the Page Up or Page Down keys.

Move to the next worksheet

Press and hold the Ctrl key, then press the Page Down key to navigate to the worksheet tab immediately to the right.

Move to the previous worksheet

Press and hold the Ctrl key, then press the Page Up key to navigate to the worksheet tab immediately to the left.

Use the Correct Keyboard Shortcuts to Switch Sheets

Keyboard Shortcut Tip: Using Ctrl + Page Up/Down is standard across most spreadsheet applications and will significantly speed up your workflow once you get used to it.

Solution 2

Disable Scroll Lock for Cell Navigation Issues

If your arrow keys are scrolling the entire spreadsheet view rather than moving from cell to cell, the Scroll Lock feature has been activated.

Seamless Spreadsheet Navigation

Manage Worksheets Effortlessly in WPS Office

WPS Spreadsheet is a powerful, free alternative that supports all standard familiar keyboard shortcuts, allowing you to manage multiple worksheets efficiently without relearning your workflow.

1. Download WPS Office: Install the free WPS Office suite on your computer.
2. Open a multi-sheet workbook: Launch WPS Spreadsheet and open any existing Excel file or create a new workbook with multiple tabs.
3. Navigate instantly: Use the familiar Ctrl + Page Up and Ctrl + Page Down shortcuts to seamlessly jump between your worksheet tabs.

Completely free and lightweight alternative to Microsoft ExcelFully compatible with Microsoft Excel formats (.xlsx, .xls)Supports standard navigation shortcuts including Ctrl + Page Up/DownFamiliar tabbed interface requiring zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Can I customize Excel to use arrow keys for switching worksheets?

No, Excel does not offer a built-in feature to remap the arrow keys for switching worksheet tabs. If you wish to suggest this functionality, you can submit feature requests directly to Microsoft by navigating to File > Feedback.

How do I quickly jump between sheets if my workbook has dozens of tabs?

Instead of pressing the keyboard shortcut repeatedly, right-click the small navigation arrows located in the bottom-left corner of the Excel window. This will open an 'Activate' dialog box listing all your sheets, allowing you to click and jump directly to the specific sheet you need.

Why do my arrow keys move the whole screen instead of individual cells?

This occurs when the Scroll Lock feature is turned on. When active, the arrow keys scroll the visible canvas of the spreadsheet rather than changing your selected cell. Simply press the Scroll Lock (or ScrLk) key on your keyboard to turn it off and restore normal cell navigation.

Office App Problems