To reorder a worksheet in Excel for Microsoft 365 on Windows, select its tab and press Alt+H, O, M, then choose where to place it in the Move or Copy dialog. The shortcut Ctrl+Page Up or Ctrl+Page Down only switches between sheets; it does not change their order. Excel has no built-in shortcut that randomly shuffles worksheet tabs, so this guide covers moving tabs into a chosen order.
What You’ll Need
- A desktop version of Excel with the workbook open. The instructions below are for Excel for Microsoft 365 on Windows.
- At least two worksheets in the workbook. If you cannot see the sheet tabs, use the navigation controls at the bottom-left of the Excel window or check whether the sheet tabs are hidden.
- Permission to change the workbook structure. If the workbook structure is protected, Excel may prevent you from moving sheets until the protection is removed by someone with the password.
You do not need to enable macros or install an add-in to move a sheet. Before changing a workbook with complicated formulas, consider saving a copy: sheet order can matter to formulas that refer to a range of worksheets, even though ordinary cell references are usually adjusted by Excel.
Step-by-Step
- Identify the sheet you want to move. Look along the bottom of the workbook and note the tab name. Click that tab once to make it active. If the tab is off-screen, use the small sheet-tab scrolling arrows at the lower left to bring it into view; those arrows scroll the tab strip and do not move any worksheets.
- Open the Move or Copy dialog with the keyboard. Press and release Alt, then press H, O, and M in sequence. This is a ribbon Key Tip sequence, not a combination you hold down all at once. It follows Home > Format > Move or Copy Sheet. The Move or Copy dialog should appear. If it does not, make sure the worksheet grid is active and try the sequence again.
- Choose the destination. In the dialog, use the Before sheet list to choose the sheet that should come immediately after the sheet you are moving. For example, if you want to move Budget before Summary, select the Budget tab first and choose Summary in the list. The selected worksheet will be placed just before that destination sheet.
- Move the sheet to the end, if that is your goal. In the same Before sheet list, select (move to end). This places the active sheet after the other listed sheets. Check the workbook name shown at the top of the dialog: if you opened the dialog from a workbook with multiple open files, confirm that you are moving the sheet within the intended workbook.
- Leave Create a copy unchecked for a move. The checkbox creates a duplicate sheet instead of simply changing the position of the original. Keep it clear when you want to reorder the existing worksheet. If you intentionally want a copy, select the checkbox and verify the destination before proceeding.
- Confirm the change. Click OK, then inspect the tab strip. The sheet should now appear before the destination you chose, or at the end if you selected that option. If you moved the wrong sheet or selected the wrong place, press Ctrl+Z immediately to undo the move, then repeat the steps with the correct tab and destination.
- Use the mouse as an alternative for a quick move. Click and hold the worksheet tab, drag it left or right, and watch for the small black triangle that marks the insertion point. Release the mouse when the marker is between the intended tabs. Dragging is handy for a short move; the dialog is more precise when the workbook has many sheets or the destination is far away.
- Check the result in context. Read the surrounding tab names and confirm the new order matches your plan. If the workbook has navigation instructions, print settings, formulas spanning several sheets, or a table of contents, check those too. A reordered tab may change which worksheets are included in formulas that depend on sheet position.
For example, to put a worksheet named April after March but before May, activate April, press Alt, H, O, M, choose May in the Before sheet list, and click OK. Excel places April immediately before May, which gives the intended sequence March, April, May. If May is not in the list because the dialog is showing another workbook, cancel and reopen the dialog from the correct workbook.
On a Mac, the Windows Alt key sequence is not the equivalent shortcut. Use the worksheet tab’s context menu or the Excel menu-bar command Sheet > Move or Copy Sheet, then choose the destination in the dialog. In Excel for the web, use the sheet tab’s context menu and its move option when available; the Windows ribbon Key Tip sequence does not apply there. To switch tabs rather than move them, Ctrl+Page Up and Ctrl+Page Down work in Windows desktop Excel. On Mac, Control+Page Up and Control+Page Down are commonly used, though a compact keyboard may require Fn as well.
Common Mistakes
Confusing navigation with reordering: Ctrl+Page Up and Ctrl+Page Down activate the previous or next worksheet. They do not move the current tab. Use Alt+H, O, M or drag the tab to alter the order.
Holding all the ribbon keys together: Alt+H, O, M is a sequence. Press Alt, release it, and then enter the letters in order. If you press them as one chord, Excel may not open the command.
Choosing the wrong reference point: The Before sheet list names the worksheet that will follow the moving sheet. It is easy to select the sheet you want the moving tab to follow instead. Look at the tab order after the move, or undo and choose the next sheet in the intended sequence.
Accidentally making a copy: Selecting Create a copy leaves the original in place and adds another sheet. This can cause confusion if both tabs have similar names or contain nearly identical data. Leave the box unchecked unless duplication is what you want.
Assuming every formula is unaffected: Excel generally updates direct references when a sheet is moved, but formulas using a 3-D reference such as a range from January through December can include worksheets based on their position between the named endpoint tabs. Reordering a sheet can change what falls inside that range. Review important totals after moving tabs, especially in reporting workbooks.
Tips
Plan the desired order before moving several sheets. Write down the sequence or arrange the tabs in small groups, then verify after each move. This reduces the chance of placing a sheet relative to the wrong neighbor, particularly when tabs have similar names such as Q1 Actual and Q1 Forecast.
Use the dialog for a long workbook and drag-and-drop for a nearby destination. In the dialog, selecting the destination by name is less dependent on how much of the tab strip is visible. When dragging, pause until the insertion marker appears; releasing without a clear marker may leave the tab where it was.
Remember that moving a sheet between workbooks is different from reordering it within the same workbook. The Move or Copy dialog includes a To book list when other workbooks are open. Keep the current workbook selected if your intention is only to rearrange its tabs, and be cautious about moving sheets that contain formulas linked to other workbooks.
If by shuffle you mean putting sheets into a random order, Excel does not include a standard randomize-tabs button or shortcut. You can manually move tabs, or use a purpose-built macro, but a macro changes workbook structure and may not be reversible with Ctrl+Z. Save a separate copy before running any macro, and use only code you understand and trust.
Troubleshooting
The shortcut does nothing: Confirm that you are using Excel desktop for Windows and that the workbook window is active. Press Alt, then H, O, M as separate key presses. If keyboard focus is in a cell-editing mode, press Esc once and try again. You can also open the same command by right-clicking the worksheet tab and choosing Move or Copy.
The sheet will not move: Check whether workbook structure protection is enabled. In Windows Excel, look under Review for Protect Workbook; if the structure is protected, only someone authorized to unprotect it can allow sheet moves. If the workbook is read-only or opened with restricted permissions, save an editable copy or ask the file owner for access.
The sheet tab is missing: It may be hidden rather than absent. Right-click a visible sheet tab and choose Unhide, then select the worksheet if it appears in the list. If Unhide is unavailable, there may be no normally hidden sheet to display, or workbook protection may be restricting the change. Very hidden sheets generally require the workbook’s VBA editor or other authorized administration to reveal.
The tab moved to an unexpected place: Undo with Ctrl+Z if available, reopen the dialog, and choose the sheet that should come directly after the moving sheet. If you used drag-and-drop, repeat more slowly and release only when the insertion triangle is at the right boundary. Check that you did not select a different tab before opening the dialog.
Totals changed after reordering: Inspect formulas that use 3-D references or depend on a fixed sequence of tabs, plus any summary sheets that assume a particular order. Restore the original tab order with Undo if possible, or move the sheets back manually, then recalculate and verify the affected results. Do not assume that a changed total is only a display issue.
Frequently Asked Questions
What is the shortcut to move a sheet in Excel?
In Excel for Microsoft 365 on Windows, press Alt, then H, O, M to open Move or Copy Sheet. Choose the destination and click OK. It is a sequence of key presses, not a single Ctrl-based shortcut.
Does Ctrl+Page Down shuffle worksheet tabs?
No. It activates the next worksheet, while Ctrl+Page Up activates the previous one. To reorder tabs, use Move or Copy Sheet or drag the tab.
Can I move several sheets at once?
Yes. Select adjacent tabs with Shift-click, or select multiple nonadjacent tabs with Ctrl-click, then use Move or Copy Sheet. Treat this carefully: the selected sheets move together as a group. Click a single tab afterward to clear the group selection before editing individual sheets.
Can I alphabetize sheet tabs with a built-in shortcut?
No. Excel does not provide a standard shortcut or built-in command that automatically sorts worksheet tabs alphabetically. You can arrange them manually with the dialog or tab dragging. A macro can automate sorting, but save a copy first because macro changes cannot be undone with Ctrl+Z.
Will moving a sheet break formulas?
Most ordinary formulas that refer directly to cells on a sheet continue to point to that sheet, and Excel adjusts many references as needed. However, formulas using 3-D references can depend on sheet order, and links or custom code may have their own assumptions. Verify important calculations after rearranging tabs.
How do I move a sheet to another workbook?
Open Move or Copy Sheet and choose the destination file in the To book list, then select where the sheet should go. Choose Create a copy if the original must remain in its current workbook. Check formulas and links afterward, since references to the original workbook may need attention.
Related
- How to Search in Excel: Keyboard Shortcut and Tips
- How to Search in Google Sheets
- Search in Excel: Keyboard Shortcuts, Find and Replace
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 Indent in Google Sheets: Simple WorkaroundsGoogle Sheets does not provide a standard Increase Indent button for cell contents. To create a visible indent,…
- Convert Excel to Word: Tables, Links, and FormattingTo convert Excel content into Word, select the cells you need in Excel, copy them, and paste them…
- Group Rows in Excel by Values: A Practical How-ToTo group rows in Excel by matching values, sort the list by the column you want to group,…
- How to Freeze Selected Columns in Excel Without ScrollingTo keep columns visible while you scroll across a worksheet, select the cell immediately to the right of…
- How to Find Rank in Excel with RANK.EQTo rank a value in Excel, use RANK.EQ. With scores in C2:C6 and the first score in C2,…
- Excel Text Usage Examples for Cleaning and FormattingExcel text examples often use TEXT to turn a number or date into a chosen display, such as…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.