Excel Next Sheet Shortcut for Windows, Mac and Web

In Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next worksheet in the current workbook. Press Ctrl+Page Up to move to the previous worksheet; on a Mac, the corresponding shortcuts are Control+Page Down and Control+Page Up.

The Windows shortcut and what it does

Excel treats each worksheet tab as part of a sequence. With a workbook open, Ctrl+Page Down activates the sheet immediately to the right of the active sheet, while leaving the workbook open. It does not move to a different workbook or scroll the cells within the current sheet. For example, if the tabs are Summary, January, February, and March, pressing the shortcut while Summary is active selects January; pressing it again selects February.

The reverse shortcut is Ctrl+Page Up. It moves left through the worksheet tabs. These shortcuts are useful when a workbook has several sheets and you need to move between them without reaching for the mouse.

Next worksheet: Ctrl+Page Down
Previous worksheet: Ctrl+Page Up

Page Down is sometimes printed as PgDn on a keyboard. The shortcut changes the active worksheet, not the selected cell’s location within a worksheet. Excel generally keeps the destination sheet’s own current cell selection, so switching sheets does not necessarily take you to cell A1.

Using the shortcut in a workbook

To use the shortcut, first make sure the workbook is open and Excel is receiving your keystrokes. If you have just clicked into a cell, you can normally press the shortcut directly. Excel activates the adjacent visible worksheet, and the selected tab changes to show which sheet is active.

Open the workbook and identify the active worksheet tab.
Press Ctrl+Page Down to move one visible worksheet to the right.
Press Ctrl+Page Up to move one visible worksheet to the left.
Repeat as needed; each key press advances or reverses by one sheet.

The shortcut follows the order of the sheet tabs, not alphabetical order, worksheet names, or the order in which you last visited them. If the tabs are arranged April, Overview, March, the next-sheet shortcut from Overview goes to March, even though March comes earlier alphabetically. Reorder tabs by dragging them if you want a different navigation sequence.

Mac and Excel for the web

In Excel for Mac, use Control+Page Down for the next sheet and Control+Page Up for the previous sheet. This is Control, not Command. Some Mac keyboards do not have dedicated Page Up and Page Down keys. On a keyboard where those keys are represented by the arrow keys, you may need to hold Fn as well, such as Fn+Control+Down Arrow for Page Down. The exact key combination depends on the keyboard.

Excel for the web can also support worksheet navigation with Ctrl+Page Down and Ctrl+Page Up, but the browser may reserve those combinations for moving between browser tabs. If the shortcut switches browser tabs or does not act on the worksheet, click the desired sheet tab instead. The ribbon and worksheet area also differ slightly from desktop Excel, so a mouse click is a straightforward alternative when browser shortcuts conflict.

Keyboard behavior can vary with the operating system, keyboard layout, browser, and whether Excel is running in a desktop app or a browser. If the key combination produces an unexpected result, check which application has focus and try the worksheet-tab options below.

What counts as the next sheet?

Next means the next visible worksheet in the workbook’s tab order. Hidden worksheets are not visited by Ctrl+Page Down or Ctrl+Page Up. If a sheet is hidden, it must first be unhidden before you can navigate to it in the usual way. In desktop Excel, right-click a sheet tab and choose Unhide to see available hidden worksheets, if any. A very hidden sheet, typically hidden through VBA, is not listed in that dialog and requires a different method to unhide.

The shortcut does not wrap from the final visible sheet back to the first one. If you are on the rightmost visible tab and press Ctrl+Page Down, Excel has no next sheet to activate; move to the left with Ctrl+Page Up or click another tab. Likewise, Ctrl+Page Up at the leftmost visible sheet cannot move farther left.

It is also worth distinguishing a worksheet from a workbook. A workbook is the Excel file, and a worksheet is one tab inside it. Ctrl+Page Down moves within the current workbook. It does not switch among separate open workbooks, even if several files are open at once.

Mouse and keyboard alternatives

For a small workbook, clicking the next sheet tab is often the simplest option. When many tabs are visible, Excel provides sheet-navigation controls at the lower-left edge of the workbook window, beside the tabs. These controls scroll the row of tabs; they do not, by themselves, activate another worksheet. Click a tab after scrolling to select it.

