Switch Excel Sheet Shortcut: Windows, Mac, and Tips

In Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next worksheet and Ctrl+Page Up to move to the previous one. On a Mac, use Control+Page Down and Control+Page Up; on a compact keyboard, you may need to hold Fn to produce Page Down or Page Up.

The Excel worksheet-switching shortcuts

The shortcuts move through the worksheet tabs in their displayed order, from left to right for the next sheet and right to left for the previous sheet. They work within the current workbook, so you can move between its visible sheets without clicking the tabs at the bottom of the Excel window.

Next worksheet, Windows: Ctrl+Page Down
Previous worksheet, Windows: Ctrl+Page Up
Next worksheet, Mac: Control+Page Down
Previous worksheet, Mac: Control+Page Up

For example, if a workbook has tabs named January, February, and March in that order, Ctrl+Page Down while January is active moves to February. Press it again to move to March. Ctrl+Page Up from March returns to February. At the end of the visible tab sequence, the shortcut does not wrap around to the first sheet; use the opposite shortcut or select a tab directly.

These keys change the active worksheet, not the selected cell within the worksheet. Excel generally remembers the active cell and view for each sheet, so returning to a sheet often restores the place where you last worked. If a worksheet has a very different layout or scroll position, that remembered view can make the jump feel less predictable, but the shortcut is still changing sheets.

How to use the shortcut in a workbook

First make sure Excel has focus. Click a cell or press Enter or Esc if you are editing a cell, then use the appropriate key combination. This matters because while the insertion cursor is inside a cell or formula bar, keystrokes may be interpreted as part of the edit rather than as worksheet navigation.

Open the workbook and identify the active sheet tab.
Press Ctrl+Page Down to move one visible sheet to the right, or Ctrl+Page Up to move one visible sheet to the left.
Repeat the shortcut to continue moving through the tabs.

You do not need to select a cell before switching. The shortcut also works when a chart sheet is part of the tab sequence, although the destination may not be a regular grid of cells. If you have just opened a workbook, try the shortcut once and check the highlighted tab to confirm which sheet became active.

For a workbook with a small number of tabs, one or two key presses are usually quicker than aiming for a tab with the mouse. For a workbook with many sheets, repeated presses can be less efficient; the sheet-navigation menu or a direct tab click is often a better way to jump a long distance.

Using the keys on Mac and Excel for the web

Excel for Mac uses Control with Page Up or Page Down for worksheet navigation. Some Mac keyboards have dedicated Page Up and Page Down keys. On many compact Mac keyboards, Fn+Up Arrow produces Page Up and Fn+Down Arrow produces Page Down, so the combinations become Control+Fn+Up Arrow for the previous sheet and Control+Fn+Down Arrow for the next sheet. Keyboard layouts and hardware can vary, so use the key marked Page Up or Page Down if your keyboard provides one.

On Windows laptops, Page Up and Page Down may share keys with the arrow keys or another function. A laptop may require its Fn key as well, but the exact combination depends on the keyboard design and Fn-lock setting. Look at the key legends or the computer maker’s keyboard guidance rather than assuming every laptop uses the same Fn combination.

In Excel for the web, Ctrl+Page Down and Ctrl+Page Up can also move between worksheets, but browser and keyboard behavior can affect shortcuts. If a key combination changes the browser view, is intercepted, or does nothing, select the sheet tab with the mouse instead. The tabs remain available along the bottom of the workbook, and using them is a reliable fallback across browsers and devices.

Moving among many worksheet tabs

The keyboard shortcut moves one sheet at a time; it does not open a list of sheet names. If a workbook contains dozens of tabs and you need a sheet far away, use Excel’s sheet-navigation controls. At the lower-left of the worksheet area, the small navigation arrows scroll the tab strip when the tabs do not all fit on screen. Scrolling those tabs is not the same as activating a different sheet.

In desktop Excel for Windows, right-click the sheet-navigation arrows at the lower left to open the Activate dialog, which lists sheets in the workbook. Choose the sheet name and confirm to go directly to it. This is useful when tabs are crowded, when names are similar, or when you do not know how many Ctrl+Page Down presses would reach the destination. If the arrows are difficult to see, widen the Excel window or adjust the divider between the tab strip and horizontal scroll bar.

Another option is to click the desired tab if it is visible. You can also reorganize a workbook by moving related sheets next to one another, which makes both the keyboard shortcut and mouse navigation more practical. When renaming tabs, clear names such as Summary, Inputs, and Quarterly Data are easier to locate than generic names such as Sheet1 and Sheet2.

Hidden worksheets are not part of the normal visible tab sequence, so Ctrl+Page Up and Ctrl+Page Down do not reveal them. If a sheet you expect to reach is missing, check whether it has been hidden. In desktop Excel, a visible tab can be right-clicked and the Unhide command used when an eligible hidden sheet is available; workbook structure protection or other restrictions may prevent changing sheet visibility.

