Share via

Toggle between worksheets

Stephen Shunk 0 Reputation points
2026-03-07T19:35:32.0066667+00:00

This is not working for me to toggle between worksheets:

"Hold Control + Page Down to move right between sheets in Excel, and Control + Page Up to move left."

Doing that only moves to the top or bottom of the current worksheet.

Microsoft 365 and Office | Excel | For home | Windows
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Kal-D 7,365 Reputation points Microsoft External Staff Moderator
    2026-03-19T18:56:02.4166667+00:00

    Hi Stephen Shunk,

    As noted in the AI's answer, Ctrl + Page Down and Ctrl + Page Up are still the correct Excel shortcuts to switch between worksheets.

    What you described usually means Excel is not actually receiving Page Up/Page Down, even though that is the correct shortcut for switching sheets.

    If those keys only move you within the current sheet, Excel is usually not receiving a true Page Up/Page Down key press. On many laptops, this can happen because the Fn layer changes what the key sends. On some models, Fn Lock (Fn + Esc) can also reverse that behavior.

    A few quick things to check:

    • Try the shortcut with the On‑Screen Keyboard in Windows using Ctrl + PgDn / PgUp. If that works, Excel is fine and the issue is likely the physical keyboard mapping.
    • On a laptop, try Ctrl + Fn + Down/Up Arrow or Ctrl + Fn + PgDn/PgUp, depending on the key labels.
    • Check whether Fn Lock is on or off (Fn + Esc on many devices).
    • Also check whether Scroll Lock is enabled, since that can change navigation behavior in Excel.

    As an alternative way to navigate, you can also right‑click the sheet navigation arrows at the bottom‑left of the workbook to open a list of worksheets and jump directly to the one you want.

    Please let me know if this proves useful to you, or if you would like further assistance.

    I'm looking forward to your reply.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment”.   

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

  2. AI answer

    2026-03-07T19:35:42.7166667+00:00

    Ctrl+Page Down / Ctrl+Page Up are the correct shortcuts to move to the next/previous sheet in an Excel workbook.

    If pressing them only moves within the current sheet (to the top or bottom), the most likely cause is that the Page Up / Page Down keys are being received without Ctrl. This can happen if:

    1. The Ctrl key is not being registered
      • Test Ctrl with another shortcut, for example Ctrl+Home (should go to cell A1) or Ctrl+End (should go to the last used cell).
      • If those behave like plain Home/End (top/bottom of current screen only), the keyboard or Ctrl key may be at fault.
    2. A laptop/Fn layer is changing the key behavior
      • On many laptops, Page Up / Page Down are on a function layer (for example Fn+Up / Fn+Down). In that case the effective shortcut is often Ctrl+Fn+Down / Ctrl+Fn+Up.
      • Check the keyboard markings and ensure the combination actually produces Page Down / Page Up while Ctrl is held.
    3. Scroll Lock or other navigation keys are confusing the result
      • With Scroll Lock on, arrow keys scroll the sheet instead of moving the active cell, but Ctrl+Page Up/Down should still change sheets. If behavior is odd, toggle Scroll Lock off and test again.

    Once Ctrl is correctly combined with a real Page Down / Page Up keystroke, Excel will:

    • Ctrl+Page Down → move to the next sheet in the workbook.
    • Ctrl+Page Up → move to the previous sheet in the workbook.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.