Excel Shortcut Keys for Switching Between Worksheets

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 switch the active sheet; they do not move, copy, or rearrange a worksheet.

The worksheet navigation shortcuts

Excel follows the order of the visible sheet tabs from left to right. If a workbook has tabs named Summary, January, February, and March in that order, then from Summary, Ctrl+Page Down selects January. Press it again for February. From February, Ctrl+Page Up returns to January.

On most Windows keyboards, Page Up and Page Down are separate keys, often labeled PgUp and PgDn. Hold Ctrl while pressing the appropriate key. You can keep pressing the shortcut to travel through the workbook one visible worksheet at a time. The active tab changes, but the worksheet contents and tab order do not.

Ctrl+Page Down: activate the next visible worksheet to the right.
Ctrl+Page Up: activate the next visible worksheet to the left.

At the first or last visible sheet, the shortcut does not jump around to the opposite end of the tab bar. If you need to go from the final sheet back to the first, use the opposite direction repeatedly, select a sheet from the tab list, or click its tab directly.

How the shortcut works

The shortcut changes which worksheet is active, much like clicking a different tab. It does not scroll through rows or columns, select cells on another sheet, or open a new workbook. The selected sheet is the one Excel displays and acts on when you type, enter a formula, or use many ribbon commands.

Navigation is based on tab order, not on the names or contents of sheets. A sheet called 2025 may be followed by one called Overview if that is how the tabs are arranged. Excel does not interpret the names as dates or choose a sheet based on a value in a cell. To change the order, drag a sheet tab to a new position; that changes which sheet the next-sheet shortcut reaches.

Only visible worksheets take part in ordinary tab-by-tab navigation. A hidden worksheet is not selected as you press these keys. If a sheet you expect to reach is missing, check whether it has been hidden, rather than assuming the keyboard shortcut skipped it accidentally.

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

In Excel for Mac, the corresponding worksheet-navigation shortcuts are also Control+Page Down and Control+Page Up. The exact key combination can depend on the keyboard. A full-size keyboard may have dedicated Page Up and Page Down keys. On many MacBook keyboards, use Fn+Control+Down Arrow for Page Down and Fn+Control+Up Arrow for Page Up, because Fn with the arrow key supplies the page movement.

Mac keyboards and system settings differ, so if a combination triggers a different action, use the sheet tabs or check the shortcut list in Excel for Mac. Do not substitute Command automatically: the worksheet navigation shortcut uses Control, not the usual Command-based shortcuts for many Mac editing actions.

Excel for the web runs inside a browser, and browser or operating-system shortcuts can sometimes take precedence. If Ctrl+Page Up or Ctrl+Page Down changes a browser tab instead of the worksheet, click the desired sheet tab in the workbook. The sheet tabs remain the most direct fallback and avoid relying on a key combination that the browser has intercepted.

Moving through a workbook with many sheets

The two shortcuts are convenient when sheets are adjacent in the tab order. They are less efficient when a workbook has dozens of tabs and the destination is far away. For a longer jump, Excel’s sheet navigation controls provide a list you can use instead of pressing the shortcut repeatedly.

Go to the bottom-left of the Excel window, where the sheet-tab scrolling arrows are located.
Right-click those navigation arrows to open the Activate dialog, which lists the workbook’s worksheets.
Select the sheet name you want and confirm the selection.

This list is useful when tabs are off-screen because the workbook window is narrow, or when sheet names are similar. It also helps distinguish a sheet that is merely outside the visible tab area from one that may be hidden. If the target sheet is hidden, it will not be available as an ordinary visible tab to select through normal navigation.

You can also make frequent destinations easier to reach by arranging related tabs together. For example, place a dashboard and its supporting monthly sheets next to one another, then use the shortcut to move among them. Reordering tabs affects the workbook’s organization, so consider whether other users rely on the current order before changing it.

Switching sheets is different from moving or copying them

The wording “move to another sheet” can mean either changing the active sheet or relocating a worksheet. The Ctrl+Page shortcuts do only the first: they take you to another tab in the same workbook. They do not transfer a sheet to another workbook or change its position.

