Keyboard Shortcut to Jump Tabs in Excel

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next worksheet tab, or Ctrl+Page Up to move to the previous one. On a Mac, use Control+Page Down and Control+Page Up; on a laptop without Page Up or Page Down keys, you may need the Fn key as well.

The Excel shortcut and what it does

The shortcut changes the active sheet in the current workbook. It does not move the selected cell, scroll through rows, or switch between separate Excel files. Think of it as moving left or right along the row of sheet tabs at the bottom of the workbook window.

  • Ctrl+Page Down: activates the next visible sheet to the right.
  • Ctrl+Page Up: activates the previous visible sheet to the left.

Press the shortcut once for each sheet you want to cross. For example, if you are on the first sheet and the workbook has five sheets in order, pressing Ctrl+Page Down three times takes you to the fourth sheet. The shortcut follows the workbook’s tab order, not the alphabetical order of sheet names. It also does not wrap from the last sheet back to the first: at the end of the visible tabs, another press will not take you around to the other end.

In everyday conversation, people often call these worksheet tabs simply tabs. Excel uses them to switch between sheets inside one workbook. Browser tabs, in contrast, represent separate web pages, and the keyboard shortcuts for those are different.

How to move through sheets efficiently

For a workbook with just a few sheets, the basic shortcut is usually all you need. Hold Ctrl and tap Page Down or Page Up repeatedly; you do not have to release Ctrl between presses. If the workbook contains many sheets, you can also combine the shortcut with the sheet-tab row to orient yourself: check the active tab name, move a few positions, and check again.

A practical example is a monthly report with tabs named January through December. If January is active and you need April, press Ctrl+Page Down three times. If you are on October and need August, press Ctrl+Page Up twice. The movement is based on physical tab position, so it still works if someone has rearranged the months or inserted a summary sheet between them.

When you do not know how many tabs away the destination is, avoid pressing the shortcut rapidly without checking. Move one sheet at a time until the tab name changes to the one you want. This can be especially useful in workbooks where similarly named tabs, such as Sales East and Sales West, are adjacent.

Windows keyboards and key variations

On a standard Windows keyboard, Page Up and Page Down are often separate keys, usually in the navigation-key cluster. Hold the Ctrl key and press the appropriate page key. On a laptop or compact keyboard, Page Up and Page Down may share keys with the arrow keys or another function. In that case, consult the keyboard’s labels or manufacturer instructions to learn which Fn combination produces Page Up or Page Down, then use that key with Ctrl.

Excel’s shortcut is still the same even when the physical key arrangement differs. For instance, if a laptop maps Page Down to Fn+Down Arrow, the equivalent action may require Ctrl+Fn+Down Arrow. The exact Fn behavior depends on the computer, so do not assume every laptop uses the same mapping. If the combination changes the cell selection or does something unexpected, try the dedicated page key or check the keyboard’s Fn-lock setting.

Also confirm that Excel has focus. If the active cursor is in a dialog box, the formula bar, or another application, the keystroke may be handled by that control instead of changing sheets. Click an ordinary worksheet cell and try again.

Using the shortcut on a Mac

Excel for Mac uses Control+Page Down for the next sheet and Control+Page Up for the previous sheet. Use the Control key, not Command, for this particular shortcut. Mac keyboards with full-size navigation keys can use Page Up and Page Down directly. On many MacBook keyboards, those page actions are produced with Fn plus the Up Arrow or Down Arrow, so the full combination may be Control+Fn+Down Arrow for the next sheet and Control+Fn+Up Arrow for the previous sheet.

Keyboard layouts and macOS settings vary, so if your Mac does not have dedicated Page keys, check how its Fn or Globe key is configured. The important distinction is that the sheet-navigation shortcut uses Control; Command+Page Up or Command+Page Down is not the standard Excel sheet-switching combination. If another application or system feature responds instead, use the sheet tabs or the sheet-navigation controls to switch.

Excel for the web and browser behavior

In Excel for the web, keyboard shortcuts can be affected by the browser because Excel is running inside a browser window. A combination that works in the desktop app may be intercepted by the browser or behave differently according to the browser and operating system. If Ctrl+Page Up or Ctrl+Page Down changes browser tabs rather than worksheet tabs, use the sheet tabs at the bottom of the workbook or Excel’s sheet-navigation controls instead.

