Excel Shortcut Between Sheets: Windows, Mac, and Web

In Excel for Microsoft 365 on Windows, press Ctrl+Page Up to move to the previous sheet tab, or Ctrl+Page Down to move to the next one. The shortcut follows the tabs’ left-to-right order, so you can use it to move through a workbook without clicking each sheet.

Shortcut at a glance

The two shortcuts work within the active workbook and move one tab at a time. They do not change the value in a cell or move between open workbooks.

Previous sheet: Ctrl+Page Up
Next sheet: Ctrl+Page Down

For example, if the tabs are named January, February, and March in that order, Ctrl+Page Down while on January selects February. Press it again to select March. From March, Ctrl+Page Up returns to February. The names do not matter; Excel follows the tabs’ current order, not alphabetical order or the dates written in the names.

These shortcuts are useful when a workbook has many tabs, when you are entering information across several worksheets, or when you want to inspect a sequence of monthly or departmental sheets. They are also handy when the tab you need is partly obscured because the workbook contains more tabs than fit along the bottom of the window.

What the shortcut changes

Switching sheets changes which worksheet is active. It does not copy data, alter a formula, or shift the selected cell’s contents. Excel generally remembers the active cell on each sheet, so returning to a worksheet normally brings you back to the cell you were using there. That can make it easier to compare separate areas of a workbook without repeatedly finding your place.

The shortcut moves through the visible sheet tabs in sequence. If you reach the last visible tab and press Ctrl+Page Down again, Excel does not wrap around to the first tab; press Ctrl+Page Up to go back. Hidden worksheets are not available as ordinary visible tabs, so the shortcut is not a way to reveal or visit a hidden sheet. A hidden sheet must first be unhidden using Excel’s sheet controls.

Tab order can be changed by dragging a sheet tab left or right. As a result, the same shortcut can lead to a different sheet after someone rearranges the workbook. If the next sheet is unexpected, look at the tab order rather than assuming Excel is sorting sheets by name.

How to use it on Windows

Click a cell on the workbook you want to navigate, then use the appropriate key combination. On a full-size keyboard, Page Up and Page Down are usually separate keys. Hold Ctrl and tap Page Up or Page Down once for each sheet you want to move.

Activate the Excel workbook and select any cell on a sheet.
Press Ctrl+Page Down to go one tab to the right, or Ctrl+Page Up to go one tab to the left.
Repeat the shortcut to continue through the tabs.

There is no need to hold the shortcut down for a long time. Repeated taps make the destination easier to control, especially in a workbook with many tabs. If you use a laptop keyboard without dedicated Page Up and Page Down keys, those functions may be available through an Fn combination printed on the keyboard. The precise Fn combination depends on the laptop model and its keyboard settings.

Keep the focus in the workbook when you press the shortcut. If a text field, dialog box, or another application has focus, the keys may do something else or may not switch sheets. Press Esc to close an active cell edit or dialog when appropriate, then click a worksheet cell and try again.

Using the shortcut on Mac and Excel for the web

In Excel for Mac, the corresponding sheet-navigation shortcuts are also Control+Page Up and Control+Page Down. Mac keyboards may label the Control key as control or ctrl. Many MacBook keyboards do not have separate Page Up and Page Down keys; on those keyboards, Fn+Up Arrow commonly sends Page Up and Fn+Down Arrow sends Page Down. In that case, try Control+Fn+Up Arrow for the previous sheet and Control+Fn+Down Arrow for the next. Keyboard layouts and settings differ, so use the sheet tabs if those combinations are unavailable on your model.

Excel for the web supports sheet navigation by keyboard, but browser shortcuts can interfere. For example, some browsers use Ctrl+Page Up and Ctrl+Page Down to change browser tabs. Whether Excel receives the keystroke can depend on the browser and how the workbook is open. If the shortcut changes the browser tab instead of the worksheet, click the desired sheet tab in Excel or use the browser’s available Excel shortcut guidance rather than repeatedly pressing the keys.

The worksheet tabs remain a dependable option across Windows, Mac, and the web. On a touch device, tapping the tab is often simpler than using a hardware keyboard. Regardless of platform, check that the workbook itself is active before testing a keyboard shortcut.

Moving to a distant or hard-to-find sheet

The keyboard shortcut is best for nearby tabs. If a workbook has dozens of sheets and the destination is far away, clicking through one tab at a time can be slow. Excel provides other ways to reach a sheet directly:

