Excel Shortcut to Switch Between Worksheet Tabs

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next sheet tab, or Ctrl+Page Up to move to the previous one. The shortcut follows the sheet-tab order, so it is a quick way to move through a workbook without reaching for the mouse.

The keyboard shortcut and what it does

Excel’s standard shortcuts for moving between sheets are Ctrl+Page Down and Ctrl+Page Up. Page Down advances one tab; Page Up goes back one tab. They change the active sheet in the current workbook, not the active cell within the current sheet. The selected cell or range on each sheet is generally retained when you return to it.

For example, suppose a workbook has tabs named January, February, and March in that order, and February is active. Press Ctrl+Page Down to show March. Press Ctrl+Page Up to return to February. If you are on January, repeated presses of Ctrl+Page Down move through the later tabs in their displayed order.

  • Next sheet: Ctrl+Page Down.
  • Previous sheet: Ctrl+Page Up.
  • Move several tabs: Press the shortcut repeatedly, or hold the keys only as long as needed; each press changes the active sheet by one position.

On many Windows keyboards, Page Up and Page Down are separate keys, often in the navigation-key group near Home and End. They are not the up- and down-arrow keys: Ctrl+Up Arrow and Ctrl+Down Arrow move around cells, rather than switching sheet tabs.

Which direction is next?

Next and previous refer to the order of tabs along the bottom of the Excel window, not to dates, alphabetical order, or the order in which sheets were created. If the visible tabs are Summary, Inputs, and Results from left to right, Ctrl+Page Down moves from Summary to Inputs, then from Inputs to Results. Ctrl+Page Up moves in the opposite direction.

If someone has rearranged the tabs, the shortcuts follow that new order. A sheet moved with the mouse may therefore become the next destination even if its name or contents suggest a different sequence. The shortcut selects the adjacent available sheet; it does not sort, rename, or reorganize tabs.

At the beginning or end of a long tab sequence, check the sheet-tab strip to see where you are. If you are unsure which sheet is active, Excel marks its tab as selected, and the worksheet grid changes to show that sheet’s contents. A quick glance at the tab name can prevent entering data on the wrong sheet.

Using the shortcut on a Mac

In Excel for Microsoft 365 on Mac, the corresponding shortcuts are generally Control+Page Down for the next sheet and Control+Page Up for the previous sheet. This is Control, not Command. Mac keyboard layouts differ, however, and many compact keyboards do not have dedicated Page Up and Page Down keys.

On many Mac keyboards, Fn+Up Arrow produces Page Up and Fn+Down Arrow produces Page Down. If that is how your keyboard is configured, try Fn+Control+Up Arrow to move to the previous sheet and Fn+Control+Down Arrow to move to the next. Keyboard settings and external keyboards can change how these keys are sent, so check Excel’s keyboard-shortcut help if the combination does not work as expected.

Excel for the web runs inside a browser, and browser shortcuts or keyboard settings can affect which keys reach Excel. If Ctrl+Page Up or Ctrl+Page Down switches browser tabs instead of sheets, use the sheet tabs with the mouse or consult the keyboard-shortcut list available in the web app. The desktop Windows shortcut should not be assumed to behave identically in every browser configuration.

Worksheet tabs versus open workbooks

A common source of confusion is the difference between moving between sheets and moving between workbook windows. Ctrl+Page Up and Ctrl+Page Down navigate tabs inside the current workbook. They do not switch from one file, such as Sales.xlsx, to another open file, such as Budget.xlsx.

On Windows, Ctrl+Tab is commonly used to move among open workbook windows in Excel. The exact experience can depend on how those workbooks are displayed. Alt+Tab switches between Windows applications or windows, which is useful for moving from Excel to another program but is not the sheet-navigation shortcut.

Use the shortcut that matches the destination:

  • Another tab in the same workbook: Ctrl+Page Up or Ctrl+Page Down.
  • Another open workbook: Ctrl+Tab, or select the workbook from Excel’s View options or the Windows task switcher.
  • Another application: Alt+Tab on Windows.

On a Mac, app and window switching follow macOS conventions, so Command+Tab switches applications. That does not replace Excel’s Control+Page Up or Control+Page Down shortcuts for moving between sheets within a workbook.

Working with many sheet tabs

The keyboard shortcut is especially useful when a workbook contains many tabs, because it can be faster and more precise than locating a narrow tab with the pointer. It is also practical when your hands are already on the keyboard, such as when reviewing monthly figures or checking a series of department sheets.

For instance, imagine a workbook with one tab for each month. If the tabs are arranged January through December, start on April and press Ctrl+Page Down twice to reach June. The shortcut does not jump directly to a named month, so for a very large workbook with dozens of tabs, it may be quicker to select the destination from the sheet-tab area or use Excel’s navigation controls.

