Excel Shortcut to Move Between Sheets in a Workbook

How-to basics · Updated November 19, 2026

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. The shortcut changes the active sheet without changing the selected cell’s address or editing the workbook’s contents.

The Excel keyboard shortcuts

Use these keys while a workbook is open and Excel has focus:

  • Ctrl+Page Down: activate the worksheet immediately to the right of the current sheet tab.
  • Ctrl+Page Up: activate the worksheet immediately to the left of the current sheet tab.

These are relative navigation commands. Pressing the same shortcut repeatedly moves through the workbook one visible worksheet at a time. For example, if the active tab is January, Ctrl+Page Down moves to February when that tab is next to it; another press moves to the following tab. The command does not jump to the next worksheet alphabetically, nor does it search for a sheet by name.

Excel keeps the current cell reference when you switch sheets, where possible. If B12 is selected on one worksheet, switching to another does not mean Excel selects the next worksheet’s B12 as a new edit or copies anything. It simply makes another sheet active; the selection displayed on that sheet may reflect its own previous selection.

How sheet order affects navigation

The shortcuts follow the left-to-right order of the worksheet tabs, not the order in which you created the sheets or the order of their names. If a workbook has tabs named Summary, April, January, and Notes in that order, Ctrl+Page Down from Summary goes to April. Excel does not sort the tabs automatically.

Navigation reaches the end of the visible tab sequence and stops; it does not wrap from the last worksheet back to the first. Likewise, Ctrl+Page Up at the first visible worksheet does not take you to the last. To move in the opposite direction, press the other shortcut.

Hidden worksheets are not part of the sequence you can visit with these keys. If you expect to reach a particular sheet but cannot, check whether it is hidden. A normally hidden sheet can be made visible from the sheet-tab context menu by choosing Unhide, then selecting the sheet. Very hidden sheets, generally set through Visual Basic for Applications, require a different method to unhide.

Using the sheet tabs and navigation controls

The keyboard shortcuts are quickest when you need to move one or several tabs. For a particular sheet whose name you can see, clicking its tab is direct and avoids counting through intervening sheets. If the tab is off-screen because a workbook has many sheets, the small navigation arrows at the bottom-left of the workbook window scroll the tab strip; clicking those arrows alone does not activate a different worksheet.

To open a list of worksheets, right-click the sheet-navigation arrows at the bottom-left of the Excel window. Excel displays an Activate list of available visible sheets; select a name and confirm to go there. This is useful when there are many tabs or when the tab you need is far away. On a trackpad, use the equivalent secondary click if available.

These controls do different jobs:

  • Ctrl+Page Up or Ctrl+Page Down: changes the active worksheet by one tab.
  • Click a sheet tab: activates the visible sheet you click.
  • Click the tab-strip arrows: scrolls the row of tabs into view.
  • Right-click the tab-strip arrows: opens a list for choosing a visible sheet.

Excel for Mac and Excel for the web

On a Mac, Excel keyboard layouts vary, especially between full-size keyboards and laptops. A commonly used Mac alternative is Option+Right Arrow for the next worksheet and Option+Left Arrow for the previous one. Some Mac keyboards and Excel configurations also support Control+Page Down and Control+Page Up. If a shortcut does not work, use the sheet tabs or check the keyboard-shortcut guidance for the Excel version and keyboard you are using. A MacBook may require an Fn key to produce Page Up or Page Down because those keys are not printed as separate keys.

In Excel for the web, the sheet tabs at the bottom of the workbook are a dependable way to change sheets. Keyboard behavior can depend on the browser and its shortcuts: for example, browsers may use Ctrl+Page Up or Ctrl+Page Down to switch browser tabs. If the key combination changes the browser tab instead of the worksheet, click the workbook first or use the sheet tabs. Excel for the web and desktop Excel can also differ in which keyboard shortcuts are available, so do not assume every desktop combination behaves identically in a browser.

How to jump to a specific worksheet

