Shortcut Key to Jump to the Next Sheet in Excel on Windows

In Excel for Microsoft 365 on Windows, press Ctrl+Page Down to jump to the next worksheet in the workbook. To move back to the previous worksheet, press Ctrl+Page Up.

The Windows shortcut and what it does

Ctrl+Page Down changes the active worksheet without requiring you to click a sheet tab. “Next” means the next visible worksheet in the order of the tabs along the bottom of the workbook, moving from left to right. The shortcut does not move the selected cell down a page or scroll through a long worksheet; it switches to another sheet.

For example, if a workbook has tabs named January, February, and March, and January is active, pressing Ctrl+Page Down activates February. Press it again to activate March. The selected cell on the new sheet is generally the cell that was active there previously, so you can continue working where you left off.

The matching reverse shortcut is useful when you move one sheet too far: Ctrl+Page Up goes to the previous visible worksheet. These shortcuts work with the active workbook in Excel desktop for Windows, including workbooks with many tabs.

How sheet order affects navigation

The shortcut follows the tabs’ current order, not their names, dates, or the order in which they were created. If you drag a tab to a different position, Ctrl+Page Down follows that new position. This makes the command especially straightforward in workbooks where sheets are arranged chronologically or by department.

Hidden worksheets are not stops in ordinary next-sheet navigation. Excel moves among visible tabs, skipping sheets that are hidden. If you reach the last visible worksheet and press Ctrl+Page Down, Excel does not cycle back to the first sheet; you stay at the end. Use Ctrl+Page Up to travel back through the visible tabs.

These details matter in a workbook where the visible tabs do not tell the whole story. A sheet may be hidden because it contains supporting calculations or archived data. If you expect a particular sheet to appear during navigation but it does not, check whether it is hidden: right-click a sheet tab and look for Unhide. That command is available when the workbook contains a sheet that can be unhidden.

Using the shortcut reliably

Click a cell in the worksheet, then press and release Ctrl+Page Down. On a full-size keyboard, Page Down is usually a separate key. You do not need to hold Ctrl while clicking, and you do not need to select a sheet tab first. If you are entering or editing a cell, finish or cancel that edit before switching sheets so your keystrokes are not treated as part of the cell contents.

On a laptop, Page Down may share a key with an arrow key or another function. The required key combination depends on the keyboard layout and manufacturer. Look for a printed PgDn or Page Down label, and consult the laptop’s keyboard instructions if it is a secondary function. On many compact keyboards, you need to hold an Fn key as well as Ctrl to send Page Down.

To go one visible sheet forward: Ctrl+Page Down.
To go one visible sheet backward: Ctrl+Page Up.
To move several sheets, repeat the shortcut once for each sheet.

Holding the shortcut down is not usually as predictable as pressing it repeatedly: the keyboard may repeat the key, and Excel can move through tabs quickly. For a small number of sheets, repeated individual presses make it easier to stop on the intended tab.

Differences on Mac and in Excel for the web

In Excel for Mac, the corresponding worksheet-navigation shortcuts are also Control+Page Down for the next sheet and Control+Page Up for the previous sheet. Mac keyboards often do not have dedicated Page Up and Page Down keys. On many MacBook keyboards, Fn+Down Arrow sends Page Down and Fn+Up Arrow sends Page Up, so the combinations may be Control+Fn+Down Arrow and Control+Fn+Up Arrow. Key behavior can vary with the keyboard and macOS settings.

Excel for the web runs inside a browser, and browser or operating-system shortcuts can affect which application receives a key combination. If Ctrl+Page Down changes the browser tab instead of the worksheet, use the sheet tabs at the bottom of the workbook or the workbook’s sheet-navigation controls. The exact experience can vary by browser and keyboard. Excel for the web also provides keyboard shortcut information through its Help interface, which is useful if you need to check the current shortcuts for your setup.

These platform differences are a good reason to distinguish Excel desktop for Windows from Excel for Mac or the web when sharing instructions. A shortcut that works on a standard Windows keyboard may need an Fn key on a laptop or may be intercepted by a browser.

When Ctrl+Page Down does not work

If the shortcut does not switch sheets, first check the context in which you are typing. If the insertion point is inside a cell or the formula bar, Excel may still be editing a value. Press Enter to commit the edit or Esc to cancel it, then try the shortcut again. Also make sure the Excel workbook window is active rather than another open program.