When tabs extend beyond the visible part of the window, Excel provides small sheet-navigation arrows near the lower-left corner. These arrows scroll the tab strip; they do not necessarily change the active sheet by themselves. After scrolling the strip, select the desired tab. The keyboard shortcut, by contrast, changes the active sheet directly, even if its tab is not currently in view.

For a workbook whose sheet order changes often, consider giving tabs clear names and arranging related sheets together. Names such as Q1 Sales or Region West are easier to recognize than Sheet17. Keyboard navigation follows the order you set, so a thoughtful tab order makes repeated movement more predictable.

Common reasons the shortcut seems not to work

If pressing the shortcut does something unexpected, first check that Excel has focus and that you are not in the middle of editing a cell. When a cell is being edited, press Enter to accept the edit or Esc to cancel it, then try the sheet shortcut again. Also confirm that you are pressing Page Up or Page Down rather than the arrow keys.

  • The browser changes tabs: In Excel for the web, the browser may claim a key combination. Use the sheet tabs or check the web app’s shortcut guidance.
  • The keyboard has no Page keys: Look for an Fn-layer key combination or use the tab strip. On a Mac, Fn with the arrow keys may generate Page Up or Page Down.
  • The expected sheet is missing: It may be hidden. Hidden sheets are not available as ordinary visible tabs for navigation.
  • The active sheet changes unexpectedly: Check the tab order and the selected tab name; a workbook may have been rearranged.
  • Several sheets appear selected: You may have used Ctrl+Shift+Page Up or Ctrl+Shift+Page Down rather than the shortcut without Shift.

To show a hidden sheet in Excel for Microsoft 365 on Windows, right-click a visible sheet tab and choose Unhide, then select the sheet in the dialog. You can also use Home > Format > Hide & Unhide > Unhide Sheet. If the workbook structure is protected, the option to unhide or rearrange sheets may be unavailable until the protection is removed by someone authorized to do so.

Avoid accidentally grouping sheets

Be careful not to add Shift to the shortcut by mistake. Ctrl+Shift+Page Up and Ctrl+Shift+Page Down select additional adjacent sheets along with the current one, creating a group selection. Excel may display [Group] in the title bar when multiple sheets are selected. Changes made while sheets are grouped can affect corresponding cells on every selected sheet, which is easy to overlook.

If you notice that multiple tabs are selected, click a single unselected sheet tab to leave the group, or right-click a selected tab and choose Ungroup Sheets. Before entering or pasting data, check that only the intended sheet is active. Grouping is useful when you deliberately want to apply the same layout or entry to several sheets, but it is not required for ordinary tab navigation.

Mouse and other navigation alternatives

The shortcut is not the only way to choose a sheet. Click a visible tab to jump directly to it, which is often simplest when the destination is far away or has a distinctive name. If tabs are crowded, use the sheet-navigation controls at the lower-left of the window to bring more of the tab strip into view, then select the target.

Right-clicking the small navigation arrows can open a list of sheets in some desktop versions of Excel, making it easier to select a sheet by name when many tabs exist. If that menu is unavailable in your version or setup, the arrows can still scroll the tab strip and you can click the visible destination. These methods select a specific tab; Ctrl+Page Up and Ctrl+Page Down are most convenient when moving just one or a few positions at a time.

For frequent work in a large workbook, a clearly labeled index or contents sheet can provide links to important tabs. Hyperlinks can take you to a specific worksheet, while the keyboard shortcut remains useful for moving among neighboring sheets. These approaches complement one another: direct selection is efficient for distant destinations, and the shortcut is efficient for sequential review.

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 to go to the next sheet tab. On Mac, use Control+Page Down, with the appropriate Fn key combination if your keyboard has no dedicated Page Down key.

How do I go to the previous sheet in Excel?

Press Ctrl+Page Up on Windows. In Excel for Mac, use Control+Page Up. The previous sheet is the tab immediately to the left of the active tab in the sheet order.

Does Ctrl+Tab switch between Excel sheets?

No. Ctrl+Page Up and Ctrl+Page Down move between sheets in the current workbook. Ctrl+Tab is generally used to move between open workbook windows in desktop Excel on Windows; browser behavior can differ in Excel for the web.

Why does Ctrl+Page Down change my browser tab?

When Excel is open in a browser, the browser may intercept the shortcut before Excel receives it. Select the worksheet tab directly or check the keyboard-shortcut help in Excel for the web. The desktop app is less likely to have this browser conflict.

Can I use the shortcut to open a hidden worksheet?

No. A hidden worksheet is not available as a normal visible tab for this navigation. Unhide it first, if you have permission, using the sheet-tab context menu or Home > Format > Hide & Unhide > Unhide Sheet.

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.