Excel Tab Shortcut Keys: Move Between Worksheets

In Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next sheet tab and Ctrl+Page Up to move to the previous one. On a Mac, use Control+Page Down or Control+Page Up; on many Mac keyboards, add Fn because Page Down and Page Up share keys with the arrow keys.

The essential Excel sheet-tab shortcuts

These shortcuts move the active selection from one sheet in the current workbook to another. They do not move the selected cell within a worksheet, and they do not switch between separate workbook windows.

Next sheet: Ctrl+Page Down on Windows; Control+Page Down on Mac.
Previous sheet: Ctrl+Page Up on Windows; Control+Page Up on Mac.
On a MacBook keyboard without dedicated Page Up and Page Down keys: try Control+Fn+Down Arrow for the next sheet and Control+Fn+Up Arrow for the previous sheet.

For example, if the active tab is January, pressing Ctrl+Page Down takes you to the next sheet in the workbook’s tab order, such as February. Pressing Ctrl+Page Up returns to January. The shortcut follows the order of the tabs, not the names or dates written on them. If the tabs are arranged as Summary, January, March, February, the next-sheet shortcut follows that sequence.

What the shortcuts do—and what they do not do

An Excel workbook can contain multiple sheets, shown as tabs along the bottom of the window. The active sheet is the one currently displayed. Ctrl+Page Up and Ctrl+Page Down change which sheet is active while generally keeping the current cell address. If cell D8 is selected on one sheet, moving to another sheet usually selects that sheet’s corresponding cell location, if available. The shortcut does not copy data, change the tab order, or scroll through rows and columns.

At the first or last tab, the shortcut does not make a circular trip to the opposite end. For instance, pressing Ctrl+Page Up when the first sheet is active will not take you to the final sheet. You can instead click the desired tab, use the sheet-navigation controls near the lower-left corner of the Excel window, or reorder tabs to make frequent destinations easier to reach.

The term sheet can also include a chart sheet: a separate sheet that displays a chart rather than a cell grid. Navigation moves through the workbook’s sheet tabs, so a chart sheet may be part of the sequence. Hidden sheets, by contrast, do not appear as ordinary tabs to navigate to. A very hidden sheet also cannot be revealed through the standard Unhide dialog; that setting requires a different approach, such as changing its visibility in the Visual Basic Editor.

Move quickly through a workbook with many tabs

Repeatedly pressing Ctrl+Page Down or Ctrl+Page Up is useful when the destination is only a few tabs away. Hold the shortcut or press it multiple times to continue stepping through the tab order. For a workbook with dozens of sheets, however, it may be faster to use the tab-navigation controls at the bottom left of the workbook window. Those controls scroll the visible tab strip; they do not themselves change the active sheet. Click a tab once it is visible to activate it.

These controls are easy to confuse: scrolling the tab strip is not the same as moving the active sheet. If the active sheet stays the same while the tab names slide left or right, you have scrolled the strip. If the active tab changes and its worksheet appears, you have navigated to another sheet. The keyboard shortcuts perform the latter action.

Another practical approach is to keep related sheets adjacent. Right-click a tab and choose Move or Copy to open the dialog for changing its position or copying it. You can also drag a tab to a new position. Once the sheets are grouped in a logical order, the previous- and next-sheet shortcuts become more predictable. If your workbook relies on a set order, check that rearranging tabs does not confuse colleagues or disrupt instructions that refer to sheet positions.

Select multiple sheet tabs together

Excel also has shortcuts for selecting a group of neighboring sheets. On Windows, press Ctrl+Shift+Page Down to add the next sheet to the selection, or Ctrl+Shift+Page Up to add the previous sheet. These commands select sheets; they do not simply navigate to another tab. The selected tabs are grouped, and the active sheet remains the one from which you started.

Grouped sheets can be useful when you want to apply the same change in the same cell location on several worksheets. For example, if you select three monthly sheets and enter a heading in cell A1, Excel can place that entry in A1 on each selected sheet. That convenience makes grouping powerful, but it also creates a common risk: edits, formatting, and some other actions may affect every selected sheet. Check the tab highlights before editing, especially if a workbook contains sheets with different layouts.

To select a contiguous range with the mouse, click the first tab, hold Shift, and click the last tab. To select or deselect individual tabs, Ctrl-click them on Windows. On a Mac, use Command-click for individual tabs and Shift-click for a range. To return to working on a single sheet, click a tab that is not in the group, if one is available, or right-click a selected tab and choose Ungroup Sheets. Look for the grouped-sheet indication in the workbook title area as an extra cue before making a broad edit.

Create and rename sheets with the keyboard

When you need another worksheet, press Shift+F11 on Windows to insert one. Excel places the new sheet near the active sheet and makes it active. On some laptops, the function-row keys control hardware features by default, so you may need to hold Fn as well, or change the keyboard’s function-key setting. Excel for Mac also supports Shift+F11 on keyboards where the function key is available; the required Fn combination can depend on the Mac’s keyboard settings.

