Excel Sheet Jump Shortcut Keys for Fast Navigation

In Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next worksheet tab and Ctrl+Page Up to move to the previous one. These are the main Excel sheet-jump shortcut keys; if you mean jumping to a cell or range within a sheet, use Ctrl+G instead.

How sheet-jump keys work

A workbook can contain multiple worksheets, shown as tabs along the bottom of the Excel window. Ctrl+Page Down and Ctrl+Page Up change which worksheet is active while leaving each sheet’s cell contents and scroll position intact. The active sheet is the one you can currently edit, and its tab is highlighted.

The direction is relative to the tab order: Page Down moves one tab to the right, and Page Up moves one tab to the left. The shortcuts do not search for a sheet by name, jump to a particular position, or move the selected cell to the edge of a table. They are most useful when you want to cycle through a workbook’s sheets without reaching for the mouse.

For example, if the tabs are “Summary,” “January,” “February,” and “March,” and “January” is active, Ctrl+Page Down selects “February.” Pressing it again selects “March.” Ctrl+Page Up from “March” returns to “February.” If you are already at the first or last available sheet, pressing the shortcut does not wrap around to the other end of the tab row.

Switching between worksheets on Windows

Click a cell in the worksheet grid, then use the shortcut. You can hold Ctrl and tap Page Up or Page Down repeatedly to move through several tabs. The keys work with the active workbook, so if you have multiple Excel workbooks open, first make sure the one you want is active.

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

On a full-size keyboard, Page Up and Page Down are usually grouped with the navigation keys. On a laptop or compact keyboard, they may share a key with an arrow or another function. Look for “PgUp” or “PgDn” printed on the key; the manufacturer’s Fn key may be needed to access that function. The exact Fn combination depends on the keyboard, so check its labeling or documentation rather than assuming the same combination applies to every laptop.

These shortcuts change sheets in the order shown by the tabs, not in alphabetical order or by date. If a workbook’s sheets are arranged as Summary, Forecast, Actuals, and Notes, the shortcut follows that sequence. To change the sequence, drag a sheet tab to a new position, or use the sheet-tab context menu to move or copy a sheet.

Jumping within a worksheet is different

“Jump” can also mean moving around a large worksheet. Those actions use different shortcuts from switching tabs. If the wrong shortcut is used, Excel may move the active cell when you meant to change sheets, or switch sheets when you meant to reach a distant cell.

Ctrl+Home: move to the beginning of the worksheet, normally cell A1.
Ctrl+End: move to the last cell Excel considers used in the sheet. This may be farther down or across than the visible data if formatting or past entries extend the used area.
Ctrl+Arrow key: move to the edge of a contiguous data region in the direction pressed. For example, from a filled cell in a column, Ctrl+Down moves toward the bottom edge of that uninterrupted block.
Ctrl+G: open the Go To dialog, where you can enter a cell reference such as D250 or a defined range name.

To move to cell D250 on the current sheet, press Ctrl+G, type D250, and press Enter. To go to a cell on another sheet, enter a reference in the form March!D250, using the actual sheet name. If the sheet name includes spaces, enclose it in single quotation marks, as in 'Monthly Sales'!D250. This selects a location; it does not make the destination worksheet the next tab in sequence.

Ctrl+Arrow has another common limitation: it moves to the edge of a continuous block of data, not necessarily to the last nonblank cell in an entire column. Blank cells can stop the movement, and a full block of filled cells can make the destination seem unexpected. Use Go To when you know the exact destination.

Reaching a named sheet in a large workbook

Ctrl+Page Up and Ctrl+Page Down are convenient when the destination is only a few tabs away. They become less efficient in a workbook with dozens or hundreds of sheets, because you have to cycle through each intervening tab. For a distant sheet, use Excel’s sheet-navigation controls or search for a specific destination.

In desktop Excel for Windows, the small navigation arrows at the bottom-left of the workbook scroll the sheet-tab strip. They do not, by themselves, select the sheet. To display a list of sheet names, right-click those navigation arrows; Excel opens a list from which you can choose a worksheet. This is useful when the desired tab is hidden off-screen by a long row of tabs. If the sheet is hidden rather than merely out of view, it will not appear as a normal selectable tab; a workbook editor may need to unhide it.

For a known cell address, Ctrl+G is often faster than locating a tab and then scrolling through its grid. You can also use the Name Box, the small box to the left of the formula bar that normally displays the active cell reference. Type a cell reference or defined name there and press Enter. A sheet-qualified reference can take you to a cell on another sheet, provided the reference is entered correctly.