In desktop Excel, right-click one of the sheet-navigation arrows to open the Activate dialog, which lists worksheets you can select. This is handy when a workbook has so many tabs that the target is not visible, or when a sheet name is difficult to locate by scrolling. Selecting a name in the dialog activates that worksheet directly.

One or two nearby sheets: use Ctrl+Page Down or Ctrl+Page Up.
A visible destination: click its worksheet tab.
A distant sheet in a long tab row: right-click a sheet-navigation arrow and select the name in Activate.
A hidden worksheet: use Unhide first, if the sheet is available in that dialog.

These options solve different problems. The keyboard shortcut is quickest for sequential movement, while the Activate dialog is more direct when you know the name of a faraway sheet. Scrolling the tab bar only changes which tabs are displayed, so it can seem as if nothing happened if you expected the arrow click to switch worksheets.

Common reasons the shortcut seems not to work

First, check that the active window is Excel rather than another open app. In Excel for the web, a browser may capture Ctrl+Page Down to switch browser tabs. In that case, click the worksheet tab or use Excel desktop if you need dependable keyboard navigation.

On a compact laptop keyboard, Page Down may share a key with another function. Look for PgDn printed on a key or consult the keyboard’s Fn-layer markings; you may need to hold Fn while pressing the key combination. If pressing the shortcut changes a browser tab, adjusts another feature, or does nothing, the keyboard may not be sending Page Down to Excel as expected.

Also check whether you are at the end of the visible sheet sequence. The shortcut does not cycle around to the opposite end. A sheet that is hidden will not appear as the next destination, and scrolling the tab bar is not the same as selecting a sheet. If the workbook is protected, ordinary worksheet protection is different from workbook-structure protection; protection settings can restrict changes to the workbook, but they do not turn the next-sheet shortcut into a cell-navigation command.

Finally, if you are editing text inside a cell or the formula bar, finish or cancel that edit before trying to navigate. Excel may interpret keys differently while an edit is in progress. Press Enter to commit the edit or Esc to cancel it, then try Ctrl+Page Down again.

Using sheet navigation efficiently

For a workbook you use regularly, placing related worksheets beside one another makes sequential shortcuts more useful. For example, an annual report might group its monthly sheets in calendar order, followed by a Summary sheet. If you often move from Summary to a particular month, you can drag the tabs to put those sheets closer together, or use the Activate dialog to jump directly by name.

Meaningful sheet names also help. Names such as Sales, Budget, and Notes are easier to identify in a long workbook than generic labels such as Sheet1 and Sheet2. You can rename a tab by double-clicking it and typing a new name, or by right-clicking the tab and choosing Rename. Renaming changes the label, not the sheet’s position, so it will not change which worksheet Ctrl+Page Down reaches next.

When multiple worksheets are selected as a group, be careful before editing cells: changes made to a grouped selection can affect more than one sheet. The selected tabs are usually visibly highlighted. To leave a group, click a single worksheet tab. Sheet navigation is for moving among tabs; it is not a safeguard against editing several grouped sheets at once.

Frequently Asked Questions

What is the Excel shortcut for the next sheet?
In Excel for Windows, press Ctrl+Page Down. In Excel for Mac, press Control+Page Down. The shortcut activates the next visible worksheet to the right in the current workbook.

What is the shortcut for the previous sheet?
Press Ctrl+Page Up on Windows or Control+Page Up on Mac. It activates the previous visible worksheet to the left.

Does Ctrl+Page Down move to the next workbook?
No. It moves to another worksheet in the same workbook. To switch to another open workbook, use the Windows task switcher or Excel’s window controls instead.

Why does Ctrl+Page Down switch my browser tab?
When you use Excel for the web, the browser can capture that key combination. Click the worksheet tab directly, or try the shortcut in the Excel desktop app.

Can the shortcut reach a hidden sheet?
No. It moves among visible worksheets only. Unhide the worksheet first, if it is available through the workbook’s Unhide option.

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.