Excel Shortcut to Move Between Tabs: Windows and Mac

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. These shortcuts change the active sheet in the current workbook; they do not switch between separate Excel workbooks.

The Excel shortcut for moving between worksheet tabs

Excel’s standard keyboard shortcuts for moving through worksheet tabs are:

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

For example, if a workbook has tabs named January, February, and March in that order, Ctrl+Page Down from January opens February. Press it again to open March. From March, Ctrl+Page Up returns to February. The shortcuts follow the order of the tabs, not the order in which you last visited them.

“Tabs” in this question usually means worksheet tabs along the bottom of the Excel window. A workbook can contain many worksheets, each with its own grid, while the shortcut moves among those sheets without closing or opening anything.

What the shortcut changes—and what it leaves alone

Ctrl+Page Up and Ctrl+Page Down change which worksheet is active. They do not move the selected cell one column or row, scroll through a long worksheet, or switch to another workbook. If you are on cell D12 in one sheet and use the shortcut, Excel activates a neighboring sheet. Each sheet generally retains its own active-cell position, so returning to a sheet often brings you back to the cell you were using there.

The direction is based on the visible tab sequence. If you drag a tab to a new position, the shortcut follows its new position. It also works when sheets have different names or contain different kinds of data. For instance, you can use it to move from a Summary sheet to a Data sheet, even if one contains charts and the other contains a table.

At the first or last sheet, the shortcut does not normally wrap around to the opposite end of the tab row. If you are on the rightmost sheet and press Ctrl+Page Down, do not expect Excel to jump to the first sheet. Use the reverse shortcut or choose a sheet directly instead.

How to use the shortcut step by step

Click a cell in the workbook so Excel is active, or use Esc to leave an editing state if you are typing in a cell.
Press Ctrl+Page Down to move one tab to the right, or Ctrl+Page Up to move one tab to the left.
Repeat the shortcut to continue through the sheets, checking the active tab name as you go.

On a full-size Windows keyboard, Page Up and Page Down are usually separate keys. On some compact keyboards, the keys are available through an Fn layer, so the physical combination may be Fn plus the key labeled Page Up or Page Down, together with Ctrl. The precise key labeling depends on the keyboard model; the important Excel command is Ctrl+Page Up or Ctrl+Page Down.

If Excel is in cell-editing mode, keyboard input may go into the cell rather than trigger navigation. Press Enter to accept the edit, or Esc to cancel it, then try the sheet shortcut again. Likewise, if a dialog box is open, Excel may interpret keys in the dialog rather than move between sheets.

Using the shortcuts on a Mac

Excel for Mac also uses Control+Page Down for the next sheet and Control+Page Up for the previous sheet on keyboards that provide Page Up and Page Down keys. On a MacBook or another compact keyboard without dedicated page keys, the equivalent may require the Fn key with the Up or Down arrow: try Control+Fn+Down Arrow for the next sheet and Control+Fn+Up Arrow for the previous sheet.

Keyboard layouts and function-key settings differ, so the exact physical combination can depend on the Mac and keyboard. If the combination changes the page position in a sheet rather than the active worksheet, check whether the Fn key is needed to produce Page Down or Page Up on that keyboard. You can also use the sheet tabs directly, which works regardless of the key layout.

In Excel for the web, keyboard handling can depend on the browser and operating system. A browser may claim a key combination before Excel receives it. If the shortcut switches browser tabs or does nothing, use the worksheet tabs at the bottom of the workbook, or open the sheet-navigation list described below. The desktop Windows shortcut should not be assumed to behave identically in every browser.

Move directly to a sheet when it is not nearby

The keyboard shortcut is convenient when the destination is only a few tabs away. For a workbook with many sheets, repeatedly pressing Page Up or Page Down can be slower than selecting the destination from a list.

Click a visible sheet tab to activate that worksheet directly.
Use the sheet-navigation arrows at the lower-left of the Excel window to scroll the row of tabs when some tabs are out of view. These arrows scroll the tab strip; they do not themselves activate each sheet.
Right-click the sheet-navigation arrows to open a list of visible worksheets, then choose a sheet from the list. This is useful when the target is far away or its tab is hidden off the edge of the window.
Use the Name Box to go to a cell address once you are on the correct sheet, but remember that it is not a general sheet-switching list.

Scrolling the tab strip and changing sheets are easy to confuse. If the tab names move but the worksheet grid does not change, you have scrolled the tabs without activating another sheet. Click the desired tab, select it from the navigation list, or use the keyboard shortcut to change the active sheet.

