To flip between worksheet tabs in Excel for Microsoft 365 on Windows, press Ctrl+Page Up for the previous sheet or Ctrl+Page Down for the next one. If you mean changing a sheet tab’s position, use Alt, H, O, M to open Move or Copy Sheet, then choose where to place it. These steps work in an open workbook; save it first if you are making substantial changes.
What You’ll Need
- Excel for Microsoft 365 on Windows and a workbook with at least two worksheets.
- A keyboard with Page Up and Page Down keys, or a way to access those keys using your laptop’s Fn key.
- If you plan to rearrange worksheets, permission to edit the workbook. A protected workbook may prevent changes to its sheet structure.
The phrase flip tabs can mean either switching the active worksheet or changing the order of worksheet tabs. These are different actions: the first changes which sheet you are viewing, while the second changes the workbook’s layout. The steps below cover both. The worksheet tabs are the named tabs along the bottom of the Excel window, not tabs such as Home or Insert on the ribbon.
Step-by-Step
- Open the workbook and identify the worksheet tabs. Look along the bottom of the Excel window for sheet names such as Summary, January, or Data. Click any cell in the workbook if needed so Excel, rather than another application or a text-entry box, has keyboard focus. Switching sheets does not change any cell values by itself.
- Move to the previous worksheet. On Windows, press Ctrl+Page Up. Excel activates the worksheet immediately to the left of the current tab. For example, if the tabs appear as Summary, Data, and Chart, pressing the shortcut while on Chart takes you to Data. The active sheet’s tab is usually highlighted.
- Move to the next worksheet. Press Ctrl+Page Down to activate the sheet immediately to the right. From Data in that example, the shortcut takes you to Chart. Press the shortcut again to continue one sheet at a time. It does not jump alphabetically or choose a sheet based on its name.
- Repeat the shortcut to travel farther. Keep pressing Ctrl+Page Up or Ctrl+Page Down to move through the tab order. Excel generally moves from one end of the row of sheets to the other when you continue past the last sheet; if that is not what you see, check that focus is in the worksheet and that the workbook has multiple visible sheets. The tab order, not the order of the columns or rows, determines which sheet is next.
- Choose the tab you want to reposition. If by flip you mean rearrange the workbook, first make the sheet you want to move active. Use the switching shortcuts to reach it. Check the tab name before proceeding: the Move or Copy command acts on the active worksheet, not on whichever sheet you last edited or selected in a cell.
- Open the Move or Copy Sheet dialog using the ribbon keys. Press and release Alt, then press H, O, and M in sequence. Do not hold all four keys down together. This follows the Windows ribbon KeyTips for Home, Format, and Move or Copy Sheet in the standard English interface. If your ribbon is localized or the letters differ, press Alt and follow the letters shown on screen instead.
- Set the sheet’s new position. In the Move or Copy dialog, use Tab or Shift+Tab to move focus to the Before sheet list. Use the arrow keys to select the sheet that should come immediately after the sheet you are moving; the active sheet will be placed before that choice. To put the active sheet at the end, select the Move to end option if it appears in the list. The dialog’s focus order can vary, so watch for the focus outline and use the list label to confirm you are changing the position rather than the destination workbook.
- Confirm the move. Tab to OK and press Enter, or activate the button when it has focus. Look at the sheet tabs to verify the new order. Moving a sheet changes its position in the workbook but does not ordinarily copy it. If you select Create a copy in the dialog, Excel creates a duplicate instead, so leave that box clear when you only want to move the original.
- Check the result and save if appropriate. Use Ctrl+Page Up or Ctrl+Page Down to confirm the sheet is where you expect and that adjacent sheets are still present. Save with Ctrl+S once you are satisfied. If a formula, chart, or other workbook feature refers to sheet names, moving a sheet usually does not rename it, but review important work before sharing the file.
- Use the Mac equivalent when needed. In Excel for Mac, Control+Page Up and Control+Page Down can move between worksheets. On a Mac keyboard without dedicated Page Up and Page Down keys, try Fn+Control+Up Arrow or Fn+Control+Down Arrow. Keyboard layouts and Excel settings can affect which combination is available. To reorder a sheet, use the Move or Copy command from the sheet tab’s context menu or the Excel ribbon; Windows Alt KeyTips such as Alt, H, O, M do not apply in the same way on Mac.
- Account for Excel for the web. In a browser, Ctrl+Page Up and Ctrl+Page Down may be intercepted by the browser to switch browser tabs. If that happens, use the sheet navigation controls and select the worksheet tab, or consult Excel for the web’s keyboard-shortcut help for the shortcuts available in your browser. Reordering sheets is available in supported workbooks, but the desktop Windows ribbon sequence above is not a reliable web shortcut.
Common Mistakes
- Pressing the wrong page key: Ctrl+Page Up goes to the previous worksheet; Ctrl+Page Down goes to the next. If you reverse them, you may move in the opposite direction from the one you intend.
- Confusing worksheet tabs with ribbon tabs: The shortcuts navigate between sheets at the bottom of the window. They do not switch from Home to Insert, or from one open workbook to another.
- Trying to rearrange a sheet with the switching shortcut: Ctrl+Page Up and Ctrl+Page Down only change the active sheet. They do not change the tab order. Use Move or Copy Sheet to reposition a worksheet.
- Moving the wrong worksheet: The dialog applies to the active sheet. Check its name before opening the dialog, especially if you have been jumping between tabs quickly.
- Creating a copy by mistake: The Move or Copy dialog includes a Create a copy option. If you want one sheet in a new position, ensure this option is not checked before confirming.
- Holding the ribbon shortcut as one chord: Alt, H, O, M is a sequence of KeyTips on Windows. Press Alt and then each letter in turn; holding the keys together may trigger a different command or do nothing.
Tips
- Use the sheet names as landmarks. Before moving several sheets, note the current order and the exact tab you want to move. This makes it easier to choose the correct destination in the dialog and verify the result.
- Remember that the shortcut follows tab order. If worksheets are arranged by month, Ctrl+Page Down follows their displayed order. Excel does not automatically sort tabs by name or date.
- Use a laptop’s Fn key when Page Up or Page Down is shared. Many compact keyboards print Page Up and Page Down as secondary functions on the arrow keys or other keys. Check the keyboard labels and use Fn with the relevant key if the standard shortcut does not work.
- Keep the active sheet visible while using KeyTips. Press Alt and look at the letters displayed on the ribbon. This is especially helpful if your Excel interface uses a different language or a customized ribbon.
- Make a copy before a major reorganization. Saving a separate workbook copy gives you a safe reference if you move multiple sheets and later need to restore the original order. Ctrl+Z is useful for many worksheet edits, but do not rely on it as your only safeguard for structural changes.
- Distinguish hidden sheets from missing sheets. The switching shortcuts move among visible worksheet tabs. If a sheet is hidden, it will not appear as a normal tab in the sequence; use the workbook’s Unhide option if you are authorized to reveal it.
Troubleshooting
The shortcut changes something in the browser or another app. First make sure Excel is the active window and the worksheet grid has focus. In Excel for the web, the browser may reserve Ctrl+Page Up or Ctrl+Page Down for browser-tab navigation. Use the visible sheet controls, or open the workbook in the desktop app if you need consistent worksheet keyboard navigation.
Nothing happens when you press Ctrl+Page Up or Ctrl+Page Down. Confirm that the workbook has more than one visible worksheet and that a cell, rather than a dialog box or formula bar, has focus. On a laptop, try Fn with the Page Up or Page Down key. If the workbook is in a protected state or a sheet is hidden, those conditions can also affect which sheets you can reach.
The wrong sheet becomes active. The shortcut moves by one position in the current tab order, which may not match the order you expected. Read the active tab name, then press the shortcut again in the appropriate direction. If sheet names are similar, use the status bar and the visible tab labels rather than relying on memory.
The Move or Copy dialog will not let you change the order. Check whether the workbook structure is protected. In Excel for Windows, review the Review tab for workbook protection controls; if the structure is protected, you may need the password or permission from the workbook owner to change sheet positions. Do not try to bypass protection. Also confirm that you opened the dialog for the intended active sheet.
The Alt, H, O, M sequence does not open the dialog. Press Alt once and look for the KeyTips that appear. Your version, ribbon customization, or interface language may use different letters. Follow the displayed KeyTips, or use Home > Format > Move or Copy Sheet with the mouse. On Mac, use the Mac interface rather than assuming the Windows KeyTip sequence works.
The moved sheet appears in the wrong place. In the dialog, the Before sheet choice names the sheet that should follow the moved sheet. Reopen Move or Copy Sheet, select the intended following sheet, and confirm. If the sheet should be last, choose Move to end where available. Verify the tab order afterward and save only when it is correct.
Frequently Asked Questions
What is the shortcut to switch tabs in Excel?
On Windows, press Ctrl+Page Up for the previous worksheet and Ctrl+Page Down for the next worksheet. On Mac, Control+Page Up and Control+Page Down are commonly used; compact keyboards may require Fn as well.
Can I flip directly to a worksheet by name with a shortcut?
Ctrl+Page Up and Ctrl+Page Down move one sheet at a time; they do not open a list of names. If many sheets are present, repeat the shortcut while checking the tab labels, or use the sheet navigation controls to locate the desired tab.
How do I move a sheet tab without a mouse?
On Windows, activate the sheet, press Alt, H, O, M in sequence, choose its position in the Move or Copy dialog with the keyboard, then confirm. The exact KeyTips can differ with language or ribbon customization, so follow the letters Excel displays.
Does moving a worksheet tab move its data?
It changes the worksheet’s position in the workbook, not the cells within the sheet. The sheet’s contents and name remain associated with that worksheet. Selecting Create a copy instead makes a duplicate, so check that option before confirming.
Why do Ctrl+Page Up and Ctrl+Page Down switch browser tabs?
When Excel is open in a web browser, the browser can claim those keys before Excel receives them. Use the workbook’s sheet navigation controls or open the file in desktop Excel to use the Windows worksheet shortcuts more predictably.
Related
- How to Find a Grade in Excel
- Goal Seek in Excel: How to Find and Use It Step by Step
- Find the Financial Year From a Date in Excel Easily
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Change Layout View in Outlook: A Practical GuideTo change Outlook’s layout, use Settings > Mail > Layout in new Outlook or Outlook on the web,…
- How to Add a Heading to Every Printed Page in ExcelTo repeat a heading row on every printed page in Excel for Microsoft 365 on Windows, open the…
- SOLIDWORKS Split: How to Divide a Solid BodyTo split a solid body in SOLIDWORKS, create or select a suitable cutting tool, open Insert > Features…
- How to Embed Vimeo Videos in PowerPoint for PresentationsTo embed a Vimeo video in PowerPoint, open the slide in the desktop app, choose Insert > Video…
- Excel Sales Tracking Template by Customer: How to Build OneYes, you can track sales by customer in Excel using a template that combines a data entry sheet,…
- Excel PivotTable Slicer: How to Insert and Use OneTo insert a slicer in Excel for Microsoft 365 on Windows, click inside the PivotTable, then choose PivotTable…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.