Excel Shortcut to Change Sheets in 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. On a Mac, use Control+Page Down and Control+Page Up; on some Mac keyboards, you may need to add Fn to produce Page Down or Page Up.

The Excel shortcut for changing sheets

These shortcuts change the active worksheet in the current workbook. They follow the order of the visible sheet tabs along the bottom of the Excel window. 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 activate March. Ctrl+Page Up moves back through the same order.

Next worksheet: Ctrl+Page Down on Windows; Control+Page Down on Mac.
Previous worksheet: Ctrl+Page Up on Windows; Control+Page Up on Mac.

On a Windows keyboard, the keys may be labeled PgDn and PgUp instead of Page Down and Page Up. The shortcut means holding Ctrl while pressing the relevant page key. It does not mean pressing the arrow keys, and it does not move the selected cell down or up a worksheet.

How sheet order affects navigation

The shortcut follows the tabs as they are currently arranged, not alphabetical order, date order, or the order in which the sheets were created. If someone drags March before February, the shortcut follows that new arrangement. This makes the command useful for workbooks organized as a sequence, such as months, departments, project stages, or weekly reports.

Navigation normally wraps around at the ends of the visible tab sequence. In a workbook with three visible worksheets, pressing Ctrl+Page Down while on the third sheet takes you to the first; Ctrl+Page Up from the first takes you to the third. If there is only one visible worksheet, the shortcut has nowhere else to go, so the active sheet appears unchanged.

Hidden worksheets are not part of the normal tab sequence. The shortcut moves among sheets that are visible as tabs; it does not reveal hidden sheets. To show a hidden worksheet in desktop Excel, right-click a visible sheet tab, choose Unhide, select the sheet, and confirm. If Unhide is unavailable, there may be no ordinarily hidden worksheet to show, or workbook settings may restrict the action.

What changes—and what stays the same

Changing sheets is different from moving around within a sheet. Arrow keys move the active cell, while Ctrl+Page Down and Ctrl+Page Up change which worksheet is active. The currently selected cell on the newly activated sheet is usually the cell that was active there the last time you visited it. For instance, if you last used cell D12 on February and then move to February from January, Excel will generally return to that selection.

The shortcut also does not switch to a different workbook. If several workbooks are open, the command acts on the workbook that is currently active. To change a sheet in another workbook, first activate that workbook, then use the sheet shortcut. This distinction matters when two files have similar-looking tabs or when Excel windows overlap.

In a large workbook, repeated presses can be faster than scrolling across a long row of tabs. They can also be used while editing a workflow: inspect a value on one sheet, move to the next sheet, and continue without reaching for the mouse. If the workbook is shared or carefully structured, take care not to confuse the active sheet with the sheet you intended to edit.

Using the sheet tabs and other navigation options

The keyboard shortcuts are not the only way to change worksheets. Clicking a visible tab is the most direct option when the destination is in view. For a workbook with many tabs, the small sheet-navigation controls near the lower-left corner can help scroll the tab strip so a distant tab becomes visible. Scrolling the strip does not itself activate a different worksheet; click the desired tab once it appears.

Right-clicking the sheet-navigation controls opens a list of sheets in many desktop versions of Excel. Choose an entry to activate that worksheet. This can be more convenient than pressing Page Down repeatedly when the destination is far away, although the list may require scrolling in a workbook with many sheets.

Use the keyboard shortcut when moving one sheet at a time in tab order.
Click a tab when its name is visible and you want to confirm the destination visually.
Use the navigation controls or their sheet list when tabs extend beyond the visible strip.
Use Find or other workbook search tools when you are looking for data rather than a particular worksheet.

Excel does not provide a universal sheet-name search box in the standard desktop interface that replaces all these methods. If the workbook has many sheets, descriptive tab names and a consistent order can make navigation substantially easier.

Windows, Mac, and Excel for the web

On Windows, use Ctrl with Page Up or Page Down. On Mac, use Control rather than Command for these sheet-navigation shortcuts. That difference is easy to miss because many other familiar Mac shortcuts use Command. If the Mac keyboard has dedicated Page Up and Page Down keys, use Control with those keys.

Some MacBook keyboards do not have separate Page Up and Page Down keys. On many models, Fn+Down Arrow acts as Page Down and Fn+Up Arrow acts as Page Up. In that case, try Control+Fn+Down Arrow for the next sheet and Control+Fn+Up Arrow for the previous sheet. Keyboard layouts and system settings can vary, so if the combination does not work, use the worksheet tabs or check the keyboard shortcut guidance for your Excel and macOS versions.