Worksheet tabs are not workbook windows

Excel uses “workbook” for the file and “worksheet” for an individual sheet inside that file. Ctrl+Page Up and Ctrl+Page Down navigate worksheets in the active workbook. They are not the shortcuts for choosing between two open Excel files.

If you have multiple workbooks open, use Excel’s window controls or the View tab to change which workbook window is active. On Windows, Ctrl+Tab can cycle through open workbook windows in Excel, although application and window arrangements can affect what you see. The key distinction is practical: use Ctrl+Page Up or Down for neighboring sheets within a file; use window-switching controls for separate files.

Similarly, Ctrl+Tab is not a substitute for moving one sheet left or right. It may change the active workbook window rather than the active worksheet, which can make it seem as though Excel jumped somewhere unexpected. Look at the workbook name and the selected sheet tab to confirm which level of navigation you need.

Common problems and quick fixes

The shortcut changes something in the sheet: Make sure you are not editing a cell or working in a dialog. Press Enter or Esc to exit cell editing, then try again.
Nothing happens at the end of the tab row: The shortcut moves to an adjacent sheet; it is not a wraparound command. Reverse direction or choose a tab from the list.
You cannot see the destination tab: It may be outside the visible part of the tab strip. Use the navigation arrows to scroll the strip, or right-click those arrows to see visible sheets in a list.
A sheet is missing from the list: The sheet may be hidden. Hidden sheets are not available as ordinary visible tabs; unhide the sheet if you have permission and need to navigate to it.
Several tabs appear selected: The workbook may have grouped worksheets. When multiple sheets are selected together, edits can affect more than one sheet. Click a single sheet tab to make it the only active sheet before continuing with normal work.
A Mac key combination behaves differently: Check whether your keyboard needs Fn to send Page Up or Page Down, and whether Excel is active rather than another app or the browser.

Workbook structure protection can restrict actions such as inserting, deleting, moving, or renaming sheets. It is different from ordinary sheet navigation. If a navigation or sheet-management action is unavailable, check whether the workbook is protected and whether you have permission to change its structure.

Choosing the quickest navigation method

For two or three nearby sheets, the keyboard shortcuts are usually the quickest option because your hands can stay on the keyboard. For a long workbook where the destination is known by name, selecting it from the sheet-navigation list is more direct. If you only need to inspect a neighboring sheet once, clicking its visible tab may be simplest.

Consider these practical factors when choosing:

Distance: use the shortcut for a small number of adjacent tabs and a list for a distant destination.
Visibility: if the target tab is visible, clicking it is straightforward; if it is offscreen, scroll or open the list.
Keyboard access: shortcuts suit keyboard-first work, while the tab row may be easier on devices with unusual key layouts.
Confidence about the destination: the tab list makes it easier to choose by sheet name instead of counting positions.

For example, suppose a workbook contains 20 monthly and reporting sheets, and you are on May while needing the annual Summary. Pressing Page Up or Page Down repeatedly requires tracking the order and distance. Opening the sheet list and selecting Summary reduces the chance of stopping on the wrong tab. Once you are working with nearby sheets, the shortcut can again be the faster choice.

Frequently Asked Questions

What is the shortcut to move to the next sheet in Excel?

On Windows, press Ctrl+Page Down to activate the next worksheet to the right. On a Mac keyboard with page keys, use Control+Page Down. A compact Mac keyboard may require Fn with Control and the Down Arrow.

How do I move to the previous tab in Excel?

Press Ctrl+Page Up on Windows to activate the worksheet immediately to the left. On Mac, use Control+Page Up; add Fn with the Up Arrow if the keyboard does not have a dedicated Page Up key.

Can I move between Excel tabs with the mouse?

Yes. Click a visible worksheet tab to activate it. If the tab is offscreen, scroll the tab strip with the lower-left navigation arrows, or right-click those arrows and choose a visible sheet from the list.

Why does Ctrl+Page Down switch browser tabs instead?

In Excel for the web, the browser may intercept the shortcut. Use the worksheet tabs or the sheet-navigation list instead. In the Windows desktop app, Ctrl+Page Down is the standard shortcut for moving to the next worksheet.

Does Ctrl+Page Down switch to the next Excel file?

No. It moves to the next worksheet in the active workbook. To change between separate workbook files, use Excel’s window controls or a workbook-window shortcut such as Ctrl+Tab where supported.

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.