Shortcuts that are easy to confuse

Ctrl+Page Up and Ctrl+Page Down are specifically for moving between worksheets. Similar-looking shortcuts have different jobs, so using the wrong one can appear to do nothing when your goal is to switch tabs.

Ctrl+Tab switches between open workbook windows in desktop Excel for Windows; it does not move to the next worksheet in the current workbook. In a web browser, Ctrl+Tab commonly changes browser tabs.
Alt+Page Up and Alt+Page Down move the worksheet view horizontally. They can scroll across columns, but they do not activate the next or previous sheet.
Shift+F11 inserts a new worksheet in desktop Excel. It is a sheet-creation shortcut, not a navigation shortcut.
Clicking a worksheet tab activates that specific sheet directly, rather than moving one tab at a time.

A practical way to remember the correct pair is to associate Page Up and Page Down with moving through the sheet-tab sequence: Page Down goes to the next sheet, and Page Up goes back. The Ctrl key is part of the desktop Excel shortcut. If you are trying to change workbooks rather than worksheets, use the workbook-window controls or the appropriate window-switching shortcut for your system.

Common problems and what to check

If Ctrl+Page Down or Ctrl+Page Up appears not to work, start with focus and the keyboard itself. Excel may still be in cell-editing mode, a dialog may be open, or another application may have focus. Press Enter or Esc to finish editing, click the worksheet grid, and try again. Also confirm that the key labeled Page Up or Page Down is being sent by the keyboard; on a laptop, its Fn layer may be required.

The active sheet does not change: Check that Excel has focus and that you are not editing a cell or working in a dialog.
The shortcut scrolls a browser or another window: This is more likely in Excel for the web. Use the visible sheet tab, or check whether the browser has captured the key.
The destination sheet is missing: It may be hidden, or you may be at the first or last visible tab. The shortcuts do not wrap from one end to the other.
The wrong sheet becomes active: The shortcut moves one tab at a time, including any visible chart sheets. Check the tab order and press the shortcut again if needed.
The key combination is awkward: Use the sheet tabs or the Activate dialog in desktop Excel for Windows.

Workbook protection can also affect what you are allowed to do. Protecting a workbook’s structure restricts actions such as adding, deleting, moving, hiding, or renaming sheets. It does not turn the worksheet-switching shortcut into a different command, but restrictions can explain why related tab-management actions are unavailable.

Choosing between the keyboard and the tabs

Use Ctrl+Page Up or Ctrl+Page Down when you want to move a short distance through sheets in their existing order. It is especially helpful while comparing adjacent periods, such as April and May, or checking consecutive stages in a process. Because it moves just one tab per press, the shortcut keeps your hands on the keyboard and makes adjacent-sheet comparisons quick.

Use a direct tab click when the destination is visible, and use the Activate dialog in desktop Windows Excel when it is far away or the tab strip is crowded. If you often jump to the same distant sheet, placing it near the sheets you use most can help. Another option is to keep a clearly named index or summary sheet with links to important locations, though those links require setup and are distinct from the built-in switching shortcut.

There is no single best navigation method for every workbook. A short workbook with three tabs is easy to traverse with the keyboard; a large workbook with many specialized tabs is often easier to navigate by name. Hidden sheets require a visibility change rather than repeated shortcut presses. Choosing the method that matches the workbook’s size and layout saves time and reduces accidental navigation.

Frequently Asked Questions

What is the shortcut to switch sheets in Excel?
On Windows, press Ctrl+Page Down for the next worksheet and Ctrl+Page Up for the previous worksheet. On Mac, use Control+Page Down and Control+Page Up, adding Fn if your keyboard needs it to produce the Page Up or Page Down key.

How do I switch to the next Excel sheet using only the keyboard?
Make sure Excel is not editing a cell, then press Ctrl+Page Down on Windows. Press it again to advance one more visible sheet. On Mac, use Control+Page Down.

Does Ctrl+Page Down wrap to the first sheet?
No. When you reach the last visible sheet, the shortcut does not cycle around to the first one. Use Ctrl+Page Up to move back or click the destination tab.

Can I jump straight to a specific Excel sheet?
Click its tab if visible. In desktop Excel for Windows, right-click the sheet-navigation arrows at the lower left and choose the sheet in the Activate dialog. Ctrl+Page Up and Ctrl+Page Down only move one sheet at a time.

Why is the sheet-switching shortcut not working?
Excel may not have keyboard focus, you may still be editing a cell, or your laptop may require Fn to send Page Up or Page Down. In Excel for the web, the browser can also intercept a shortcut; selecting the worksheet tab is a dependable alternative.

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.