Excel Tab Shortcut: Switch Between Worksheets on Windows

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. The shortcut changes the active worksheet in the current workbook; it does not switch between separate Excel files.

The shortcut and what it does

Excel uses the order of the visible worksheet tabs to determine what counts as next or previous. If a workbook has tabs named January, February, and March in that order, Ctrl+Page Down from January selects February, and another press selects March. Ctrl+Page Up moves back through the same sequence.

The shortcut selects a sheet rather than merely scrolling the row of tabs. That distinction matters when a workbook has more tabs than fit along the bottom of the window: scrolling the tab bar can reveal sheet names without changing the active sheet, while Ctrl+Page Up or Ctrl+Page Down changes which worksheet is active.

  • Next worksheet: Ctrl+Page Down.
  • Previous worksheet: Ctrl+Page Up.
  • Direction: follows the visible tabs from left to right or right to left.

The sequence does not normally wrap around. If you are on the last visible sheet and press Ctrl+Page Down, Excel does not jump automatically to the first sheet. Use Ctrl+Page Up to move back, or select a particular tab directly.

Using the shortcut on Windows

Click a cell in the workbook first if focus is somewhere outside the worksheet, such as in a ribbon control or an open dialog. Then hold Ctrl and press Page Down or Page Up. You can keep Ctrl held while tapping the page key repeatedly to move several sheets. The selected sheet becomes active immediately, so you can continue typing, entering formulas, or using other commands there.

On a full-size keyboard, the Page Up and Page Down keys are usually in the navigation-key area, separate from the arrow keys. Laptop keyboards may combine them with other functions or omit dedicated keys. Look for PgUp and PgDn labels, sometimes printed in a secondary color. Depending on the laptop, you may need to hold Fn as well as Ctrl—for example, Ctrl+Fn+PgDn. The exact Fn combination is a keyboard-layout detail, not a different Excel command.

If the shortcut appears to do nothing, test whether the page key works as intended in another context and check the laptop’s key labels or manual. Some keyboards require Fn-lock to be changed before the page functions behave as expected. You can also bypass the issue by clicking the desired worksheet tab or using the sheet navigation controls described below.

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

In Excel for Mac, the corresponding commands are generally Control+Page Down for the next sheet and Control+Page Up for the previous sheet. Use the Control key, not Command. On a Mac keyboard without dedicated Page Up and Page Down keys, those page functions are commonly produced with Fn+Up Arrow and Fn+Down Arrow. In that case, try Control+Fn+Down Arrow for the next worksheet and Control+Fn+Up Arrow for the previous one. Keyboard models and settings can affect how those keys are interpreted.

Excel for the web also supports worksheet navigation with Ctrl+Page Up and Ctrl+Page Down in many browser and keyboard configurations. Because it runs inside a browser, browser or operating-system shortcuts can sometimes take priority. If a key combination switches a browser tab or does not reach Excel, click inside the workbook and try again, or use the worksheet tabs with the mouse. The menu and keyboard options can also differ by platform, so do not assume that a Windows laptop’s Fn-key behavior applies to a Mac.

How worksheet order affects navigation

The shortcut follows the tabs’ current left-to-right arrangement, not alphabetical order, date order, or the order in which you most recently used the sheets. For example, suppose a workbook displays Summary, East, West, and Archive. Starting on East, Ctrl+Page Down selects West; it will not jump to Archive simply because Archive might be the next item in a separate data sequence.

To change the order, drag a worksheet tab to a new position. The shortcut then follows that revised order. This can be useful in a workbook organized as Overview, input sheets, calculations, and reports: arrange the tabs in the order people should review them, and the shortcut becomes a quick way to follow that sequence.

Only worksheets that are visible can be selected by cycling through the tabs. Hidden worksheets are not part of the visible tab sequence. If you need a hidden sheet, it must first be unhidden, assuming you have permission to do so. Also remember that moving to another sheet does not change the selected cell on the sheet you leave; when you return, Excel generally restores that sheet’s prior selection.

When clicking a tab or using the sheet navigator is better