Next, check the keyboard. A laptop may require Fn to access Page Down, and some compact keyboards use a different key combination. If you have an external keyboard available, try its dedicated Page Down key. You can also click the next visible sheet tab to confirm that the workbook itself can switch sheets; if tabs are not visible, the window may be narrow or the tab area may be obscured by the horizontal scroll bar.

Other checks that can help:

Confirm there is another visible sheet. If the active tab is the last visible one, the shortcut has nowhere further to go.
Check for an unexpected application or browser response. In Excel for the web, the browser may handle the key combination.
Check whether the workbook is protected or shared in a restricted way. Some workbook settings can limit changes to its structure, although sheet navigation itself is different from inserting, deleting, or moving tabs.
Try the reverse shortcut. Ctrl+Page Up can help establish whether worksheet navigation is responding in the opposite direction.

If the sheet tabs are hidden from view, that does not necessarily mean the sheets are hidden. Excel can hide the tab strip through its display settings. On Windows, check File > Options > Advanced, then the display options for the workbook, including Show sheet tabs. The precise setting is separate from hiding an individual worksheet.

Other ways to move between sheets

Clicking a visible sheet tab is the simplest alternative when the destination tab is on screen. It is also useful when you want to jump directly to a particular sheet rather than move one position at a time. If there are more tabs than fit in the window, use the sheet-tab navigation controls near the lower-left corner to scroll the tab strip, then select the desired tab. Scrolling those controls changes which tabs are visible; it does not itself select a different worksheet.

For a workbook with many sheets, right-clicking the small sheet-navigation arrows near the lower-left of the Excel window can display a list of sheet names, allowing you to choose a destination. This is distinct from the right-click menu on a sheet tab, which contains commands for that individual sheet. Depending on the workbook and version, the list may require selecting an item or using its controls to reach the sheet you want.

You can also use the mouse wheel or horizontal scroll bar to reveal tabs when they extend beyond the available space, but those actions should not be confused with changing the active sheet. The active sheet is the one whose tab is selected and whose grid is currently shown.

Choosing the fastest method for your workbook

Use Ctrl+Page Down or Ctrl+Page Up when you are moving sequentially through a small group of tabs. For example, when checking monthly sheets from April through June, pressing the next-sheet shortcut twice advances from April to May and then June. The keyboard approach keeps your hands near the worksheet and avoids aiming for narrow tabs.

Use a tab click or the sheet list when the destination is far away. If a workbook contains dozens of worksheets, pressing Ctrl+Page Down repeatedly from the first tab may be slower and makes it easier to overshoot. A direct selection is often more practical when you know the sheet name. If the workbook is regularly used for sequential review, arranging tabs in a sensible order can make the shortcut more useful.

For a reader following a set of instructions, state both the direction and the starting point. “Press Ctrl+Page Down twice from April” is clearer than “go to June,” especially when the workbook contains hidden worksheets or a customized tab order. This small clarification prevents confusion about what Excel counts as the next sheet.

Common misconceptions

Ctrl+Page Down is not the same as Page Down by itself. Page Down generally scrolls the worksheet view downward, while Ctrl+Page Down switches the active worksheet. Similarly, Ctrl+Page Up changes sheets; it does not scroll toward the top of the current grid.

The shortcut also does not create a new worksheet, change a sheet’s position, or reveal hidden tabs. It only activates the next visible sheet in the existing tab order. To add a sheet, use the plus button near the sheet tabs or the appropriate insert command. To change tab order, drag a tab; to reveal a hidden sheet, use the Unhide command where available.

Finally, the word “page” in the shortcut is the name of a keyboard key, not a reference to printed pages or page breaks. Switching worksheets does not alter print layout, page breaks, or the selected cell’s contents.

Frequently Asked Questions

What is the shortcut to go to the next sheet in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+Page Down. It activates the next visible worksheet in the tab order.

How do I go to the previous sheet in Excel?
Press Ctrl+Page Up in Excel for Windows. It moves to the previous visible worksheet.

Does Ctrl+Page Down wrap from the last sheet to the first?
No. It does not wrap around. At the last visible sheet, pressing it again leaves the active sheet unchanged.

How do I switch sheets on a MacBook without Page Up or Page Down keys?
Excel for Mac uses Control+Page Down and Control+Page Up. On many MacBook keyboards, use Fn with the arrow key to send Page Down or Page Up, such as Control+Fn+Down Arrow for the next sheet. Keyboard settings and models can differ.

Why does Ctrl+Page Down change browser tabs instead of Excel sheets?
This can happen in Excel for the web because the browser may capture the shortcut. Select the worksheet tab directly, or use the workbook’s sheet-navigation controls.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.