Excel Keyboard Shortcuts to Switch Between Worksheet Tabs

How-to basics · Updated November 19, 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 order of the visible sheet tabs; it does not move the active cell to another part of the current worksheet.

The shortcuts and what they do

Use the Page Down and Page Up keys with Ctrl while a worksheet is active. Depending on the keyboard, those keys may be labelled PgDn and PgUp. The direction is relative to the tab order: Ctrl+Page Down advances to the tab on the right, and Ctrl+Page Up goes to the tab on the left. At the end of the tab row, the shortcut wraps around to the other end of the available sheets.

  • Next sheet: Ctrl+Page Down
  • Previous sheet: Ctrl+Page Up

For example, if a workbook has tabs named January, February, and March in that order, Ctrl+Page Down from January activates February. Press it again to reach March. Ctrl+Page Up from March returns to February. The active cell’s address is generally retained as you change sheets, although each sheet has its own selection and may show a different cell.

How sheet navigation works

A workbook can contain several worksheets, each with a tab along the bottom of the Excel window. The active tab identifies the sheet you are currently viewing. Ctrl+Page Up and Ctrl+Page Down change which sheet is active, while leaving the workbook open and keeping the current sheet data intact. They are useful when you need to compare periods, departments, or versions laid out on separate tabs.

The sequence follows the order of the tabs, not their names or the order of dates or numbers. If you drag a tab to a new position, the keyboard shortcut follows that new position. Hidden worksheets are not part of the normal visible sequence, so the shortcut skips them. If a sheet seems to be missing, it may be hidden rather than deleted.

Using the shortcuts efficiently

To move through a workbook, hold Ctrl and tap Page Down or Page Up as many times as needed. You do not have to click a sheet tab first if the worksheet grid is active. This can make keyboard navigation much quicker in a workbook with a long run of similarly structured sheets, such as one tab per month or location.

If you are currently typing into a cell or editing a formula in the formula bar, finish the edit with Enter or cancel it with Esc before navigating. Otherwise, Excel may treat your keystrokes as part of the edit instead of as a navigation command. This is especially relevant when a formula is being entered and you intend to move to a different sheet to select a range.

One practical routine is to keep your hands on the keyboard: use Ctrl+Page Down to inspect the next sheet, Ctrl+Page Up to return, and use the arrow keys or Ctrl+Home to move around within a sheet. Ctrl+Home takes you toward the start of the current worksheet; it does not switch tabs.

Mac and Excel for the web

In Excel for Mac, the sheet-navigation commands are also Control+Page Down and Control+Page Up on keyboards with Page Down and Page Up keys. On a MacBook keyboard without dedicated page keys, Fn+Control+Down Arrow commonly sends Page Down, and Fn+Control+Up Arrow sends Page Up. Keyboard layouts and external keyboards differ, so if that combination is unavailable, click the sheet tab or consult Excel’s shortcut help for the active setup.

In Excel for the web, the browser can affect keyboard shortcuts. Ctrl+Page Down is also used by some browsers to move between browser tabs, so the result may depend on the browser and its shortcut handling. Clicking the desired worksheet tab is a reliable alternative. If you use the web version regularly, check Excel’s keyboard-shortcut help in the app and try the command with the workbook focused rather than the browser’s tab strip.

Choosing a sheet from a long workbook

The two-key shortcuts are best when the sheet you want is only a few tabs away. For a workbook with dozens of tabs, repeatedly pressing Ctrl+Page Down can be slower and makes it easy to overshoot. In that case, use the sheet navigation controls at the lower-left of the Excel window or click a visible tab directly.

In the Windows desktop app, right-clicking the small sheet-navigation arrows near the bottom-left opens a list of sheet names that you can choose from. This is different from right-clicking an individual sheet tab, which opens commands for that tab. The list is handy when tabs are crowded or partly out of view; it is also a useful way to confirm the sheet’s name before activating it.