The keyboard shortcut is most convenient when you need to move one or two tabs at a time. For a workbook with many sheets, repeatedly pressing Ctrl+Page Down can be slower than choosing the destination directly.

  • Click a visible tab when the destination name is already on screen and you want to select it directly.
  • Scroll the tab strip with the navigation arrows at the lower-left of the Excel window when the destination tab is hidden off-screen. Scrolling reveals tabs; click the desired tab to activate it.
  • Open the sheet list by right-clicking the small sheet-navigation arrows near the lower-left corner. In desktop Excel, this opens the Activate dialog, where you can choose a listed visible sheet rather than cycling through each one.

These options solve different problems. The arrows are for moving the visible tab strip, not for changing worksheets one at a time. The Activate dialog is helpful when the workbook has many visible sheets, while Ctrl+Page Up and Ctrl+Page Down are faster for nearby tabs.

Common shortcut problems and misconceptions

A frequent mix-up is using Ctrl+Tab. In Excel, Ctrl+Tab is associated with moving among open workbook windows, so it is not the standard command for stepping through worksheet tabs. The sheet-navigation keys are Ctrl+Page Up and Ctrl+Page Down. Similarly, Alt+Tab on Windows switches between open applications or windows at the operating-system level; it does not move through sheets in the current workbook.

Another common issue is that a laptop’s PgUp or PgDn key is shared with another function. Pressing Ctrl with the wrong key—or forgetting Fn when it is required—may produce no visible change or may trigger another action. Check the key legend and try the relevant Fn combination. If you use an external keyboard, its dedicated Page Up and Page Down keys may work without Fn.

Finally, make sure you are working in the workbook you intend to navigate. The shortcut acts on the active workbook window, not on every open workbook at once. If the wrong file is active, switch to the intended workbook first, then use the sheet shortcut. If an Excel dialog is open, close it or return focus to the worksheet before expecting the command to move between tabs.

Choosing the fastest navigation method

Use Ctrl+Page Up or Ctrl+Page Down when the next or previous sheet is the destination. Use a direct tab click when the desired name is visible, and use the Activate dialog when many tabs make the target hard to locate. If a workbook has an unusually large number of sheets, improving its organization can save more time than cycling through them: put frequently used sheets near the beginning, use clear names, and group related tabs in a logical sequence.

For instance, in a monthly reporting workbook, a useful order might be Dashboard, January, February, March, and Year Summary. Starting at January, two presses of Ctrl+Page Down take you to March. If you instead need Year Summary, a direct click or the Activate dialog is more efficient than moving through every intervening sheet. The shortcut is a navigation aid, not a search feature; it does not accept a sheet name or jump to a matching tab.

Frequently Asked Questions

What is the shortcut to switch between Excel sheets?

On Windows, press Ctrl+Page Down for the next worksheet and Ctrl+Page Up for the previous worksheet. The commands follow the visible tabs’ left-to-right order.

Does Ctrl+Tab switch between Excel tabs?

Not worksheet tabs. Ctrl+Tab is used for moving among open workbook windows in desktop Excel. Use Ctrl+Page Up or Ctrl+Page Down to move between worksheets within the active workbook.

How do I switch sheets on a MacBook without Page Up or Page Down keys?

Try Control+Fn+Down Arrow for the next sheet and Control+Fn+Up Arrow for the previous sheet, because Fn commonly supplies the Page Down and Page Up functions on compact Mac keyboards. If your keyboard or settings behave differently, click a tab or use the sheet-navigation controls.

Can I jump directly to a specific worksheet?

The Ctrl+Page shortcuts move one visible worksheet at a time; they do not jump to a named sheet. Click its tab if visible, or right-click the sheet-navigation arrows at the lower-left of desktop Excel and select the sheet in the Activate dialog.

Why is Ctrl+Page Down not working?

Check that Excel has focus, that you are in the workbook you want to navigate, and that the key is reaching Excel. On some laptops, you must hold Fn to produce Page Down. In Excel for the web, a browser shortcut may interfere; clicking in the workbook or selecting the tab directly can help.

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.