Excel Keyboard Shortcuts for Changing Tabs

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, press Ctrl+Page Up to move to the previous worksheet tab, or Ctrl+Page Down to move to the next one. These shortcuts change the active worksheet in the current workbook; they do not switch between open workbooks or browser tabs.

The shortcuts at a glance

Excel’s worksheet tabs are the named tabs along the bottom of the workbook window. The standard Windows shortcuts are:

  • Ctrl+Page Up: activate the worksheet immediately to the left of the current sheet.
  • Ctrl+Page Down: activate the worksheet immediately to the right of the current sheet.

For example, if a workbook has tabs named January, February, and March, and February is active, Ctrl+Page Up selects January. Ctrl+Page Down selects March. Press the shortcut again to continue through the visible worksheets in order. The sequence follows the tabs’ left-to-right arrangement, not their names, dates, or the order in which you opened them.

At the first or last visible worksheet, the shortcut does not wrap around to the other end of the tab row. If the active sheet is January, Ctrl+Page Up will not jump to March. You can instead click the tab you want or use the shortcut in the direction of a sheet that is available.

What changing a worksheet tab actually does

Each worksheet tab represents a separate sheet within the same Excel workbook. Changing tabs makes a different sheet active; it does not move, rename, copy, or reorder any sheets. The workbook remains open, and the new active sheet is the one Excel displays and uses for most actions such as entering data, editing a cell, or applying formatting.

The active cell can differ from sheet to sheet. If you move from a budget sheet where cell B4 is selected to a forecast sheet where cell G12 was last active, Excel normally displays the forecast sheet with G12 selected. The shortcut does not move the selection to the same cell address on every sheet, nor does it copy the selected cell’s contents.

This distinction matters when a workbook has several windows or files open. Ctrl+Page Up and Ctrl+Page Down move among sheets in the current workbook. They are not the same as changing between different Excel workbooks, and they do not move between tabs in a web browser.

How to use the shortcuts step by step

  1. Click a cell on the worksheet you want to start from, or otherwise make that worksheet active.
  2. Hold down Ctrl and press Page Up to go one worksheet to the left, or Page Down to go one worksheet to the right.
  3. Press the same key combination again if you need to move farther through the visible tabs.

You do not need to click the sheet-tab area first. The shortcut works while the worksheet grid is active, so it is useful when your hands are already on the keyboard. If a dialog box, an in-cell edit, or another control has focus, however, Excel may interpret the keypress differently or the focused control may handle it. Finish or cancel the current edit and try again if the sheet does not change.

These shortcuts are especially handy in a workbook where adjacent sheets form a sequence, such as months, departments, or project stages. They are less direct when the desired sheet is far away: repeated keypresses move only one sheet at a time, so clicking a distant tab may be quicker.

Using the shortcuts on a Mac or in Excel for the web

In Excel for Microsoft 365 on Mac, the worksheet-navigation commands are also Control+Page Up and Control+Page Down. Use the Control key, not Command. Some Mac keyboards do not have dedicated Page Up and Page Down keys. On many MacBook keyboards, Fn+Up Arrow acts as Page Up and Fn+Down Arrow acts as Page Down, so the corresponding combinations are often Control+Fn+Up Arrow and Control+Fn+Down Arrow. Keyboard layouts and settings can differ; if those combinations do not work, use the sheet tabs or check Excel’s shortcut list for your setup.

Excel for the web runs inside a browser, where the browser may reserve some key combinations for its own tab navigation. The available behavior can depend on the browser and its shortcut settings. If Ctrl+Page Up or Ctrl+Page Down changes the browser tab instead of the worksheet, use the worksheet tabs at the bottom of Excel, or open Excel’s keyboard-shortcut help and check whether an option to override browser shortcuts is available. A shortcut that works in the Windows desktop app is not guaranteed to behave identically in every browser.

Related shortcuts that do different jobs

Several familiar keyboard commands can sound as though they might change worksheet tabs, but they act elsewhere:

  • Tab moves the cell selection one column to the right in the worksheet grid. It does not select the next worksheet tab.
  • Shift+Tab usually moves the selection one cell to the left while working in the grid.
  • Ctrl+F6 moves among workbook windows in Excel; it is relevant when you have more than one workbook window open, not when you want the neighboring sheet in one workbook.
  • Ctrl+Page Up and Ctrl+Page Down are the commands for moving between adjacent worksheets in the Windows desktop app.

