Excel Shortcut Keys for the Next Sheet in a Workbook

In Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next sheet in the active workbook; press Ctrl+Page Up to move to the previous one. These shortcuts change the selected sheet tab, not the open workbook or the active cell within the current sheet.

The shortcut at a glance

Excel follows the order of the visible sheet tabs along the bottom of the workbook. If the current tab is followed by another visible sheet, Ctrl+Page Down activates that next sheet. Ctrl+Page Up goes the other way. You do not need to click a cell first, although Excel must be the active application and the workbook must have keyboard focus.

Next sheet: Ctrl+Page Down
Previous sheet: Ctrl+Page Up
Next workbook on Windows: Ctrl+Tab, which is different from moving to the next sheet

Page Down may appear on a full-size keyboard as Page Down, PgDn, or a key paired with another function. On a compact laptop keyboard, it may be available through an Fn layer. The exact Fn combination depends on the computer, so check the keyboard’s labels or manufacturer’s instructions if the shortcut does not register.

How to move to the next sheet on Windows

Open the workbook, click a cell or another part of its worksheet, and press Ctrl and Page Down together. Excel activates the next visible sheet tab. Press the combination again to continue forward, or use Ctrl+Page Up to return. For example, if the tab order is January, February, March, pressing Ctrl+Page Down while January is active takes you to February; pressing it again takes you to March.

Make sure the workbook you want is active.
Check the sheet tabs at the bottom to understand their order.
Press and hold Ctrl, tap Page Down, then release the keys.
Repeat as needed, or use Ctrl+Page Up to go back.

The shortcut moves one tab at a time. It does not jump to the last sheet, select a sheet by name, or change the order of tabs. If you are typing into a cell or editing its contents, finish or cancel that edit first; a navigation shortcut may not behave as expected while Excel is in cell-edit mode.

What the shortcut changes

A workbook can contain many sheets, and each sheet has its own grid, cell contents, and tab. Ctrl+Page Down changes which sheet is active. It does not copy data, alter formulas, scroll to a different part of the current grid, or move the active tab to a new position. The destination sheet becomes the one displayed in the workbook window, and its active cell is shown.

Excel navigates among sheets in the order of their tabs, from left to right for the next-sheet shortcut. If tabs have been rearranged, the shortcut follows the new order. Hidden sheets are not available as ordinary tabs to select, so the shortcut moves between visible sheets rather than revealing a hidden one. A hidden sheet must first be unhidden through Excel’s sheet controls before you can navigate to it this way.

If the workbook contains only one visible sheet, pressing Ctrl+Page Down has nowhere to go and the displayed sheet remains the same. At the end of the visible tab sequence, the shortcut does not wrap around to the first sheet; similarly, Ctrl+Page Up at the first visible sheet does not cycle to the last.

Using the shortcut on a Mac

In Excel for Mac, the corresponding sheet-navigation shortcuts are also Control+Page Down for the next sheet and Control+Page Up for the previous sheet. Mac keyboards and external keyboards do not all provide dedicated Page Up and Page Down keys. On many Mac keyboards, Fn+Control+Down Arrow sends Control+Page Down, while Fn+Control+Up Arrow sends Control+Page Up. The Fn behavior can vary by keyboard and system settings, so use the on-screen sheet tabs if that key combination is unavailable.

Be careful not to substitute Command for Control simply because Command is the familiar modifier for many Mac shortcuts. For this sheet-navigation action, Excel uses Control with Page Down or Page Up. If your keyboard has dedicated Page keys, try Control plus the appropriate key. If it does not, clicking the sheet tab is a reliable alternative; you can also use the keyboard’s Fn layer if it supplies the missing Page key.

Excel for the web and browser shortcuts

Excel for the web runs inside a browser, so keyboard shortcuts can be affected by the browser, operating system, or keyboard layout. Ctrl+Page Down may work to move between sheets in the workbook, but browsers also use Ctrl+Page Down to move between browser tabs. If the browser changes tabs instead of Excel changing sheets, use the sheet tabs at the bottom of the workbook or try the workbook’s visible navigation controls.