Excel for the web may also display a shortcut-help interface that explains available commands for the current environment. The desktop Windows and Mac instructions above apply to their respective installed Excel apps; do not assume that every desktop shortcut passes through the browser unchanged. If you work in the web app regularly, test the keystroke in a noncritical workbook and rely on the visible sheet controls whenever browser behavior is ambiguous.

Choosing a sheet when there are many tabs

Ctrl+Page Up and Ctrl+Page Down are quickest when the destination is near the current sheet. For a workbook with dozens of tabs, repeatedly stepping across every sheet can be slow. Excel provides a sheet-navigation control near the lower-left corner of the window, beside the sheet-tab area. Depending on the workbook and window size, the tabs may not all be visible at once.

Try these approaches when the target is far away or its position is unclear:

  • Use the sheet-navigation arrows: the small controls beside the tab row let you scroll the visible tab strip. Scrolling the strip changes which tabs are shown; it does not necessarily activate a different sheet.
  • Open the sheet list: right-click the sheet-navigation arrows to display the Activate dialog, then choose a sheet name from the list. This is more direct than cycling through a long sequence of tabs.
  • Look for a workbook index: some workbooks include a contents or index sheet with links to important sections. If one exists, it may be a faster route than navigating the tab row.

These options are particularly helpful when tab names are shortened on screen, when the workbook has many sections, or when the sheet strip has been scrolled away from the current tab.

Common problems and quick fixes

If the shortcut appears not to work, first check that the active window is the desktop Excel workbook and that a worksheet cell is selected. Then press the matching Page key with Ctrl. On a laptop, check whether Page Up or Page Down requires Fn. A shortcut that scrolls the worksheet or changes a browser tab usually points to a key-mapping or focus issue rather than a problem with the workbook.

Another source of confusion is hidden sheets. The shortcut moves among sheets that are available in the tab sequence; a worksheet hidden by the workbook author will not appear as an ordinary tab to select. If you need a hidden sheet, use the workbook’s sheet controls or the Unhide option, if permitted. In shared or protected workbooks, you may not have permission to unhide or rearrange sheets.

Remember that scrolling the sheet-tab strip is different from switching the active sheet. The navigation arrows can move the visible strip without changing which worksheet is active. Look for the highlighted or otherwise emphasized tab to confirm the current sheet. Finally, Ctrl+Page Up and Ctrl+Page Down are not the same as Ctrl+Tab, which commonly moves between open workbooks or windows in desktop Excel. If your goal is another workbook rather than another sheet, use a workbook-switching command or the taskbar instead.

Switching sheets versus selecting multiple sheets

The regular shortcut activates one sheet at a time. It does not select a group of worksheets for editing together. Excel can group adjacent sheets using Shift along with a sheet-navigation shortcut, but grouped-sheet editing has consequences: changes made to cells can be applied to every selected sheet. A grouped selection is usually shown by multiple highlighted tabs, and it is easy to overlook.

If you only want to visit another sheet, do not add Shift. If you do intentionally group sheets, check the tab highlights before entering data, formatting cells, or deleting content. To return to working on one sheet, click a single sheet tab or use the workbook’s ungroup-sheets command where available. This distinction matters because users sometimes press an extra modifier key and then wonder why an edit appears on more than one worksheet.

Frequently Asked Questions

What is the shortcut to go to the next tab in Excel?
On Windows, press Ctrl+Page Down. On Mac, press Control+Page Down. It activates the next visible sheet in the workbook’s tab order.

How do I go to the previous sheet in Excel?
Press Ctrl+Page Up on Windows or Control+Page Up on Mac. If your Mac keyboard lacks Page Up, you may need Fn with the Up Arrow.

Can I jump directly to a sheet by name?
The Page Up and Page Down shortcuts move one sheet at a time; they do not open a name search. For a long workbook, right-click the sheet-navigation arrows near the lower-left corner and choose the sheet in the Activate dialog.

Why does Ctrl+Page Down switch browser tabs?
That can happen in Excel for the web because the browser may capture the shortcut. Use the worksheet tabs or sheet-navigation controls in Excel for the web, or open the workbook in the desktop Excel app if you need the desktop shortcut behavior.

Does the shortcut work if a sheet is hidden?
A hidden sheet is not shown as an ordinary tab, so you cannot activate it by stepping to its visible tab. If you have permission, unhide it through Excel’s sheet controls before navigating to it.

Will the shortcut move to the first sheet after the last one?
No. It moves through the tab order and stops at the end rather than wrapping around. Use the opposite direction repeatedly or select the destination from the sheet list.

Related

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.