Another option is to create hyperlinks on a contents or index sheet. A hyperlink can point to a cell on another worksheet, making a workbook with many sections easier to navigate for other people. This is a workbook design choice rather than a keyboard shortcut, but it can save repeated tab-cycling in reports or planning files.

Mac and Excel for the web

In Excel for Mac, the sheet-switching shortcuts are also Control+Page Down and Control+Page Up on keyboards that provide Page Down and Page Up keys. On a compact Mac keyboard, those navigation keys may require an Fn or Globe-key combination; the precise key mapping varies by model and keyboard settings. If the expected shortcut does not work, check whether the key is sending Page Up or Page Down, and use the worksheet tabs as a fallback.

Do not substitute Command for Control automatically. Many familiar Mac shortcuts use Command, but the sheet-navigation command is commonly mapped to Control with the page keys. Keyboard layouts, remote-desktop software, and macOS settings can affect which key combination reaches Excel.

Excel for the web runs inside a browser, so some key combinations can be affected by the browser or operating system. If Ctrl+Page Up or Ctrl+Page Down changes browser tabs instead of worksheet tabs, select the worksheet using its tab or use the navigation options available in the workbook. The web app’s available shortcuts and behavior can vary with browser and keyboard. The desktop Excel steps above apply specifically to Microsoft 365 for Windows.

Common problems and quick checks

If Ctrl+Page Up or Ctrl+Page Down does not seem to switch sheets, check these likely causes before concluding that the shortcut is unavailable:

The grid does not have focus. Click a cell in the worksheet and try again. A text box, formula bar, dialog, or browser interface may be receiving the keystrokes instead.
The keyboard requires an Fn key. On some laptops, Page Up and Page Down are secondary functions. Try the labeled key combination for your keyboard.
You are using the wrong direction. Page Down moves right through the tab order; Page Up moves left.
The destination tab is hidden from view. The tab may be outside the visible strip because many sheets are open. Scroll the tab strip or open its sheet list rather than repeatedly pressing the shortcut.
The sheet is hidden. A hidden worksheet is different from a tab that is merely off-screen. It may need to be unhidden before you can select it normally.
You expected the shortcut to wrap around. At the end of the tab sequence, Excel does not cycle to the first sheet automatically.

Also distinguish worksheet tabs from workbook windows. Ctrl+Page Up and Ctrl+Page Down move between sheets in the active workbook; they are not the general command for switching between separate Excel files. If multiple workbook windows are open, use the Windows task switcher or Excel’s window controls to change workbooks.

A practical navigation workflow

Combining a few shortcuts is usually quicker than relying on one key for every kind of movement. A simple workflow helps avoid confusing sheet navigation with cell navigation:

Choose the right sheet. Use Ctrl+Page Down or Ctrl+Page Up when the target is close in tab order. For a faraway tab, use the sheet list or click its visible tab.
Go to the target location. Use Ctrl+G and enter a cell address, or use Ctrl+Arrow to move through a continuous block of data.
Confirm the selection. Check the active sheet tab and the Name Box before typing or pasting. This is especially helpful in a workbook where multiple sheets have similar layouts.
Return to the previous sheet if needed. Press the opposite Page shortcut once, or use a hyperlink or index sheet if the workbook has one.

For instance, suppose a workbook has one tab per month and you need to review cell F18 on April’s sheet. If April is two tabs to the right of the current sheet, press Ctrl+Page Down twice. Then press Ctrl+G, type F18, and press Enter. If the monthly sheets are far apart in the tab order, choose April from the sheet list first, then use Go To. This separates the two tasks—selecting a worksheet and selecting a cell—so it is easier to verify where you are.

Frequently Asked Questions

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

How do I go back to the previous sheet?
Press Ctrl+Page Up on Windows. On a Mac, use Control+Page Up when the keyboard provides that key, or the appropriate Fn combination on a compact keyboard.

Can I jump directly to a sheet by typing its name?
The sheet-switching shortcuts move one tab at a time; they do not accept a sheet name. Use the sheet-navigation list to select a distant tab, or enter a sheet-qualified cell reference in Ctrl+G to go directly to a location on that sheet.

How do I jump to a specific cell in Excel?
Press Ctrl+G, enter the cell address such as B75, and press Enter. To reach a cell on another sheet, include the sheet name, for example April!B75; use single quotation marks around a sheet name containing spaces.

Why does Ctrl+Page Down change my browser tab?
In Excel for the web, the browser may intercept the shortcut. Select the worksheet tab directly or use the workbook’s available sheet-navigation controls. In desktop Excel for Windows, click a worksheet cell and try Ctrl+Page Down again.

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.