Ctrl+Page Up and Ctrl+Page Down are designed for moving through neighboring sheets, not selecting a distant sheet by name. If the workbook contains a dozen tabs and you need the last one, pressing Ctrl+Page Down repeatedly works, but a sheet list or direct tab click is usually faster.

For a workbook you use often, a simple layout can make navigation easier. Keep related sheets together, give tabs clear names, and consider placing a contents or index sheet near the beginning. You can reorder a tab by dragging it left or right. Reordering changes the direction in which the keyboard shortcuts travel, but does not alter the values or formulas on the worksheet.

If you need a particular cell on another sheet as well as the sheet itself, use the sheet tab first, then navigate to the cell. For example, after activating the Forecast tab, press Ctrl+G to open Go To, enter a reference such as D25, and confirm. The sheet-switching shortcut alone does not accept a sheet name or cell address.

Common shortcut problems and fixes

If Ctrl+Page Up or Ctrl+Page Down appears to do nothing, check the context before assuming the workbook is broken. These troubleshooting steps resolve many cases:

  1. Return focus to the worksheet. Click a cell in the workbook and try again. If you are typing in a cell or editing the formula bar, finish the edit with Enter or cancel it with Esc first.
  2. Check the keyboard’s Page keys. Some compact keyboards require Fn together with another key to send Page Up or Page Down. The exact combination depends on the keyboard manufacturer.
  3. Confirm the active application. A browser or another program may capture the shortcut before Excel receives it. This is especially likely in Excel for the web.
  4. Look at the tab order and visibility. The next sheet may be hidden, or the workbook may already be at the first or last visible tab, where navigation stops.
  5. Try a mouse alternative. Click the destination tab, scroll the tab strip, or use the sheet list opened from the navigation arrows.

Worksheet protection is not the same as workbook-structure protection. Protecting cells on a sheet generally does not prevent switching between sheets. Workbook structure protection restricts actions such as adding, deleting, moving, hiding, or unhiding sheets, but it does not normally turn the sheet-navigation shortcut into a command for editing cells. If navigation itself is blocked or behaves unexpectedly, check which application window has focus and whether a browser or keyboard utility is intercepting the keys.

Related shortcuts and useful distinctions

Ctrl+Page Up and Ctrl+Page Down should not be confused with shortcuts for moving around a worksheet. The arrow keys move the active cell; Ctrl+Home moves to the beginning of a worksheet’s used navigation area, typically A1; and Ctrl+End moves to the last used cell. Those commands change position within the active sheet rather than selecting a neighboring sheet.

There is also a difference between moving to a sheet and selecting multiple sheet tabs. The basic Ctrl+Page shortcut activates one sheet at a time; it does not group sheets. Grouping can happen through separate selection actions on sheet tabs, and edits made while multiple sheets are grouped may affect corresponding cells on each selected sheet. If a workbook’s title bar or tabs indicate a group selection, use care and ungroup the sheets before making ordinary changes.

For everyday navigation, a practical pattern is to use the keyboard for nearby sheets and the tab list for distant ones. This avoids unnecessary repeated key presses while retaining a quick way to move back and forth between adjacent worksheets.

Frequently Asked Questions

What is the shortcut to go to the next sheet in Excel?
In Excel for Windows, press Ctrl+Page Down. It activates the next visible worksheet to the right of the current tab.

How do I go to the previous sheet in Excel?
Press Ctrl+Page Up in Excel for Windows. It activates the visible worksheet immediately to the left.

Does Ctrl+Page Down move to the next workbook?
No. It moves to the next worksheet in the current workbook. Ctrl+Tab is used to move between open workbooks in desktop Excel, though window-management behavior can vary by platform.

Can I make the shortcut wrap to the first sheet?
No. The standard shortcut stops at the first or last visible worksheet rather than cycling around. Use the sheet list or click a tab to jump to a different position.

Why does Ctrl+Page Down change my browser tab?
When using Excel in a browser, the browser may claim the key combination. Click inside the workbook and try again; if the browser still switches tabs, use the worksheet tabs at the bottom of the workbook.

Related

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.