Others

How to Fix Excel Worksheet Switching Shortcuts Not Working on a Laptop

Natalie Taylor Sep 30, 2026 868 views

Question details

The user is unable to navigate between different worksheets in Excel using the standard keyboard shortcuts on their notebook computer.

How to Fix Excel Worksheet Switching Shortcuts Not Working on a Laptop

Product: Excel
Device & OS: Windows Laptop
Scenario: Attempting to switch active worksheet tabs quickly using keyboard shortcuts while working in a multi-sheet workbook on a laptop.
Observed behavior: The standard Ctrl+Page Up and Ctrl+Page Down shortcuts fail to switch the worksheets, or they unexpectedly select multiple sheets instead of switching between them.

Before you start

Verify if your compact laptop keyboard requires holding down an additional 'Fn' (Function) key to activate the Page Up and Page Down keys.

Solution 1Recommended

Test with an External or On-Screen Keyboard

Determine if the issue is caused by the laptop's built-in keyboard hardware or specific function-key settings.

Laptops often have compressed keyboard layouts that change how navigation keys operate. Isolating the issue using a standard external keyboard or a virtual keyboard helps confirm if the shortcuts themselves are functioning properly within Excel.

Connect an external keyboard

Plug a standard USB or Bluetooth external keyboard into your laptop.

Test standard shortcuts

Open your Excel workbook and press 'Ctrl + Page Up' or 'Ctrl + Page Down' on the external keyboard to see if the sheets switch.

Use the Windows On-Screen Keyboard

If you don't have an external keyboard, press the Windows key, type 'On-Screen Keyboard', and open the app. Use your mouse to click the 'Ctrl' key followed by 'PgUp' or 'PgDn' on the screen.

Test with an External or On-Screen Keyboard

Fn Key Requirement: If the external keyboard works but the laptop keyboard does not, you likely need to press 'Ctrl + Fn + Page Up/Down' on your laptop to trigger the shortcut.

Solution 2

Use Alternative Navigation Shortcuts (Samsung Laptops)

Utilize brand-specific keystrokes to navigate worksheets if standard shortcuts are overridden by system hardware.

Solution 3

Ensure You Are Not Using 'Select' Shortcuts

Avoid adding the Shift key, which changes the command from switching worksheets to grouping them.

Seamlessly Manage Worksheets with WPS Spreadsheet

WPS Office provides a lightweight, highly compatible spreadsheet tool where standard keyboard navigation works exactly as you expect, boosting your productivity without steep learning curves.

1. Open WPS Spreadsheet: Launch WPS Office and open a new or existing Spreadsheet document.
2. Add multiple worksheets: Click the '+' icon next to the sheet tabs at the bottom to create multiple worksheets.
3. Use standard shortcuts: Press 'Ctrl + Page Up' or 'Ctrl + Page Down' to effortlessly switch between the active sheets.
4. Navigate with ease: Enjoy seamless transitions between data sets without worrying about complex shortcut overrides.

Fully compatible with Microsoft Excel (.xlsx) formatsSupports standard keyboard shortcuts for fast worksheet navigationLightweight design ensures smooth performance on all laptop brandsIntuitive user interface for effortless tab management

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel sheets group together when I try to switch them?

If you accidentally press the Shift key (Ctrl+Shift+Page Up/Down), Excel groups the worksheets instead of switching between them. To fix this, simply click on any single sheet tab at the bottom with your mouse to ungroup them.

How do I know if my laptop requires the Fn key for Page Up and Page Down?

Look at your laptop's keyboard. If 'Page Up' or 'Page Down' are printed in a different color or share a key with the directional arrows, you generally need to hold down the 'Fn' key simultaneously (e.g., Ctrl + Fn + Page Up) to activate the shortcut.

Does Ctrl+Shift+Tab switch between worksheets in Excel?

No, Ctrl+Shift+Tab is not a standard Excel shortcut for switching between worksheets within a single workbook. The correct standard shortcuts are Ctrl+Page Up to move to the previous sheet and Ctrl+Page Down to move to the next sheet.

Office Quick Solutions