How to Select a Sheet in Excel With Keyboard Shortcuts

How-to basics · Updated November 20, 2026

To select the next worksheet in Excel for Microsoft 365 on Windows, press Ctrl+Page Down; to select the previous worksheet, press Ctrl+Page Up. These shortcuts make the adjacent sheet active without using the mouse. Open the workbook and make sure Excel, rather than a cell or another app, has keyboard focus before you begin.

Here, “select a sheet” means making one worksheet active so you can view or edit it. It does not mean selecting cells or grouping multiple worksheets. The steps below are for Excel on Windows; Mac and browser notes explain what to try if your keyboard behaves differently.

What You’ll Need

  • An open Excel workbook with at least two visible sheets. If there is only one visible sheet, there is no adjacent sheet to switch to.
  • A keyboard with Ctrl, Page Up, and Page Down keys. On some laptops, the page keys are secondary functions that require holding Fn.
  • Excel in focus. If you are typing in a cell, editing the formula bar, or using a dialog box, the shortcut may not switch sheets.

Step-by-Step

  1. Open the workbook and identify the sheet tabs. The tabs usually appear along the bottom of the Excel window. The active sheet has a highlighted tab, and its cells appear in the main worksheet area. You do not need to click a tab before using the shortcut, but checking the active tab helps you confirm the result.
  2. Move to the next sheet. Press and hold Ctrl, tap Page Down, and then release both keys. Excel makes the sheet immediately to the right of the current sheet active. For example, if the tabs are January, February, and March and January is active, Ctrl+Page Down makes February active.
  3. Move to the previous sheet. Press and hold Ctrl, tap Page Up, and release the keys. Excel makes the sheet immediately to the left of the active sheet current. From February in the example, Ctrl+Page Up returns to January.
  4. Repeat the shortcut to travel farther. Each press moves one sheet at a time. Press Ctrl+Page Down twice to move two positions to the right, or press Ctrl+Page Up twice to move two positions to the left. Watch the highlighted tab after each move if you are unsure of your position.
  5. Check where you are at the end of the tab sequence. The shortcut moves between adjacent sheets; it is not a direct jump to a named worksheet. If you reach the last visible sheet, pressing the next-sheet shortcut will not take you back to the first. Use Ctrl+Page Up to move back through the tabs, or use the sheet-tab navigation controls to find a distant sheet.
  6. Use the equivalent keys on a Mac. In Excel for Mac, use Control+Page Down for the next sheet and Control+Page Up for the previous sheet. Mac keyboards, especially compact MacBook keyboards, may not have dedicated Page Up and Page Down keys. Try holding Fn with Control and the corresponding arrow key to produce Page Up or Page Down. Keyboard layouts and Excel settings can differ, so check the active tab to confirm each move.
  7. For Excel for the web, check whether the browser is taking the shortcut. Keyboard shortcuts in a browser can differ from desktop Excel, and a browser may use a key combination to move between browser tabs. If the shortcut changes the browser tab instead of the worksheet, return to the workbook and use the visible sheet tabs, or consult Excel for the web’s shortcut help for your browser and keyboard. The Windows desktop steps above apply to the desktop app.

When the shortcut works, Excel changes the active worksheet, not the contents of the workbook. The current cell selection may still be visible on the newly active sheet, but you have not copied, moved, or deleted data by switching sheets.

Common Mistakes

  • Pressing Alt instead of Ctrl. The sheet-navigation shortcuts use Ctrl on Windows. Excel’s Alt key starts ribbon access keys and does not perform the same action.
  • Using the arrow keys instead of Page Up or Page Down. Ctrl+Left Arrow and Ctrl+Right Arrow move around the worksheet grid; they do not select the previous or next sheet.
  • Typing into a cell when you mean to change sheets. If a cell or formula bar is in edit mode, Excel may handle the keys as part of the text or formula. Press Esc to cancel the edit, or Enter to finish it, and then try the sheet shortcut.
  • Confusing a sheet with a cell range. The shortcut activates a worksheet. It does not select all the cells on that sheet, select the tab label for editing, or group worksheets together.
  • Expecting a hidden worksheet to appear in the sequence. Hidden sheets are not available as ordinary visible tabs to navigate to with these adjacent-sheet steps. Unhide the sheet first if you need to work on it.
  • Assuming the sequence wraps around. The shortcut moves to a neighboring sheet rather than cycling endlessly from the last tab to the first. If no further tab is available in that direction, use the opposite shortcut or locate the required tab another way.