Excel for the web runs inside a browser, and browser shortcuts can compete with spreadsheet shortcuts. For example, a browser may use Ctrl+Page Down to move between browser tabs. The exact behavior can depend on the browser and current Excel web shortcut support. If the key combination changes the browser tab instead of the worksheet, click the worksheet tab in Excel or consult the in-app keyboard shortcuts list. The desktop Windows instructions above apply to Excel for Microsoft 365 on Windows, not necessarily every browser setup.

Common reasons the shortcut seems not to work

When a shortcut does not change sheets, first check that Excel has focus. If the browser, another program, or a dialog box is active, keystrokes may be handled elsewhere. Click a cell in the worksheet and try again. On a laptop, confirm that you are pressing the Page Up or Page Down function rather than an arrow key, and check whether Fn is needed to access that function.

Other common explanations include:

Only one visible worksheet: there is no other visible tab to activate.
The workbook is in a browser: the browser may intercept the key combination.
The wrong modifier key is being used: Mac sheet navigation uses Control, not the more common Command key.
The destination is hidden: hidden sheets are not reached by cycling through visible tabs.
A dialog or cell edit is active: finish or cancel the current action, then try the shortcut again.

Workbook structure protection is often mistaken for a navigation restriction. Protecting workbook structure can limit actions such as inserting, deleting, renaming, hiding, or moving worksheets, depending on the protection settings. It does not ordinarily prevent switching between worksheets that are already visible. If the shortcut fails, check focus, keyboard layout, and the number of visible sheets before assuming the workbook is protected.

Grouped worksheets: a reason to take extra care

Excel can group worksheets so that the same edits are applied to multiple selected sheets. Grouping is useful for entering the same label or applying the same formatting to matching cells across several tabs, but it raises the risk of changing more sheets than intended. When sheets are grouped, Excel indicates the selection in the sheet tabs and may show Group in the title bar.

Before editing after moving between sheets, look at the tabs and confirm whether a group is still selected. To stop grouping, right-click a selected sheet tab and choose Ungroup Sheets, or select a sheet tab that is not part of the group. Do not rely on the navigation shortcut to undo a grouped selection: check the visible state of the tabs before typing, pasting, or formatting. This is particularly important in templates where several worksheets share the same layout.

Choosing the best method for your workbook

The keyboard shortcut is most helpful when the destination is adjacent in the tab order and you already know where you are. It is less helpful when sheets have vague names, when the target is far away, or when the workbook contains dozens of tabs. In those cases, use the sheet list, click the named tab, or improve the workbook’s organization if you have permission.

For a recurring sequence, arrange tabs in the order people naturally follow and use clear names such as Q1, Q2, Q3, and Q4 or Setup, Data, and Summary. Avoid relying only on tab color to identify a destination; colors can be hard to distinguish and do not replace readable names. In a workbook maintained by a team, ask before moving or renaming tabs, because other people may depend on the existing order or references.

There is no need to change Excel’s settings to use Ctrl+Page Up or Ctrl+Page Down in the standard Windows desktop version. If the shortcuts are inconvenient because of a keyboard layout, the mouse-based tab methods remain available. Excel options and add-ins can alter some keyboard behavior, so in a managed work environment an administrator may also affect what keys are available.

Frequently Asked Questions

What is the shortcut to go to the next sheet in Excel?
On Windows, press Ctrl+Page Down. On Mac, press Control+Page Down. The command activates the next visible worksheet in tab order.

How do I go back to the previous sheet?
Press Ctrl+Page Up on Windows or Control+Page Up on Mac. If the Mac keyboard lacks Page Up, Fn+Up Arrow may provide that key, so try Control+Fn+Up Arrow.

Can I use Ctrl+Tab to change Excel sheets?
Ctrl+Tab is not the standard shortcut for moving between worksheet tabs. Use Ctrl+Page Down or Ctrl+Page Up on Windows. In a browser, Ctrl+Tab may switch browser tabs instead.

Why does Ctrl+Page Down switch my browser tab?
In Excel for the web, the browser can intercept keyboard combinations that desktop Excel uses for worksheet navigation. Click the worksheet tab, or check Excel’s in-app shortcut guidance for your browser and setup.

Does the shortcut work with hidden sheets?
No. It cycles through visible worksheet tabs and does not unhide worksheets. Use the sheet-tab context menu and choose Unhide when the worksheet is hidden and you are allowed to show it.

Can I change the shortcut to a different key?
Excel’s standard worksheet-navigation shortcuts are built in rather than changed through a normal ribbon setting. You can use the tab controls instead; custom remapping would depend on external keyboard software or other configuration and may behave differently across computers.

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.