You can reorder tabs by dragging them, but consider whether that order will make sense to other people who use the workbook. A consistent arrangement—such as an Instructions tab first, then monthly tabs in calendar order, followed by a Summary tab—makes both mouse and keyboard navigation more predictable.

When the shortcut seems not to work

If Ctrl+Page Up or Ctrl+Page Down does nothing, first check what currently has focus. A text box, dialog, cell edit, or browser control may be receiving the keystrokes. Press Esc to leave a dialog or cancel an edit when appropriate, then click a worksheet cell and try again. On a laptop, check whether Page Up and Page Down require the Fn key.

If you cannot see any sheet tabs, the tab bar may be turned off or squeezed out of view. In Windows desktop Excel, check File > Options > Advanced > Display options for this workbook and make sure Show sheet tabs is selected. If only some sheets are missing, right-click a visible sheet tab and choose Unhide when that option is available. A workbook’s structure protection can restrict sheet changes, although it is distinct from simply moving between tabs.

Also check whether you are trying to switch worksheets or switch open workbooks. Ctrl+Page Up and Ctrl+Page Down are for moving between sheets in the active workbook. If another workbook window is covering Excel, activate the workbook you want first. A final possibility is that the target sheet is hidden; normal tab-to-tab navigation will not activate a hidden sheet.

Similar shortcuts that do something different

Some Excel shortcuts sound similar but affect a different kind of navigation. Knowing the distinction helps avoid accidental changes:

  • Tab moves the active cell to the next cell in the row in many worksheet situations; it does not switch to the next worksheet.
  • Alt+Page Down scrolls the view horizontally across the current worksheet; it does not activate the next sheet.
  • Ctrl+Page Up and Ctrl+Page Down change the active sheet.
  • Ctrl+Shift+Page Up or Ctrl+Shift+Page Down can extend a sheet selection to include adjacent sheets in desktop Excel. Use these carefully: multiple selected tabs are grouped, and edits made while sheets are grouped may affect corresponding cells on all selected sheets.

If several tabs become selected, look for the word “Group” in the Excel title area or check whether multiple tabs are highlighted. Click a single sheet tab to ungroup them before editing. This is an important distinction: the regular Ctrl+Page navigation is intended to change the active sheet, while the Ctrl+Shift combinations select sheets together.

Keyboard shortcuts or mouse navigation?

Neither method is always better. Keyboard shortcuts are efficient for moving one or two tabs at a time and keep your workflow on the keyboard. Clicking a tab is more direct when the destination is visible and clearly named. The sheet-navigation list is more practical when there are many tabs, names are long, or the target is far away.

For a workbook used repeatedly, improve navigation at the workbook level as well as relying on shortcuts. Give tabs meaningful names, keep related sheets in a sensible order, and consider a clearly labelled summary or index sheet with links where appropriate. These changes do not alter what Ctrl+Page Up and Ctrl+Page Down do, but they reduce the number of steps needed to find the right destination.

Frequently Asked Questions

What is the shortcut to go to the next sheet in Excel?
Press Ctrl+Page Down in Excel for Microsoft 365 on Windows. On a Mac, use Control+Page Down, or the corresponding Fn-plus-arrow combination if your keyboard has no dedicated Page Down key.

How do I go to the previous worksheet?
Press Ctrl+Page Up on Windows. On Mac, use Control+Page Up. The command moves one tab left in the workbook’s visible sheet order.

Does the Tab key move between Excel sheets?
No. Tab normally advances the active cell to another cell in the current sheet. Use Ctrl+Page Down or Ctrl+Page Up to change worksheets.

Can I jump straight to a sheet instead of cycling through tabs?
Yes. Click its visible tab, or in the Windows desktop app right-click the sheet-navigation arrows at the bottom-left and choose a sheet from the list.

Why can’t I reach a worksheet with the shortcut?
The sheet may be hidden, the worksheet grid may not have focus, or your keyboard may require Fn for Page Up or Page Down. Hidden sheets are skipped during ordinary tab navigation; unhide the sheet if you need to use it.

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.