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. On a Mac, use Control+Page Down or Control+Page Up; on many MacBook keyboards, add Fn and use the Down or Up Arrow in place of Page Down or Page Up.
The Excel shortcuts for moving between sheets
These shortcuts change the active worksheet in the current workbook. They do not open another workbook, move the selected cell, or alter the order of the tabs. The direction is based on the sheet tabs as they appear along the bottom of the workbook: next moves to the tab on the right, and previous moves to the tab on the left.
- Next worksheet: Ctrl+Page Down on Windows; Control+Page Down on Mac.
- Previous worksheet: Ctrl+Page Up on Windows; Control+Page Up on Mac.
For example, if a workbook has tabs named January, February, and March in that order, Ctrl+Page Down while January is active selects February. Press it again to select March. Ctrl+Page Up from March returns to February. The shortcuts are handy whether the tabs have month names, department names, or generic labels such as Sheet1 and Sheet2.
How sheet switching works
Excel treats each worksheet as a separate tab inside the same workbook. The keyboard commands move the active-sheet selection through the visible tabs in their current order. A sheet’s active cell is generally remembered when you leave it, so returning to a sheet usually takes you back to the cell you were using there rather than forcing you to start at A1.
Movement follows the tab order, not the order in which you last visited sheets. If you jump from a summary sheet to a detail sheet by clicking a tab, pressing the next-sheet shortcut moves to the tab immediately to its right from that detail sheet. It does not return to the summary simply because that was the previous sheet you viewed.
The commands also do not normally cycle around the ends. At the last visible sheet, pressing the next-sheet shortcut does not take you back to the first; at the first, pressing the previous-sheet shortcut does not take you to the last. Hidden worksheets are not part of the normal visible-tab sequence. If a sheet is hidden, use the workbook’s Unhide option or another route to make it visible before navigating to it with these shortcuts.
Using the shortcuts in a workbook
First, make sure the workbook window is active and that Excel has keyboard focus. Select any cell on the worksheet, then press the appropriate key combination. You do not need to click the sheet tabs first. A practical sequence is:
- Click a cell in the workbook if another window or a dialog currently has focus.
- Press Ctrl+Page Down to move right through the visible sheets, or Ctrl+Page Up to move left.
- Repeat the shortcut until the desired tab is active, then continue working in the selected sheet.
These commands are especially useful when a workbook has many tabs or when the tabs you need are outside the part of the tab bar currently visible. They can also reduce repetitive mouse movement during a review: for instance, an analyst can check the same cell or area across several monthly worksheets by switching tabs, while keeping track of which month is active.
Remember that the key combinations include the Control key. Pressing Page Up or Page Down alone scrolls the worksheet vertically; it does not switch tabs. Likewise, Ctrl+Up Arrow and Ctrl+Down Arrow move through regions of worksheet data and are different commands from Ctrl+Page Up and Ctrl+Page Down.
Other ways to choose a worksheet
The shortcuts are fastest when you know the sheet’s approximate position. If you need a specific tab among many sheets, other navigation methods can be more direct:
- Click a visible tab. Select the worksheet name at the bottom of the Excel window. If the tab is not visible, the tab-navigation arrows can scroll the row of tabs without changing the active sheet.
- Use the sheet-list menu. Right-click the small sheet-navigation arrows near the lower-left corner of the window to display a list of sheets, then select the one you want. The exact menu presentation can vary with the Excel interface and workbook.
- Use Go To for a cell, not a sheet name. Ctrl+G opens Go To in desktop Excel, but it is intended to navigate to a cell reference or named range. It is not a general command for typing a worksheet name and switching to it.
- Search or organize the tabs. Give sheets meaningful names and use a consistent order, such as placing a summary first and dated detail sheets afterward. This makes both keyboard movement and tab selection easier.
There is no need to change a setting to enable Ctrl+Page Up or Ctrl+Page Down in desktop Excel. If you regularly jump to a distant worksheet, a visible index or contents sheet with links can be a clearer solution than pressing the next-sheet shortcut repeatedly.
Mac keyboard differences
In Excel for Mac, the worksheet-navigation commands use the Control key rather than Command: Control+Page Down moves forward, and Control+Page Up moves backward. This is one reason not to substitute the familiar Mac Command key just because many other Mac shortcuts use Command. The key combination is specific to moving through worksheet tabs.
Some full-size keyboards have dedicated Page Up and Page Down keys. Many MacBook keyboards do not. On those keyboards, Fn+Down Arrow produces Page Down and Fn+Up Arrow produces Page Up, so the corresponding combinations are commonly Fn+Control+Down Arrow and Fn+Control+Up Arrow. The precise key labels and behavior can depend on the keyboard model and macOS keyboard settings. If an external keyboard provides Page Up and Page Down, use those keys with Control.
If the combination is intercepted by a keyboard utility or does not work as expected, use the worksheet tabs as a fallback and check whether the Mac keyboard has a dedicated function-key setting. Excel for Mac has its own shortcut documentation and can differ from Windows in other commands, so avoid assuming that every Windows Control-key shortcut has a direct Mac equivalent.
Excel for the web and browser behavior
Excel for the web runs inside a browser, where the browser may reserve key combinations for switching browser tabs or other browser actions. As a result, desktop instructions for Ctrl+Page Up and Ctrl+Page Down may not behave consistently in every browser, operating system, or focus state. If the shortcut changes the browser tab instead of the worksheet, that is a browser conflict rather than evidence that the workbook has no other sheets.
In the web version, clicking the worksheet tab is a reliable alternative. You can also use the sheet navigation controls at the bottom of the workbook to reveal tabs that are off-screen. For keyboard-only work, consult Microsoft’s current Excel for the web shortcut list for the browser and operating system you are using; web shortcuts can differ and may require an access-key sequence. If sheet switching is central to a task and the browser keeps intercepting the keys, opening the workbook in the desktop Excel app may provide more predictable desktop shortcut behavior.
Common problems and fixes
When a sheet shortcut seems not to work, check the context before assuming the keys are wrong. Excel can only apply the command when it has focus, and certain modes or interface elements can change what a keypress does. These checks solve many routine issues:
- Excel is not the active window. Click the workbook, then try the shortcut again.
- You are editing a cell. If the insertion point is inside a cell or the formula bar, finish or cancel the edit with Enter or Esc before switching sheets.
- The wrong Page key was pressed. On a compact keyboard, use the documented Fn combination or the keyboard’s Page Up/Page Down mapping. Arrow keys by themselves are not equivalent.
- The workbook has only one visible sheet. A shortcut cannot reveal a hidden sheet or move to a sheet that does not exist. Check whether another sheet is hidden or whether you are in a different workbook window.
- The browser captured the shortcut. In Excel for the web, try clicking the sheet tab or consult the web shortcut list for the browser in use.
- A dialog or another control has focus. Close or exit the dialog, then return focus to the worksheet.
Also check the sheet order. If the shortcut works but takes you to an unexpected worksheet, the tabs may have been reordered. Dragging a tab changes its position, and the next/previous commands follow that new order. The commands do not sort sheets alphabetically or by date.
Choosing between keyboard and mouse navigation
Keyboard navigation is a good fit for a short, ordered sequence of sheets. It is quick for comparing adjacent periods, stepping through regional tabs, or reviewing a workbook from left to right. It is less efficient when the target is far away and the workbook has dozens of tabs, because the shortcut moves only one visible worksheet at a time.
For larger workbooks, organize tabs so that the normal route through them is meaningful. You might keep a dashboard and instructions near the beginning, followed by detail sheets in chronological order. Use clear names rather than relying on colors alone, and avoid creating unnecessary duplicate sheets. For occasional jumps, the sheet-list menu or a linked index can save time; for regular sequential review, Ctrl+Page Up and Ctrl+Page Down remain simple and dependable in desktop Excel.
Sheet navigation is separate from changing the active cell within a worksheet. After switching to a tab, you can use the usual navigation keys to move around that sheet. Keeping those two actions distinct helps avoid a common mix-up: Page Up and Page Down scroll through rows, while Ctrl+Page Up and Ctrl+Page Down change worksheets in desktop Excel.
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. In Excel for Mac, press Control+Page Down, using Fn with the Down Arrow if the keyboard has no Page Down key.
How do I go to the previous sheet in Excel?
Press Ctrl+Page Up on Windows or Control+Page Up on Mac. On a MacBook without a dedicated Page Up key, Fn+Control+Up Arrow may provide the required key combination.
Can I use Ctrl+Tab to switch Excel worksheets?
Ctrl+Tab is not the standard next-worksheet shortcut in desktop Excel. Use Ctrl+Page Down to move to the next sheet and Ctrl+Page Up to move to the previous sheet. Browser behavior may differ in Excel for the web.
Why does Ctrl+Page Down switch browser tabs instead of Excel sheets?
When Excel is open in a browser, the browser can reserve that key combination. Click the worksheet tab instead, check the Excel for the web shortcut list for your browser, or open the workbook in desktop Excel.
Does the shortcut show hidden worksheets?
No. The next- and previous-sheet shortcuts navigate among visible worksheet tabs; they do not unhide sheets. Use Excel’s Unhide option to make a hidden worksheet visible first.
Can I change the shortcut for switching sheets?
Excel does not provide a standard setting in its options to remap these built-in worksheet-navigation shortcuts. You can use the tabs, the sheet list, or a linked index as alternatives when the default keys are inconvenient.
Related
- Excel Row Height Shortcut: Set or AutoFit Rows
- Excel Keyboard Shortcut to Select a Column: Full Guide
- Excel Shortcut to Insert a Copied Row Without Replacing Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Real Estate Expense Tracker Excel Spreadsheet GuideYes. You can make a real estate expense tracker in Excel by recording each expense as one row,…
- Compare Two Files in Word: Step-by-Step GuideTo compare two files in Microsoft Word, open Word and choose Review > Compare > Compare on Windows,…
- Excel Name Manager Spill Range: Create and Use OneTo name a spill range in Excel for Microsoft 365, open Formulas > Name Manager > New, give…
- Excel RANK.AVG vs RANK.EQ: Which Should You Use?Excel’s RANK.AVG gives tied values the average of the rank positions they occupy; RANK.EQ gives every tied value…
- Excel Page Break View Without Page Numbers: What to DoIn Excel for Microsoft 365 on Windows, you cannot hide the large “Page 1,” “Page 2,” and similar…
- How to Add Audio to PowerPoint SlidesTo add an audio file in PowerPoint for Microsoft 365 on Windows, select the slide, choose Insert >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.