To relocate or duplicate a worksheet, right-click its sheet tab and choose Move or Copy. In the dialog, choose the destination workbook and the position where the sheet should appear. To duplicate rather than relocate it, select Create a copy before confirming. If the aim is only to change the tab order within the same workbook, drag the tab instead.

Moving cells or data is a separate task again. Select the cells and use cut and paste, or copy and paste, as appropriate. A sheet-navigation shortcut will not carry cell contents to another worksheet. Being clear about whether you want to switch views, reorder a tab, copy a worksheet, or transfer cell data helps avoid accidental changes to a workbook.

Related shortcuts and navigation options

Some familiar shortcuts sound as though they might change sheets, but they serve other purposes. In Excel for Windows, Alt+Tab switches between open applications, while Ctrl+Tab is used to move between open workbook windows in desktop Excel. Neither is the standard command for moving to the next worksheet within one workbook.

Clicking a tab is often the simplest alternative. If the tab is visible, select its name with the mouse. If it is not visible, use the sheet navigation controls at the lower-left, or widen the Excel window and adjust the horizontal space available for the tabs. Scrolling the tab strip changes which tabs you can see; it does not itself change the active worksheet.

For keyboard-oriented work, a useful pattern is to use Ctrl+Page Down or Ctrl+Page Up for nearby sheets, and the Activate dialog for a distant destination. This combines quick sequential movement with a direct choice when the workbook has many tabs.

Why the shortcut may not work

If the keys do not switch sheets, first check the keyboard and the window that has focus. A laptop may require Fn to generate Page Up or Page Down. A browser may capture the keys when Excel is open on the web. A dialog box or another application may also be active, so Excel may not receive the shortcut.

Confirm the active window. Click a cell in the workbook, then try the shortcut again.
Check the key labels. On compact keyboards, test the documented Fn combination for Page Up or Page Down.
Try the other direction. If one shortcut works, the issue may be a key or keyboard mapping rather than worksheet navigation.
Check visibility. Hidden sheets do not appear as normal stops in the visible tab sequence.
Use a tab or the Activate dialog. These provide a practical way to reach the sheet while you investigate the keyboard behavior.

Another common misunderstanding is expecting the shortcut to switch to a particular named sheet. It only moves to the adjacent visible tab. For a specific destination that is several tabs away, use the sheet list or click the tab rather than expecting Excel to search for a sheet name with Ctrl+Page Down.

A simple workflow for related sheets

Suppose a workbook contains an Overview sheet followed by one worksheet for each month. While reviewing monthly data, keep the tab order chronological. From Overview, press Ctrl+Page Down to open January, then press it again for February. Use Ctrl+Page Up to return to the previous month or back to Overview.

If you need to compare January and March, the shortcut can move between them, but it does not display two sheets side by side. For a quick comparison, you can navigate to each sheet and review the relevant cells, or use Excel’s window-view features when simultaneous views are needed. The worksheet shortcut remains useful for changing the active sheet, but it is not a comparison tool by itself.

For workbooks shared with colleagues, descriptive and consistently ordered sheet names make sequential navigation easier to understand. Avoid relying on tab color alone to identify a destination: the shortcut follows the tab order regardless of color. If users frequently jump to a dashboard or instructions sheet, keeping it at a predictable end of the tab sequence can make the workbook simpler to navigate.

Frequently Asked Questions

What is the shortcut to go to the next sheet in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+Page Down. It selects the next visible worksheet tab to the right.

How do I go back to the previous sheet?
Press Ctrl+Page Up on Windows. In Excel for Mac, use Control with Page Up; on many MacBook keyboards, Fn+Control+Up Arrow provides that Page Up action.

Does Ctrl+Page Down move a worksheet to a different workbook?
No. It changes the active worksheet within the current workbook. To move or copy a worksheet, right-click its tab and choose Move or Copy.

Can I jump straight to a sheet by name with this shortcut?
No. Ctrl+Page Up and Ctrl+Page Down move one visible tab at a time. To choose a distant sheet, right-click the sheet navigation arrows at the bottom-left and select it in the Activate dialog.

Why does the shortcut change browser tabs instead?
When using Excel for the web, the browser may capture the key combination. Select the worksheet tab directly in Excel, or use the browser and Excel shortcut options available on your device.

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.