In Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next visible sheet in the active workbook. Press Ctrl+Page Up to move to the previous sheet. The shortcut follows the order of the sheet tabs, so it is a quick way to move through a workbook without reaching for the mouse.
The shortcut and what it does
Click a cell in the worksheet, then hold Ctrl and press Page Down (often labeled PgDn) once. Excel activates the next visible sheet tab. Press the shortcut again to move one more sheet forward. The reverse command is Ctrl+Page Up (or Ctrl+PgUp).
For example, suppose the tabs at the bottom of a workbook are named January, February, March, and Summary, in that order. If January is active, Ctrl+Page Down activates February. Pressing it again activates March. From March, Ctrl+Page Up returns to February. The shortcut changes the active sheet; it does not move the selected cell to another position or change the order of the tabs.
- Next sheet: Ctrl+Page Down
- Previous sheet: Ctrl+Page Up
- Where it works: among the sheet tabs in the active workbook, when Excel has focus
These commands are especially useful when a workbook has many tabs, or when you are comparing the same cell or layout across monthly, regional, or departmental sheets. You can keep your hands on the keyboard and move through the tab sequence without clicking each tab.
How sheet order affects navigation
Ctrl+Page Down and Ctrl+Page Up follow the left-to-right order of the sheet tabs, not the order in which you last visited sheets. If the tabs read East, West, Central, then Ctrl+Page Down from East goes to West, even if Central was the sheet you used most recently. Rearranging the tabs changes which sheet counts as next.
The shortcut moves among sheets that are available as tabs. A hidden sheet is not shown as a normal tab and is not a stop you can activate by paging through visible tabs. If you expected a particular sheet but skipped past its place, check whether it is hidden or whether the tab order differs from what you assumed. A very hidden sheet, typically managed through the Visual Basic Editor, also will not appear as an ordinary tab.
At the end of the visible tab sequence, Excel does not treat Ctrl+Page Down as a command to open another workbook or create a new sheet. Use the tabs, the sheet-navigation controls, or the workbook’s sheet-management commands to reach or add sheets as needed. This distinction matters in large workbooks: the shortcut is a step forward through the current tab sequence, not a search function.
Using it while working in a cell
For predictable results, make sure Excel is responding to worksheet navigation rather than text entry. If you are editing a cell and see a text cursor in the formula bar or inside the cell, press Esc to cancel the edit or Enter to commit it. Then press Ctrl+Page Down. In edit mode, keystrokes can apply to the text or formula being edited instead of changing sheets.
The shortcut changes the active sheet while leaving the cell selection on the sheet you left untouched. Each sheet keeps its own selection and scroll position, so returning to a sheet often brings you back to the cell and view you were using there. That is handy when checking corresponding values across sheets: select a cell on one tab, page to another, and inspect the equivalent location. Do not assume Excel has copied or synchronized the selection; the underlying cells remain independent unless formulas or other workbook features link them.
Sheet protection normally does not block switching tabs. Protection controls actions such as editing locked cells or changing worksheet structure, depending on how it was set up; it is separate from the keyboard command for changing the active sheet. If the shortcut appears not to work, check focus, keyboard layout, and whether the workbook contains another visible sheet before concluding that protection is responsible.
When the shortcut does not work
Most failures come from a key or focus issue rather than an Excel setting. Try these checks in order:
- Confirm the active window. Click a cell in the workbook and try the shortcut again. If another application or a dialog has focus, Excel may not receive the keystroke.
- Exit cell editing. Press Esc or Enter if you are editing a formula or cell value, then retry.
- Find the Page Down key. On compact keyboards, PgDn may share a key with an arrow or another function. The required Fn combination varies by laptop model; check the key labels or the computer manufacturer’s instructions.
- Check for another visible tab. If the workbook has only one visible sheet, there may be no next sheet to activate. Hidden sheets do not appear in the tab sequence.
- Check which application owns the shortcut. In a web browser, Ctrl+Page Down may switch browser tabs instead of changing worksheet tabs. See the web-version notes below.
Also distinguish between scrolling the sheet-tab strip and activating a sheet. The small navigation arrows near the bottom-left of the Excel window can scroll the row of tabs when there are too many to display. Clicking one of those arrows does not necessarily change the active sheet; click a sheet tab itself to activate it. In desktop Excel for Windows, right-clicking those navigation arrows opens an Activate list of sheets, which can be faster than paging through a long sequence.
Windows, Mac, and Excel for the web
In desktop Excel for Windows, the standard commands are Ctrl+Page Down for the next sheet and Ctrl+Page Up for the previous one. On a full-size keyboard, Page Down and Page Up usually have dedicated keys. On a laptop, they may be secondary functions accessed with Fn, and the precise key combination depends on the keyboard design. If PgDn is printed on the Down Arrow, for example, the laptop may require Fn along with the Excel shortcut.
In Excel for Mac, the corresponding sheet-navigation shortcuts are also Control+Page Down and Control+Page Up. Mac keyboards differ: an external keyboard may have Page Down and Page Up keys, while a MacBook may require Fn with an arrow key to produce page navigation. If the combination is intercepted or does not behave as expected, use the sheet tabs as a reliable alternative. Note that the Control key is not the Command key; do not substitute Command just because it is commonly used for other Mac shortcuts.
Excel for the web runs inside a browser, and browser shortcuts can take precedence. In common browsers, Ctrl+Page Down is used to move to the next browser tab, so it may switch away from the workbook rather than advance its worksheet tab. Use the visible worksheet tabs in the web app, or open the workbook in desktop Excel when keyboard sheet navigation is important. The exact behavior can depend on the browser and keyboard focus.
Related shortcuts and common mix-ups
Ctrl+Page Down is specifically for moving to the next sheet. It is easy to confuse it with shortcuts that navigate within a sheet or between workbook windows. These commands do different jobs:
- Tab moves the active cell to the next cell in the row in many ordinary worksheet situations; it does not switch sheets.
- Ctrl+Arrow moves the active cell to the edge of a data region or to the next nonblank boundary, depending on the starting cell and surrounding data. It stays on the current sheet.
- Ctrl+Tab is associated with moving between open workbook windows in desktop Excel, rather than stepping through sheet tabs. The exact window behavior can depend on the Excel interface and open workbooks.
- Ctrl+Page Up is the backward companion to Ctrl+Page Down. It does not mean move to the previous page of printed output.
This difference is useful when diagnosing a shortcut that seems to do the wrong thing. If the active cell changes but the tab does not, you probably used a cell-navigation command. If the browser window changes tabs, the browser captured the keys. If you want a different sheet by name rather than the next one in order, use the tab itself or the Activate list instead of repeatedly pressing Ctrl+Page Down.
Mouse and navigation alternatives
Keyboard navigation is not the only way to change worksheets. Click a visible tab at the bottom of the workbook to go directly to that sheet. When a workbook has more tabs than fit on screen, use the tab-strip navigation controls to bring the desired tab into view, then click it. In desktop Excel for Windows, the Activate dialog reached by right-clicking the sheet-navigation arrows provides a list that is useful when sheet names are known but tabs are crowded.
For a workbook with dozens or hundreds of sheets, pressing the shortcut repeatedly may be less efficient than choosing a sheet directly. Consider giving sheets clear names and keeping related tabs together. If you regularly move between a small set of distant sheets, you can also use links within the workbook, such as a cell hyperlink, where that suits the workbook’s design. These alternatives do not change what Ctrl+Page Down means; they simply offer faster routes when sequential navigation is not the goal.
Frequently Asked Questions
What is the Excel shortcut for the next sheet?
In desktop Excel, press Ctrl+Page Down on Windows. In Excel for Mac, use Control+Page Down. On a laptop without dedicated Page Down, a keyboard-specific Fn combination may be needed.
How do I go to the previous sheet in Excel?
Press Ctrl+Page Up on Windows or Control+Page Up on Mac. The command moves backward one visible sheet in the tab order.
Why does Ctrl+Page Down change my browser tab?
When Excel is open in a browser, the browser may capture Ctrl+Page Down as its next-tab command. Click the worksheet tab directly, or use desktop Excel if you need the desktop keyboard shortcut.
Can I use the shortcut to open a hidden sheet?
No. Hidden sheets do not appear in the visible tab sequence. Unhide the sheet through Excel’s sheet controls, if you have permission, before navigating to it.
Does Ctrl+Page Down move to the next workbook?
No. It moves to the next sheet in the active workbook. Workbook-window navigation is a separate task, and browser tabs are separate again.
Why does nothing happen when I press it?
Check that Excel has focus, that you are not still editing a cell, and that another visible sheet exists. On a laptop, verify how its keyboard produces Page Down; in a browser, use the worksheet tabs because the browser may intercept the shortcut.
Related
- Excel Hide Shortcut: Hide Rows, Columns, and Sheets
- Excel: Highlight Cells With Dates Before Today
- Excel Hex Number Format: Convert Numbers to Hex
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Custom Number Format for Dark Green NumbersTo display numbers in dark green with an Excel custom number format, select the cells, press Ctrl+1, choose…
- Family Tree Template in Word: Create and Customize OneTo create a family tree template in Microsoft Word, set the page to landscape, add editable boxes for…
- Google Sheets Growth Percentage Formula: How It Works and ExamplesTo calculate growth percentage in Google Sheets, subtract the earlier value from the later value, divide by the…
- Goal Seek in Excel: How to Find a Target ValueTo use Goal Seek in Excel for Microsoft 365 on Windows, open Data > What-If Analysis > Goal…
- How to Highlight Cells Yellow in ExcelTo highlight cells yellow in Excel for Microsoft 365 on Windows, select the cell or range, open Home…
- Lock Cells in Google Sheets: Step-by-Step GuideTo lock specific cells in Google Sheets, select the cells, choose Data > Protect sheets and ranges, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.