This distinction matters when several Excel files are open in separate browser tabs. A browser-tab change takes you to another page or file, whereas a worksheet change keeps you in the same workbook and displays a different sheet. Look at the browser’s tab strip and Excel’s sheet tabs to confirm which level of navigation you need. If a shortcut seems inconsistent, clicking the intended sheet tab avoids ambiguity.

Choose a shortcut or a sheet tab

Ctrl+Page Down is most useful when you are moving sequentially through a workbook—for example, checking monthly worksheets, comparing consecutive versions, or reviewing a set of department tabs. It avoids moving your hands to the mouse and works well when the order of the sheets matches the order of your task.

Clicking a sheet tab is often better when the destination is several tabs away or has a distinctive name. For example, if you are on Summary and need to jump to Assumptions near the far right, repeated shortcut presses may be slower than selecting the named tab directly. If the tab is off-screen, use the sheet-tab navigation controls to bring it into view, or use the sheet list available from the navigation controls in desktop Excel.

For a long workbook, give tabs clear names and arrange related sheets together. A useful order might be Instructions, Summary, Inputs, then monthly detail sheets. This does not change how the shortcut works, but it makes each next or previous move more predictable. Color can help distinguish groups of tabs, but it does not alter their keyboard navigation order.

Common problems and fixes

The browser changes tabs: This can happen in Excel for the web because the browser may claim Ctrl+Page Down. Click the worksheet tab instead, or check whether Excel has focus.
Nothing appears to happen: The workbook may have only one visible sheet, you may be at the end of the tab order, or Excel may not have keyboard focus. Click inside the workbook and try again.
The keyboard has no Page Down key: Look for PgDn or a Page Down function on an Fn layer. On laptops, the exact key combination varies by model.
You moved to another file: Ctrl+Tab switches between open workbooks in desktop Excel on Windows; Ctrl+Page Down moves between sheets in the active workbook. Check which workbook window is active.
The desired sheet is missing: It may be hidden, or it may be in another workbook. A hidden sheet cannot be reached by stepping through visible tabs.

Another common misunderstanding is that Ctrl+Page Down inserts a new worksheet. It does not; it only activates an existing next sheet. To create a worksheet, use Excel’s new-sheet control or the appropriate Insert command. Likewise, pressing the shortcut does not change the selected cell’s value, although it changes which sheet’s active cell is visible.

A practical way to navigate a multi-sheet workbook

Suppose a workbook has tabs named Overview, January, February, March, and Notes. Starting on January, use Ctrl+Page Down once to reach February and again to reach March. If you then need Overview, pressing Ctrl+Page Up twice returns to January, but it does not take you directly to Overview. Because Overview is three positions before March, you would need three previous-sheet presses—or simply click Overview.

This example shows the main decision: use the shortcut for nearby sheets in sequence and use a tab click for a distant or specifically named destination. If you regularly review the same sequence, arranging the tabs to match that sequence can make keyboard navigation faster and reduce the chance of inspecting the wrong sheet.

Frequently Asked Questions

What is the shortcut for the next sheet in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+Page Down. In Excel for Mac, use Control+Page Down; if there is no Page Down key, a keyboard’s Fn layer may provide it.

How do I go to the previous sheet?
Press Ctrl+Page Up on Windows. In Excel for Mac, use Control+Page Up. The shortcut moves one visible sheet tab backward in the workbook’s tab order.

Does Ctrl+Page Down switch to the next Excel file?
No. It moves to the next sheet in the active workbook. In desktop Excel for Windows, Ctrl+Tab is used to switch between open workbooks; in Excel for the web, browser-tab shortcuts can also affect which file or page is displayed.

Can I use the shortcut to reach a hidden sheet?
No. Hidden sheets are not part of the visible tab sequence. Unhide the sheet using Excel’s sheet controls first, then move to it with the shortcut or select its tab.

Does Excel wrap to the first sheet after the last one?
No. At the end of the visible sheet sequence, Ctrl+Page Down stays at the last visible sheet. Use a tab click or Ctrl+Page Up to navigate elsewhere.

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.