Click the sheet tab. If the tab is visible, select it directly. This is the most straightforward option when you know the sheet’s name.
Use the sheet-tab navigation arrows. The small controls at the lower-left of the workbook scroll the tab display. Scrolling the display does not itself select a different worksheet; click the destination tab after it becomes visible.
Open the sheet list. In desktop Excel for Windows, right-click the sheet-tab navigation arrows at the lower left to open the Activate dialog, then select a listed sheet. This is useful when the tab is off-screen. The dialog lists sheets you can activate; it is not a search box for worksheet contents.
Reorder tabs when appropriate. Drag a frequently used sheet nearer to the front of the tab row. This changes the workbook’s tab order for other users too, so avoid rearranging a shared workbook without considering its existing organization.

Clicking a tab is also a useful fallback when a shortcut is intercepted or when you cannot remember which direction to move. If the workbook is protected or a sheet is hidden, navigation may be limited by the workbook’s settings; a keyboard shortcut does not override those restrictions.

When the shortcut does not work

Most problems come from the keyboard, the active window, or the sheet’s visibility rather than from a different shortcut. Check these likely causes before changing workbook settings:

The laptop uses an Fn layer. Find the key that produces Page Up or Page Down, then combine it with Ctrl. On some keyboards, Fn Lock changes how those keys behave.
Excel is not receiving the keystroke. A browser, remote desktop session, or other application may capture Ctrl+Page Up or Ctrl+Page Down. Click a cell in the workbook, or select the sheet with the mouse.
You are editing a cell. If the insertion point is inside a cell or the formula bar, finish or cancel the edit before trying to switch sheets.
The destination is hidden. Hidden sheets do not appear as ordinary tabs. Use Excel’s Unhide command, if permitted, before selecting that sheet.
You are at an end of the tab sequence. The shortcut does not cycle from the final visible sheet back to the first. Reverse direction to return through the tabs.

Also distinguish a sheet from a workbook. Ctrl+Page Up and Ctrl+Page Down move among tabs in the current workbook; they do not select another open Excel file. If you have several workbooks open, use the application’s window-switching controls or select the workbook window you want, then navigate its sheets.

Shortcut compared with clicking tabs

Neither method is universally better. The shortcut is efficient when you are moving one or a few sheets in a known direction. It keeps your hands on the keyboard and works especially well for adjacent tabs, such as moving from a weekly worksheet to the next week. Clicking is clearer when the destination is visible, when you need to choose among similarly placed tabs, or when keyboard combinations are being intercepted.

For a distant sheet, use the tab list or scroll the tab row rather than pressing the shortcut a large number of times. For a workbook used by several people, clear sheet names and a sensible tab order can make every navigation method easier. Names such as Q1 Sales and Q2 Sales communicate more than Sheet1 and Sheet2, and arranging related tabs together helps users predict what the next-sheet shortcut will select.

One common misconception is that the shortcut jumps to the next worksheet alphabetically. It does not. If the visible order is Summary, East, West, the next-sheet shortcut from East selects West even if another sheet has a name that would come earlier alphabetically. Another misconception is that pressing the shortcut changes the active cell to the same address on every sheet. Excel generally preserves each sheet’s own active-cell position instead.

Frequently Asked Questions

What is the Excel shortcut to go to the next sheet?
On Windows, press Ctrl+Page Down to move to the next visible sheet tab. In Excel for Mac, use Control+Page Down; a MacBook without a Page Down key may require Fn+Control+Down Arrow.

How do I go back to the previous sheet in Excel?
Press Ctrl+Page Up on Windows or Control+Page Up on Mac. The command moves one tab to the left in the current workbook.

Can I switch directly to a sheet by name with a shortcut?
Ctrl+Page Up and Ctrl+Page Down move one tab at a time; they do not open a name search. For a distant sheet, use the sheet-tab controls or, in desktop Excel for Windows, right-click the navigation arrows and choose the sheet in the Activate dialog.

Why does Ctrl+Page Down change my browser tab?
Some browsers assign that key combination to browser-tab navigation, which can prevent Excel for the web from receiving it. Select the worksheet tab with the mouse, or use Excel in a desktop app if you need reliable keyboard navigation.

Does the shortcut include hidden worksheets?
No. Hidden worksheets are not visible tabs to navigate to with this shortcut. If you have permission to view one, unhide it first using Excel’s sheet controls.

Does Excel wrap from the last sheet to the first?
No. At either end of the visible tab order, the shortcut does not loop around. Use the opposite direction or select a tab directly.

Quick takeaway

For ordinary sheet-to-sheet navigation in Excel for Microsoft 365 on Windows, remember Ctrl+Page Up for the previous tab and Ctrl+Page Down for the next. They follow the visible tab order in the current workbook. On Mac, use the corresponding Control+Page Up or Control+Page Down keys, accounting for the Fn layer if your keyboard lacks Page keys; in a browser, click the worksheet tab if the browser captures the shortcut.

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.