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. These shortcuts switch between sheet tabs in the current workbook; they do not randomly shuffle the tabs or change their order.
The Windows Shortcuts and What They Do
The two shortcuts work as a pair: Page Down moves one sheet to the right in the tab order, and Page Up moves one sheet to the left. The order is the order of the worksheet tabs along the bottom of the Excel window, not the order in which you last visited the sheets.
- Ctrl+Page Down: activate the next worksheet to the right.
- Ctrl+Page Up: activate the previous worksheet to the left.
For example, if the visible tabs are Summary, January, February, and March, pressing Ctrl+Page Down while Summary is active opens January. Press it again to open February. From March, Ctrl+Page Up returns to February. The shortcut changes which sheet is active; it does not edit cells, move a tab, or alter the workbook’s data.
On a full-size keyboard, Page Up and Page Down are usually separate keys. On a compact laptop keyboard, they may be secondary functions shared with arrow keys or other keys. Check the labels on your keyboard; you may need to hold Fn as well as Ctrl to send a Page Up or Page Down command. The exact key combination for those secondary keys depends on the computer.
How to Use the Shortcut
First, make sure the workbook is open and Excel has focus. Click a cell on the worksheet if necessary, then use the appropriate shortcut. You do not have to click the sheet tab first. If you are editing a cell, finish or cancel the edit before expecting a navigation shortcut to switch sheets; while a cell is being edited, keystrokes can be treated as text or editing commands instead.
- To move forward through the tabs, press Ctrl+Page Down once for each sheet you want to advance.
- To move backward, press Ctrl+Page Up once for each sheet you want to go back.
- Look at the highlighted tab at the bottom of the window to confirm which worksheet is active.
Each press moves one position, so the shortcut is most convenient when the destination is nearby. It is not a jump-to-sheet command: if a workbook has many tabs and the target is far away, repeated presses may be slower than choosing the tab directly. The sequence follows the worksheet tab order, including hidden gaps in the sense that hidden sheets are not available as ordinary visible destinations.
What Happens at the Ends of the Tab Bar
Think of the tabs as a row rather than a circular playlist. Moving forward advances toward sheets on the right; moving backward advances toward sheets on the left. Do not expect the shortcut to wrap from the last sheet to the first or from the first to the last. If you reach the end, reverse direction or select another sheet by name.
Also distinguish switching sheets from rearranging them. Ctrl+Page Down does not drag the active tab to a new position, and it does not cycle through a history of recently used sheets. If you need to change the permanent order, drag a tab to a new position with the mouse. That changes the workbook’s layout for everyone who opens it, whereas the keyboard shortcut only changes your current selection.
The phrase “shuffle between sheets” sometimes means quickly moving among tabs, and sometimes suggests randomizing their order. Excel’s built-in Page Up and Page Down shortcuts do the first. There is no standard keyboard shortcut that randomly reorders worksheets; randomizing tabs would require a separate manual or programmed process and should not be confused with ordinary navigation.
Choosing the Fastest Way to Reach a Sheet
The best navigation method depends on how many sheets the workbook contains and whether you know the destination. For two or three adjacent tabs, the keyboard shortcuts are usually direct and require no pointer movement. For a workbook with dozens of tabs, using the same shortcut repeatedly can become tedious.
- Nearby sheet: Use Ctrl+Page Down or Ctrl+Page Up to move one position at a time.
- Visible tab: Click its name at the bottom of the workbook.
- Sheet is outside the visible tab area: Use the sheet-navigation controls near the lower-left corner to scroll the tab bar, then select the tab.
- Many tabs and a known destination: In desktop Excel for Windows, right-click the small sheet-navigation arrows at the lower-left of the window to open the Activate dialog, then select a listed sheet.
The Activate dialog is especially helpful when a workbook has so many tabs that names are hidden off-screen. It lists worksheets that can be activated, so you can choose a destination instead of paging across every intervening tab. If the desired sheet is hidden, it will not behave like a normal visible tab; an authorized user may need to unhide it first.
Common Problems and Quick Checks
If the shortcut appears to do nothing, check whether Excel is actually receiving the keystrokes. A laptop may require Fn for its Page Up or Page Down function. A remote desktop, keyboard utility, or other application can also capture a key combination before Excel receives it. Try clicking a cell and using the shortcut again, or use the sheet tab with the mouse to determine whether the workbook itself is responsive.
- Excel is in cell-edit mode: Press Enter to finish the edit or Esc to cancel it, then try the sheet shortcut.
- The wrong sheet opens: Remember that the shortcut follows tab order, not recent history. Use the opposite shortcut to return.
- A sheet seems missing: It may be hidden, or its tab may be outside the part of the tab bar currently visible. Check the tab-navigation controls and workbook’s available sheet list.
- Keys affect another window: Click inside the workbook first. If using remote access, check whether the local or remote computer is handling the keypress.
- The tab bar is cramped: The horizontal scrollbar and the sheet tabs share space at the bottom of the window. Adjusting the divider between them can reveal more tab names.
Worksheet protection is generally about preventing edits, not preventing ordinary movement between visible sheets. However, workbook structure protection can restrict actions such as inserting, deleting, moving, hiding, or unhiding sheets. If a navigation or sheet-management action is unavailable, check whether the workbook’s structure is protected and whether you have permission to change it.
Mac and Excel for the Web
On Excel for Mac, the commonly used sheet-navigation shortcuts are Option+Right Arrow for the next sheet and Option+Left Arrow for the previous sheet. Mac keyboard layouts and Excel settings can affect shortcut behavior, so if those combinations do not work, use the sheet tabs or consult Excel’s current shortcut list for your installed version. Some Mac keyboards also have function-layer keys that make Page Up and Page Down less obvious than on a full Windows keyboard.
Excel for the web runs in a browser, where keyboard shortcuts can overlap with browser commands. The Windows desktop combinations should not be assumed to behave identically in every browser or setup. If the keypress changes browser tabs or does not move the worksheet selection, use the sheet tabs and the navigation controls in the workbook. The web app’s available keyboard behavior can also depend on whether you are using Windows or Mac and on browser accessibility settings.
In all versions, clicking a visible sheet tab remains a reliable fallback. It is also useful when you want to confirm the destination by name rather than move one tab at a time. The main difference is convenience: desktop Excel provides the familiar Windows key pair, while Mac and browser environments may call for their own shortcut or the on-screen controls.
Related Sheet-Navigation Tips
For a workbook used regularly by several people, make navigation easier by giving worksheets clear, distinctive names. Names such as “Inputs,” “Quarterly Summary,” and “2026 Actuals” are more useful than a long run of generic names, especially in the Activate dialog. Keep frequently used sheets near one another if the workbook’s workflow naturally moves among them; users can then reach them with fewer keypresses.
You can also color-code tabs from the sheet-tab context menu to make groups easier to spot. Colors do not change the order or the keyboard shortcuts, but they can help distinguish input sheets, reports, and archived periods. Avoid relying on color alone if the workbook is shared; meaningful names are still important for accessibility and clarity.
If your goal is to compare two distant sheets, consider opening a second view of the same workbook rather than repeatedly switching back and forth. In desktop Excel, use View > New Window to create another window for the open workbook. You can then arrange the windows and display different sheets in each. This is a comparison aid, not a replacement for the simple Page Up and Page Down shortcuts, and it does not create a separate copy of the workbook.
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 to activate the next worksheet to the right. On Mac, try Option+Right Arrow.
How do I go to the previous sheet?
On Windows, press Ctrl+Page Up. On Mac, use Option+Left Arrow. Each press moves one tab position backward.
Can I jump directly to a sheet by name with a shortcut?
The Page Up and Page Down shortcuts move one sheet at a time; they do not open a name search. In Windows desktop Excel, right-click the sheet-navigation arrows at the lower-left and choose the destination in the Activate dialog. Clicking a visible tab is another direct option.
Why does Ctrl+Page Down switch browser tabs instead?
In Excel for the web, the browser may interpret a key combination before the workbook does. Use the sheet tabs or workbook navigation controls if the shortcut affects the browser, and check the shortcut behavior for your browser and operating system.
Does the shortcut change the order of worksheets?
No. It only activates a different sheet. To reorder worksheets, drag a tab to a new position; that is a separate action and changes the workbook’s tab order.
Related
- Percent of Number in an Excel PivotTable: Show Values
- Password Protect an Excel Workbook to Require a Password
- Password Protect an Excel Spreadsheet: Steps and Safety
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: How to Find a Percentage of a NumberTo find a percentage of a number in Google Sheets, multiply the number by the percentage: if the…
- Autofit Page in Excel: Fit a Worksheet to One PageTo fit an Excel worksheet onto one printed page in Microsoft 365 for Windows, open Page Layout, then…
- How to Make Two Columns in Microsoft Word: A GuideTo make two columns in Microsoft Word for Microsoft 365 on Windows, open the Layout tab, choose Columns,…
- Excel Text to Number: Reliable Ways to Convert ValuesTo convert text-formatted numbers in Excel, select the cells and choose the warning icon’s Convert to Number option,…
- Excel Power Query Joins: How to Combine Tables CorrectlyTo join tables in Excel Power Query, load each table as a query, choose Home > Merge Queries,…
- Excel Data Table Greyed Out? Causes, Checks, and FixesIf Excel’s What-If Analysis > Data Table command is greyed out, first exit cell-editing mode, ungroup any selected…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.