People sometimes say they want to change an Excel tab when they mean a sheet tab, a workbook, or a browser tab. Identifying which one you mean helps avoid using the wrong shortcut. If the names along the bottom of Excel change, you have switched worksheets. If a different file window appears, you have switched workbooks. If the browser’s top row changes, you have switched browser tabs.

Common problems and ways to fix them

  • The browser changes tabs instead. This is most likely when using Excel for the web. Try the sheet-tab controls, or review the browser-shortcut override option in Excel’s shortcut help if it is available.
  • The shortcut appears to do nothing. Confirm that Excel has focus and that you are not typing inside a cell or using a dialog. Also check that the keyboard sends Page Up or Page Down as expected; laptop function-key settings can change how those keys work.
  • You cannot reach a sheet. The shortcut moves through visible worksheets. A hidden worksheet is not available as a normal visible tab; unhide it before navigating to it. In desktop Excel, right-click a visible sheet tab and choose Unhide to see the available hidden sheets.
  • You reach the end of the tab row. The shortcut does not cycle from the last visible sheet back to the first. Reverse direction or select the target tab directly.
  • The sheet you want is far away. Repeated shortcuts are possible, but using the tab itself is often faster. If the sheet tabs are crowded, the navigation controls beside the tab row can help move through the tab strip.

Also check whether the workbook is in a mode that limits editing or whether another window is covering Excel. If the key combination behaves unexpectedly only in one workbook, try it in a simple workbook to distinguish a workbook-specific situation from a keyboard or browser issue.

Choosing between keyboard navigation and clicking

Keyboard navigation is most useful when you move regularly between neighboring sheets. For example, while checking figures in April and May, Ctrl+Page Up and Ctrl+Page Down let you compare the two without reaching for the mouse. It is also useful when the tab names are short and the sheets are arranged in a logical order.

Clicking is often better when the destination is several tabs away, when sheet names are meaningful and easy to identify, or when you are not sure where a sheet sits in the sequence. Clicking also makes the target explicit: you can read the name before selecting it. There is no need to choose one method permanently; keyboard shortcuts and mouse navigation are simply different ways to activate a worksheet.

If a workbook has many sheets, consider whether the tab order makes sense for the people who use it. Related sheets placed together make one-step navigation more useful. Clear, distinct names can also reduce the chance of selecting the wrong sheet, especially when several tabs are visible at once.

Frequently Asked Questions

What is the shortcut to switch sheets in Excel?
In Excel for Microsoft 365 on Windows, use Ctrl+Page Up for the previous worksheet and Ctrl+Page Down for the next worksheet. On Mac, use Control+Page Up or Control+Page Down, subject to the keys available on your keyboard.

Does Ctrl+Tab change worksheet tabs in Excel?
Ctrl+Tab is not the standard Windows shortcut for moving between adjacent worksheets. Use Ctrl+Page Up or Ctrl+Page Down for sheets. Ctrl+F6 is used to move among workbook windows in Excel.

Can I jump directly to a worksheet by typing its name?
The Page Up and Page Down shortcuts move one visible sheet at a time; they do not open a name search. For a distant sheet, click its tab if visible, or use the tab-navigation controls to bring it into view and then select it.

Why does Ctrl+Page Down switch my browser tab?
In Excel for the web, the browser can intercept a shortcut that desktop Excel uses for worksheet navigation. Select the worksheet tab directly or check Excel’s keyboard-shortcut help for browser override options.

Can the shortcut open a hidden worksheet?
No. Hidden sheets do not appear as ordinary tabs in the navigation sequence. Unhide the sheet first, then use the shortcut or click its tab.

Quick takeaway

For worksheet tabs in desktop Excel for Windows, remember Ctrl+Page Up for the sheet to the left and Ctrl+Page Down for the sheet to the right. On Mac, use the Control key with Page Up or Page Down; in a browser, use the visible worksheet tabs if the browser captures the shortcut. The commands change the active sheet, not the workbook or browser tab.

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.