Tips

  • Learn the direction once: Page Down goes to the next tab on the right; Page Up goes to the previous tab on the left. The key names describe page movement, but in this shortcut they move between sheets.
  • Use the shortcut repeatedly for nearby tabs. It is often quicker than aiming for narrow tabs with the mouse, especially in a workbook with a few visible worksheets.
  • Check the tab name before making changes. Similar sheet names, such as Forecast and Forecast 2, are easy to mix up. Confirm the highlighted tab before entering data or changing formatting.
  • Use the sheet-tab navigation controls for a long workbook. The small navigation arrows at the lower-left of the workbook can help reveal tabs that are outside the visible area. They move the tab display; they are not a direct jump to a named sheet. After finding the tab, activate it with the mouse if needed.
  • Keep the distinction between navigation and grouping in mind. A shortcut that changes the active tab normally leaves one sheet active. If you deliberately select multiple sheet tabs together, edits can affect all selected sheets. Look for multiple highlighted tabs and avoid grouped-sheet actions unless you intend them.
  • Use the on-screen keyboard if you lack page keys. In Windows, the On-Screen Keyboard can provide keys that are absent from a compact physical keyboard. Search Windows for On-Screen Keyboard, open it, and use its Ctrl and page keys with Excel active.

Troubleshooting

Nothing happens when you press the shortcut. First check that the workbook window is active and that at least two sheets are visible. If you are editing a cell, press Esc or Enter to leave edit mode, then try again. On a laptop, test whether Fn+Ctrl+Page Down or Fn+Ctrl+Page Up is required because the page keys share a key with another function.

The worksheet changes when you intended to move within the grid. Check that you pressed Ctrl with Page Up or Page Down, not with an arrow key. If you used a compact keyboard, make sure the key you pressed actually sends Page Up or Page Down; the arrow symbol or key label may require Fn.

The browser changes tabs, or another app responds. This can happen in Excel for the web if the browser claims the key combination, or if Excel is not the active window. Click back into the workbook and try again. If the browser still intercepts it, use the worksheet tabs or Excel for the web’s shortcut guidance for your browser.

You cannot reach the sheet you need. Look for a hidden worksheet or a tab that is off-screen. To unhide a sheet in desktop Excel for Windows, right-click a visible sheet tab, choose Unhide, select the sheet, and choose OK. If Unhide is unavailable, there may be no normally hidden sheet to show, or workbook settings may restrict access. If the tab is simply out of view, use the sheet-tab navigation arrows to scroll the tab strip.

The shortcut appears to affect more than one sheet. Check whether several sheet tabs are highlighted. Multiple highlighted tabs indicate grouped worksheets. Right-click a selected tab and choose Ungroup Sheets, or select a single sheet tab, before making changes that should affect only one worksheet.

Frequently Asked Questions

What is the keyboard shortcut for the next sheet in Excel?
On Windows, press Ctrl+Page Down. In Excel for Mac, use Control+Page Down, with Fn if your keyboard needs it to produce the Page Down key.

How do I go back to the previous sheet?
Press Ctrl+Page Up on Windows or Control+Page Up on Mac. Each press moves one tab to the left.

Can I jump directly to a sheet by typing its name?
These two shortcuts move one sheet at a time; they do not open a name list. For a distant worksheet, use the visible tabs or the tab-navigation controls to locate it. Excel’s Find command searches worksheet content, not a list of sheet names.

Does switching sheets change or erase my data?
No. The shortcut changes which worksheet is active. It does not delete, move, or overwrite data by itself. Changes only occur if you perform an editing action afterward.

Can I use these shortcuts to select several sheets at once?
Do not use the adjacent-sheet shortcut as a way to group sheets. Selecting multiple tabs is a separate action, commonly done by clicking tabs while holding Ctrl on Windows or Command on Mac. Grouped sheets can receive the same edits, so check that only the intended tabs are selected.

Why is my sheet missing when I cycle through tabs?
It may be hidden, or it may be outside the visible part of the tab strip. Unhide a hidden worksheet, or use the tab-navigation arrows to reveal tabs that do not fit on screen.

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.