Excel Shortcut to Jump Between Sheets: Keys and Tips

In Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next worksheet and Ctrl+Page Up to move to the previous one. The shortcut follows the worksheet-tab order in the workbook, so you can move through the tabs without using the mouse.

The Excel shortcuts at a glance

Use these keys while you are working in a workbook:

Ctrl+Page Down: activate the next sheet to the right.
Ctrl+Page Up: activate the previous sheet to the left.

“Page Down” and “Page Up” refer to the keyboard keys, often labeled PgDn and PgUp. They do not mean the Down Arrow or Up Arrow. On a full-size Windows keyboard, hold Ctrl and press the appropriate Page key. On some compact keyboards, the Page Up and Page Down functions share keys with other functions; check the key labels or your computer’s keyboard instructions if the shortcut does not seem to register.

The shortcut changes the active sheet, not the selected cell’s position within a sheet. For example, if you are editing cell D12 on one worksheet, pressing Ctrl+Page Down takes you to the next worksheet. It does not scroll down the current sheet or move the selection to another workbook.

How to use the shortcut

You can use the shortcut whether a sheet contains a small table or a large model. First, make sure the workbook window is active. Then press the key combination for the direction you want:

To go forward through the tabs, hold Ctrl and press Page Down.
To go back, hold Ctrl and press Page Up.
Repeat the shortcut to continue moving one sheet at a time.

Suppose a workbook has tabs named January, February, March, and Summary in that order, and January is active. One press of Ctrl+Page Down activates February; another activates March. Ctrl+Page Up from March returns to February. The names do not determine the direction: Excel uses the tabs’ current order, so a tab labeled “Summary” can come before “January” if someone has rearranged the workbook.

You do not need to click a worksheet tab first. If a cell is selected, the shortcut works from there. If you are typing into a cell or editing text in the formula bar, however, Excel may treat keystrokes as part of that editing operation rather than as sheet navigation. Press Enter or Esc to finish or cancel the edit, then try the shortcut again.

What the shortcut changes—and what it does not

Ctrl+Page Up and Ctrl+Page Down switch the active worksheet within the current workbook. The active sheet is the one displayed in the worksheet area, and its tab is usually highlighted. These keys do not move a tab, rename a sheet, create a new sheet, or switch between separate Excel workbooks.

They follow the visible worksheet tabs from left to right. A hidden worksheet is not a stop in the normal tab sequence because it has no visible tab to activate. If a sheet you expect to reach is hidden, use Excel’s unhide controls instead: right-click a visible sheet tab, choose Unhide, select the sheet, and confirm. If Unhide is unavailable, there may be no ordinarily hidden sheet to show, or workbook structure protection may be preventing changes.

It is also useful to distinguish worksheet navigation from scrolling. Page Up and Page Down alone can scroll the displayed sheet, depending on the keyboard and Excel’s current state. Adding Ctrl changes the action to switching between sheets on Windows. If the worksheet view moves instead of the active tab changing, check whether Ctrl is being held and whether the correct Page key is being used.

Using the shortcut on a Mac

In Excel for Mac, the corresponding commands are generally Control+Page Down for the next sheet and Control+Page Up for the previous sheet. The modifier is Control, not Command. A Mac keyboard with dedicated Page Up and Page Down keys can use those keys directly with Control.

Many MacBooks and compact Apple keyboards do not have separate Page keys. On those keyboards, the Page Up and Page Down actions are commonly produced with the Fn key and the Up or Down Arrow. Try Fn+Control+Down Arrow for the next sheet and Fn+Control+Up Arrow for the previous sheet. Keyboard layouts and function-key settings can differ, so if that combination does not work, use the worksheet tabs or check the shortcut reference for your version of Excel and keyboard.

Excel for Mac has other keyboard shortcuts that use Command or Option, but those are not interchangeable with this sheet-navigation shortcut. If you use an external Windows-style keyboard with a Mac, the physical key labeled Ctrl may act differently depending on its settings; the important point is to use the Control modifier recognized by Excel, together with the Page key.

Excel for the web and browser keyboards

Excel for the web runs inside a browser, and browser shortcuts can compete with Excel shortcuts. In particular, Page-key combinations may behave differently depending on the browser, operating system, and keyboard. If Ctrl+Page Up or Ctrl+Page Down changes browser tabs or has no effect on the sheet, use the worksheet tabs at the bottom of the workbook instead.

In the web version, click the tab for the sheet you want. If the tab is off-screen, use the sheet-tab navigation controls near the lower-left corner to scroll the tab strip, then select the desired tab. The exact controls visible depend on the workbook window size and how many sheets it contains. This is also a dependable option when using a tablet keyboard or a laptop without dedicated Page keys.