To rename a sheet in Excel for Windows, press Alt, then H, O, and R in sequence. These are ribbon KeyTips for Home > Format > Rename Sheet. Type the new name and press Enter. You can also double-click a sheet tab, type a name, and press Enter. Renaming is useful when a workbook has generic names such as Sheet1, but remember that a sheet name cannot contain certain characters, including a forward slash, a backslash, a question mark, an asterisk, a colon, or square brackets.

For occasional tab management, the right-click menu is often clearer than memorizing a shortcut. It offers actions such as Rename, Move or Copy, Tab Color, Hide, and Unhide, where those actions are available. Be cautious with Delete: deleting a sheet removes its contents, and Excel may ask you to confirm. Keyboard navigation is generally the safer choice when your only goal is to inspect another sheet.

Differences on Mac and Excel for the web

On Windows, the standard navigation keys are Ctrl+Page Up and Ctrl+Page Down. On a Mac, Excel uses Control rather than Command for these sheet-navigation shortcuts. That difference matters because Command is used for many familiar Mac commands, but Command+Page Up is not the usual way to move between Excel sheets. If the Mac keyboard has no dedicated Page keys, Fn combined with Control and the relevant arrow key may be needed.

Excel for the web runs inside a browser, so keyboard combinations can be affected by the browser, operating system, and Excel’s keyboard-shortcut settings. If Ctrl+Page Up or Ctrl+Page Down changes the browser tab instead of the sheet, use the sheet tabs or the navigation controls in the workbook. You can also check Excel for the web’s Help menu for its keyboard-shortcut options. Browser behavior and available shortcuts can vary, so do not assume that every desktop shortcut works the same way in a web session.

On either platform, make sure the workbook has focus. If you are actively editing a cell, a shortcut may not behave as expected because Excel is waiting for you to finish the cell entry. Press Enter to accept the edit or Esc to cancel it, then try the sheet-navigation shortcut again. If the workbook is protected or opened in a restricted mode, some editing and sheet-management actions may also be unavailable.

Common problems and practical fixes

The shortcut changes a browser tab: This can happen in Excel for the web because the browser may claim the key combination. Click a sheet tab or use the workbook’s sheet controls instead.
Nothing happens on a laptop: The keyboard may require Fn for Page Up or Page Down. Try the Fn combination or use the on-screen tabs.
The cell is being edited: Press Enter or Esc to leave edit mode, then navigate.
The destination is missing: It may be hidden, or the visible tab strip may be scrolled so the tab is out of view. Scroll the strip or use Home > Format > Hide & Unhide > Unhide Sheet to reveal a normally hidden sheet.
A change appears on several sheets: Check whether multiple tabs are grouped. Ungroup the sheets before making a single-sheet edit.
The shortcut moves through an unexpected sheet: The tab order may differ from the order you assumed. Inspect the tabs or rearrange them deliberately.

A useful distinction is that hiding a sheet is not the same as deleting it. A hidden sheet remains in the workbook but is not available as a visible tab for ordinary navigation. Unhiding it restores the tab. Deleting a sheet removes it, so do not use a delete command merely because you cannot find a tab.

A simple workflow for everyday use

For a workbook organized by month, region, department, or project, a reliable routine can make navigation faster without adding complexity:

Arrange related sheets in the order you naturally review them.
Use short, descriptive tab names so the visible tabs are easy to identify.
Press Ctrl+Page Down or Ctrl+Page Up on Windows to move one sheet at a time; use Control with Page Down or Page Up on Mac.
When changing several sheets, confirm that only the intended tabs are selected before typing or formatting.
If you cannot reach a sheet, check whether it is hidden before assuming it has been deleted.

For example, a sales workbook might have Overview, January, February, and March tabs. Starting on Overview, three presses of Ctrl+Page Down move through the next three tabs in that order. If February is hidden, it will not appear as an ordinary destination; unhide it first. If the tabs have been rearranged, the shortcut follows the new order. This simple sequence illustrates why tab names, visibility, and position all matter alongside the shortcut itself.

Frequently Asked Questions

What is the shortcut to switch tabs in Excel?
On Windows, press Ctrl+Page Down for the next sheet and Ctrl+Page Up for the previous sheet. On Mac, use Control+Page Down and Control+Page Up.

How do I switch sheets on a MacBook without Page Up or Page Down keys?
Try Control+Fn+Down Arrow to move to the next sheet and Control+Fn+Up Arrow to move to the previous one. Mac keyboard settings can affect the Fn behavior, so clicking a visible sheet tab is a straightforward alternative.

Can I jump directly to a particular Excel tab with a shortcut?
Excel does not have a universal single-key shortcut that opens a sheet by its name. Use the sheet tabs or navigation controls, or step through the tab order with Ctrl+Page Up and Ctrl+Page Down on Windows.

Why does Ctrl+Page Down switch browser tabs instead of Excel sheets?
In Excel for the web, the browser may intercept the shortcut. Use the workbook’s sheet tabs or navigation controls, or consult the shortcut options in Excel for the web.

How do I select multiple sheets using the keyboard?
On Windows, use Ctrl+Shift+Page Down or Ctrl+Shift+Page Up to extend the selection to an adjacent sheet. On a Mac, the equivalent Control-based combination may depend on the keyboard’s Page-key behavior. Check the selected tabs before editing, because grouped-sheet changes can affect all of them.

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.