Yes. In Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next worksheet, or Ctrl+Page Up to move to the previous one. These shortcuts change the active sheet; they do not edit, rename, or rearrange worksheets.
The Direct Answer: Switch to the Next or Previous Sheet
Excel treats worksheets as a sequence of tabs along the bottom of the workbook. The keyboard shortcut follows that sequence: Ctrl+Page Down activates the next visible worksheet to the right, and Ctrl+Page Up activates the previous visible worksheet to the left. The active sheet is the one whose tab is highlighted and whose cells appear in the main grid.
For example, if a workbook has tabs named January, February, and March in that order, and January is active, pressing Ctrl+Page Down displays February. Pressing it again displays March. From March, Ctrl+Page Up returns to February. The keys work while you are in a worksheet; you do not need to click a tab first.
The shortcut changes which worksheet you are viewing, not the workbook itself. It does not move the selected cell to another address, switch to a different open Excel file, or create a new sheet. Think of it as a keyboard way to click a different worksheet tab.
Which Keys to Press on Windows
Hold down Ctrl, then tap the appropriate Page key. You do not need to press the keys at precisely the same instant: keep Ctrl held while you press Page Down or Page Up. On a full-size keyboard, these keys are usually in the navigation cluster to the right of the main typing area.
Ctrl+Page Down: activate the next worksheet.Ctrl+Page Up: activate the previous worksheet.
Some laptops and compact keyboards do not have separate Page Up and Page Down keys. Their functions may be assigned to another key combination, often involving Fn and an arrow key. Check the keyboard labels or the computer maker’s documentation for the Page Up and Page Down equivalents. If the key combination sends an ordinary arrow movement instead, try the keyboard’s page-navigation function while holding Ctrl.
Use the Page keys, not the up and down arrow keys by themselves. Arrow keys move the active cell within the current worksheet; the Ctrl-plus-Page-key combination changes worksheets. This difference explains why pressing Ctrl+Down does not normally take you to the next tab.
How Sheet Order Affects Navigation
The words “next” and “previous” refer to the worksheet order shown in the tab bar, not to alphabetical order, date order, or the order in which you last visited sheets. If the tabs are Summary, Inputs, and Results, the next sheet after Summary is Inputs even if Results seems like the more natural next step for your task.
To change what the shortcuts reach, rearrange the worksheet tabs. You can drag a tab left or right with the mouse; Excel then uses the new tab order for subsequent sheet navigation. Hidden worksheets are not displayed as ordinary tabs and are skipped during this kind of visible-sheet navigation. If only one worksheet is visible, pressing either shortcut will not reveal a hidden sheet.
At the end of the visible tab sequence, the shortcut does not wrap around to the beginning. For instance, if Results is the last visible sheet, pressing Ctrl+Page Down does not take you back to Summary. Use Ctrl+Page Up to go back, or select the desired tab directly. Knowing this is useful in workbooks with many tabs because a key press that appears to do nothing may simply have reached the end of the sequence.
Choosing the Fastest Way to Reach a Sheet
The keyboard shortcuts are most convenient when you are moving between neighboring tabs. If you are reviewing a sequence of monthly sheets, for example, repeated presses of Ctrl+Page Down can take you from April to May, June, and July without moving your hands to the mouse. Use Ctrl+Page Up to retrace the sequence.
For a distant worksheet in a large workbook, repeated presses can be slower and make it easy to lose track of your position. A mouse click on the named tab may be faster if the tab is visible. If the name is off-screen, the small sheet-tab navigation arrows at the lower-left of the Excel window can scroll the tab strip; clicking one of those arrows scrolls the tabs but does not, by itself, activate a different worksheet. Click the target tab after it comes into view.
Choose a method based on what you know:
- Use
Ctrl+Page DownorCtrl+Page Upfor a nearby sheet in tab order. - Click a visible tab when you know its name and can see it.
- Scroll the tab strip with its navigation arrows when the target tab is outside the visible area.
- Reorder tabs if you regularly navigate through them in a meaningful sequence.
A workbook’s tab order can be different from the order of sheets in a printed report or a list of dates. If you rely on shortcuts, check the tab sequence before assuming that the next sheet contains the next period or step.
Common Problems and Misunderstandings
If nothing seems to happen, first check whether the key combination is being entered as intended. On a compact keyboard, the Page Down function may require Fn. Also check that Excel has focus: if a dialog box or another application is active, the shortcut may not act on the worksheet. A workbook with only one visible sheet, or a workbook already at the end of the tab sequence in the direction you are moving, can also make the command appear ineffective.
A frequent misconception is that Ctrl+Page Down scrolls down through rows. It does not. Scrolling within a worksheet changes the portion of the grid on screen; moving between sheets changes the active tab. Similarly, the horizontal scroll bar moves the view across columns in the current sheet, not across worksheets.
Another common confusion is between switching and changing a sheet. These shortcuts do not rename a tab, insert a worksheet, delete a worksheet, or change its position. They only select an existing visible worksheet. If your goal is to add a sheet or rename one, use the worksheet controls or the relevant Excel command instead of repeatedly pressing Page Down.
Finally, a worksheet change does not automatically change formulas or data. A formula on another sheet may refer to the sheet you just left, but simply switching tabs does not rewrite that reference. Excel displays the contents of the newly active sheet while preserving the workbook’s existing cells and formulas.
Other Ways to Navigate Between Worksheets
Clicking a worksheet tab is the clearest alternative when the name is visible. This is especially useful when the workbook contains tabs with descriptive names such as Budget, Assumptions, and Charts, since selecting a named tab avoids counting how many shortcut presses are needed. If many tabs are present, the tab-navigation arrows can expose tabs that do not currently fit in the window.
You can also use Excel’s Go To command to jump to a cell reference on another sheet. Press Ctrl+G or F5 to open Go To, then enter a reference such as Summary!A1 and confirm it. If the sheet name contains spaces or certain punctuation, enclose the name in single quotation marks, for example 'Annual Summary'!A1. Go To takes you to a cell on that sheet, so it is more useful when you want a specific location than when you simply want to browse tabs.
For a workbook you use often, clear tab names and a sensible order can make both keyboard and mouse navigation easier. Avoid relying only on tab color to identify sheets: colors can help visually, but the shortcut still follows position, not color or meaning. If a workbook is shared, coordinate tab rearrangements with other users because changing the order affects everyone who opens that workbook.
Mac and Excel for the Web
In Excel for Mac, the sheet-navigation commands are generally Control+Page Down and Control+Page Up, as on Windows. Mac keyboards differ: some have dedicated Page Up and Page Down keys, while many MacBook keyboards do not. On a keyboard without those keys, Fn plus the corresponding arrow key may send the Page Up or Page Down command; the exact key mapping can vary by model and keyboard settings. If the shortcut behaves differently, use the worksheet tabs or check the keyboard’s page-key mapping.
In Excel for the web, keyboard behavior can depend on the browser and keyboard. Some browsers use Page-key combinations for browser-tab navigation, so a shortcut may be handled by the browser rather than Excel. If that happens, click the worksheet tab, or use the sheet controls in the workbook instead. Excel for the web and desktop Excel can also differ in which shortcuts are available or intercepted, so do not assume that a shortcut working in the desktop app will behave identically in every browser.
When working across different computers, the sheet tabs are the dependable fallback: they make the current sheet and the destination visible and do not depend on a particular keyboard layout. For frequent navigation on a laptop, it is worth confirming whether the machine requires Fn for Page Up and Page Down before relying on the shortcut.
Frequently Asked Questions
What is the shortcut to move to the next sheet in Excel?
On Windows, press Ctrl+Page Down. It activates the next visible worksheet to the right in tab order. On Mac, use Control+Page Down, with Fn if your keyboard needs it to produce Page Down.
How do I move to the previous sheet in Excel?
Press Ctrl+Page Up on Windows or Control+Page Up on Mac. The previous worksheet means the visible tab immediately to the left, not necessarily the sheet you visited most recently.
Can I use a shortcut to jump directly to a sheet by name?
Excel’s next- and previous-sheet shortcuts move one tab at a time; they do not ask for a sheet name. To jump to a known cell on a sheet, open Go To with Ctrl+G or F5 and enter a reference such as Inputs!A1.
Why does Ctrl+Page Down switch browser tabs instead of sheets?
In some browser and Excel for the web combinations, the browser can capture the Page-key shortcut. Click the worksheet tab as a fallback. In desktop Excel for Windows, the intended sheet-navigation shortcut is Ctrl+Page Down.
Does Ctrl+Page Down create a new worksheet?
No. It selects the next existing visible worksheet. Adding, deleting, renaming, and rearranging worksheets are separate actions, and this shortcut does not perform any of them.
Related
- Excel Dependent Drop-Down List: 3 Levels
- Excel Dependent Drop-Down Lists with Dynamic Ranges
- Excel Dependent Drop-Down Lists in Tables
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets COUNTIF With Multiple Ranges: How It WorksGoogle Sheets’ COUNTIF function accepts one range at a time, so to count matching values across separate ranges,…
- Excel MAX Between Two Dates: Find the Highest ValueTo find the largest value in B2:B100 for records dated between the start date in D2 and the…
- Share Your Outlook Calendar: Steps and PermissionsTo share an Outlook calendar, open Calendar, choose Share Calendar, select the calendar, enter the person’s email address,…
- Change Date Format in Excel to DD/MM/YYYYTo display Excel dates as DD/MM/YYYY, select the date cells, press Ctrl+1, choose Number > Custom, enter dd/mm/yyyy…
- Excel Cannot Insert Row: Causes and FixesYes. Excel blocks a row insertion when shifting cells down would push cells it considers occupied beyond the…
- Copy and Paste Word to Excel: Tables, Text, and FormattingTo copy content from Word to Excel, select the text or table in Word, press Ctrl+C, click the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.