Do not assume that a shortcut documented for desktop Excel will behave identically in every browser. Browser-reserved keys, accessibility tools, and keyboard remapping can affect the result. If you rely on a keyboard-only workflow in Excel for the web, consult Microsoft’s current Excel for the web shortcut reference for your browser, or use the available tab controls and test any alternate combination in a noncritical workbook first.

Mouse and keyboard alternatives

The shortcut is quickest for moving one sheet at a time, but Excel provides other ways to reach a particular tab when a workbook has many sheets. On Windows desktop Excel, the small sheet-navigation arrows at the bottom-left of the window can scroll the tab strip. Clicking those arrows changes which tabs are visible; it does not necessarily activate the sheet whose tab comes into view.

To jump directly to a named sheet, right-click the sheet-navigation arrows at the bottom-left. Excel opens an Activate list of sheets; choose the sheet you want and select OK. This is useful when a workbook has dozens of tabs and the destination is far from the current one. If the list is long, choosing a distinctive sheet name can be quicker than repeatedly pressing Ctrl+Page Down.

You can also click a visible worksheet tab to activate it. If you need to change the order rather than navigate, drag a tab left or right along the tab strip. Keep the two actions distinct: Ctrl+Page Up/Down visits sheets in their existing order, while dragging changes that order for everyone who uses the workbook.

For a workbook with only a few tabs, mouse clicks may be simplest. For a workbook with a long sequence of monthly sheets, the keyboard shortcut is often faster. For a workbook with many unrelated tabs, the Activate list is more direct than stepping through every intermediate sheet.

Common reasons the shortcut does not work

If the active sheet does not change, check the context before assuming Excel has a problem. The following issues account for many failed attempts:

Wrong key: use Page Up or Page Down, not the arrow keys or the number pad’s 9 and 3 unless those keys are explicitly producing Page functions.
Cell is being edited: press Enter or Esc to leave edit mode, then try again.
Compact keyboard: use the keyboard’s Fn layer to access Page Up or Page Down, if required.
Browser conflict: in Excel for the web, a browser may claim the shortcut. Click the sheet tab instead.
Only one visible sheet: there may be no other visible worksheet to move to. Check whether tabs are hidden or the sheet you need is hidden.
Wrong workbook window: activate the workbook containing the sheets you want before using the shortcut.

Also check whether the active workbook is protected in a way that restricts workbook structure changes. Protection generally matters when trying to unhide, add, delete, or reorder sheets; it is not a reason to expect the basic navigation shortcut to rename or reveal a hidden sheet. If navigation works but the target is missing from the tab strip, investigate hidden sheets rather than repeatedly pressing the shortcut.

Choosing the right way to navigate

A useful rule is to use Ctrl+Page Up or Ctrl+Page Down when the destination is one or a few tabs away. Use the Activate list when you know the destination’s name but it is many tabs away. Use the tab-strip arrows when the tabs are simply outside the visible area, and click a visible tab when the destination is already in view.

For example, imagine a workbook ordered as Instructions, Data, Q1, Q2, Q3, Q4, and Dashboard. From Q2, a single Ctrl+Page Down reaches Q3. From Instructions, repeatedly pressing the shortcut will reach the later sheets, but selecting Dashboard from the Activate list is likely more efficient. If Dashboard is hidden, neither method will make it appear; unhide it first if workbook permissions allow.

Tab order can be part of how people understand a workbook. Before moving tabs to make navigation easier, consider whether other users rely on the current sequence or whether formulas, instructions, or macros refer to sheets by name or position. The navigation shortcut itself does not alter workbook contents, which makes it a low-risk way to inspect sheets without rearranging them.

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 sheet to the right in the tab order.

How do I go to the previous sheet in Excel?
Press Ctrl+Page Up on Windows. In Excel for Mac, use Control with Page Up; on a compact Mac keyboard, Fn+Control+Up Arrow may provide the Page Up action.

Can I jump directly to a specific sheet?
Yes. In desktop Excel for Windows, right-click the sheet-navigation arrows at the bottom-left and choose the sheet in the Activate list. If its tab is visible, clicking the tab is another direct option.

Why does Ctrl+Page Down switch browser tabs instead?
When using Excel for the web, the browser can intercept keyboard combinations. Select the worksheet tab directly, or use the sheet-tab navigation controls to bring it into view.

Does the shortcut work on hidden worksheets?
No. The shortcut moves through visible sheet tabs, so a hidden worksheet is not part of the normal sequence. Unhide the sheet first, if you have permission, and then navigate to it.

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.