To move a worksheet tab in Excel for Microsoft 365 on Windows without using the mouse, press Alt, H, O, then M to open the Move or Copy dialog. Choose the destination in the “Before sheet” list and select OK. This changes the worksheet’s position in the workbook; it does not just switch to that sheet.
Before you start, identify the sheet you want to move and where it should go. If the workbook is important, save it first. Moving a sheet changes the workbook’s layout, so check formulas, charts, and links that refer to it afterward, especially if the sheet is being moved to another workbook.
What You’ll Need
- Excel for Microsoft 365 on Windows, with the workbook open and the sheet you want to move active.
- The name of the sheet that should come immediately after the moved sheet, or a decision to put the moved sheet at the end.
- Permission to edit the workbook. A protected workbook or a shared-workbook restriction may prevent moving sheets.
Step-by-Step
- Activate the worksheet you want to move. If another sheet is active, switch to the target sheet first. You can use Ctrl+Page Up or Ctrl+Page Down to move between worksheet tabs; these shortcuts change the active sheet, not its position. On some compact keyboards, you may need to hold Fn as well to access Page Up or Page Down.
- Open the Move or Copy dialog with the ribbon key tips. Press and release Alt, then press H, O, and M in sequence. Do not hold all four keys together. In the standard English Windows ribbon, these key tips open Home, Format, and Move or Copy Sheet. If your ribbon language or customization is different, press Alt and follow the letters displayed on screen rather than assuming the English sequence will apply.
- Check the “To book” setting. This dropdown chooses which workbook receives the sheet. To rearrange a tab in the workbook you are already using, leave the current workbook selected. If you choose a different open workbook, the sheet will be moved out of the current workbook, not merely reordered. The destination workbook generally needs to be open and able to accept the sheet.
- Choose the destination in “Before sheet.” This list shows the sheets in the destination workbook. Select the sheet that should come immediately after the sheet you are moving. For example, to place “January” between “Overview” and “February,” move January and choose “February” as the sheet to put it before. The moved tab will appear just before the selected tab.
- Use the keyboard to navigate the dialog. If focus is on “To book,” use Tab to move through the dialog controls. When the “Before sheet” list has focus, use the arrow keys to highlight the desired sheet. If you need to change the workbook dropdown, use the dropdown’s arrow keys and confirm the correct workbook before continuing. Focus order can vary slightly, so read the control labels and the selection shown rather than relying on a fixed number of Tab presses.
- Move the sheet to the end if that is the goal. In the “Before sheet” list, choose “(move to end)” when it appears as an option. This places the moved sheet after the other sheets in the destination workbook. If you do not see that option, select the appropriate final position shown in the list, or use the dialog’s available destination choices.
- Confirm the move. Make sure the “Create a copy” checkbox is not selected. Then press Enter if the OK button has focus, or use Tab to reach OK and press Enter. The dialog closes and the sheet tab appears at the chosen position. If “Create a copy” is checked, Excel leaves the original in place and inserts a duplicate instead.
- Verify the new order and workbook contents. Check the sheet tabs, particularly if several sheets have similar names. Select the moved sheet and confirm that its data is intact. If it was moved to another workbook, check formulas and charts that used it in the original workbook; references can change or become external links depending on what they refer to.
The destination rule is the key detail: “Before sheet” names the tab that should follow the moved sheet. If you want the sheet after a particular tab, choose the next tab in the current order as the “Before sheet” destination. For instance, to move “Notes” after “Summary” when “Data” currently follows Summary, choose “Data.” If Summary is already the last tab, choose “(move to end)” to place Notes after it.
For a quick move by one position, the same dialog still works: open it, select the tab immediately to the left of the intended position, and confirm. Excel does not provide a standard Windows shortcut that simply nudges a sheet tab one place left or right. The dialog is therefore the dependable keyboard-only option for both small adjustments and moving a tab across a long workbook.
Common Mistakes
- Confusing tab navigation with tab movement. Ctrl+Page Up and Ctrl+Page Down switch the active worksheet. They do not reorder tabs. Use the Move or Copy dialog to change the order.
- Choosing the wrong “Before sheet.” The chosen name is the sheet that will follow the moved sheet, not the one that should precede it. Pause before confirming and picture the resulting order.
- Leaving “Create a copy” checked. This creates another sheet rather than moving the existing one. If the tab count increases unexpectedly, undo immediately with Ctrl+Z if the action is still undoable, then repeat with the box cleared.
- Moving the sheet to another workbook by accident. Check “To book” before confirming. A sheet moved between workbooks can affect formulas and references, and the change may be harder to reverse after saving or closing files.
- Expecting the same shortcut in every Excel edition. The Alt key-tip sequence is for the standard English Windows desktop ribbon. Ribbon languages, customizations, Mac, and Excel for the web can have different controls.
Tips
- Save before a major rearrangement. Saving gives you a clear recovery point if you move the wrong sheet or discover a reference problem later.
- Use names as landmarks. In a workbook with many tabs, note the destination tab name before opening the dialog. This is more reliable than counting positions, particularly when hidden sheets are present.
- Move related sheets in a planned order. If you are reorganizing several tabs, decide on the full sequence first and move each sheet to its intended position. Verify the result after each move so a later move does not obscure an earlier mistake.
- Keep copies distinct from moves. A copied sheet gets a separate tab, while a moved sheet retains its identity within the workbook. Use the checkbox intentionally and review the tab names afterward.
- Remember the Mac and web differences. Excel for Mac does not use the same Windows Alt key-tip sequence. Use the macOS menu bar’s Sheet > Move or Copy Sheet command where available, then choose the destination in its dialog. On Mac, keyboard navigation through dialog controls can depend on macOS keyboard-access settings. Excel for the web may not provide the same desktop dialog; use its available sheet-tab controls or drag the tab when the web interface does not offer a keyboard move command.
Troubleshooting
Alt+H, O, M does not open the dialog: Press Alt once and look for the letters that appear over the ribbon. Key-tip sequences can differ if Excel uses another display language or the ribbon has been customized. Follow the visible prompts one at a time. Also confirm that Excel, rather than another application or a cell-editing field, has keyboard focus.
The sheet moved to the wrong place: Reopen Move or Copy Sheet for that active sheet and select the correct “Before sheet” destination. If you have not made further changes, Ctrl+Z may undo the last move; verify the workbook before continuing. If you already saved or performed other actions, use the dialog to put the sheet back rather than assuming Undo will restore the earlier state.
The sheet was copied instead of moved: Open the dialog again and inspect “Create a copy.” Clear it to move the original. If a duplicate has already been created, select the duplicate carefully before deleting it, so you do not remove the original sheet or its contents.
The move is blocked or a sheet is unavailable: Check whether the workbook structure is protected. In Excel for Windows, review Review > Protect Workbook; if workbook structure protection is on, an authorized person must unprotect it before sheets can be moved. A read-only file, organizational policy, or sharing restriction can also prevent changes. Do not try to bypass protection; ask the workbook owner for permission.
References look different after moving a sheet: If the sheet was moved within the same workbook, many internal references continue to point to it, but review formulas, charts, named ranges, and links if results change. When moving between workbooks, formulas that refer to other sheets may be updated to refer to the original workbook or may no longer work as expected. Keep both workbooks open during the move and check key results before saving.
Frequently Asked Questions
What is the keyboard shortcut to move a sheet tab in Excel?
On the standard English Windows ribbon, press Alt, then H, O, and M to open Move or Copy Sheet. Choose a destination and confirm. It is a ribbon key-tip sequence, not a single shortcut pressed all at once.
Can I move a tab one place left or right with a shortcut?
Excel does not have a standard built-in Windows shortcut that directly shifts the active tab one position. Use Move or Copy Sheet and choose the tab that should come after the moved sheet. The Ctrl+Page Up and Ctrl+Page Down shortcuts only switch between sheets.
How do I move a worksheet to the end of the workbook?
Open the Move or Copy dialog and select “(move to end)” in the “Before sheet” list, if offered. Confirm that the correct workbook is selected and that “Create a copy” is unchecked, then select OK.
Does moving a sheet tab move the worksheet’s data?
Yes. A sheet tab represents a worksheet, so moving the tab reorders that worksheet and its contents within the workbook. It does not move only the visible tab or rearrange columns and rows.
Can I use the same steps in Excel for Mac?
No. The Windows Alt key-tip sequence is not the Mac equivalent. In Excel for Mac, use Sheet > Move or Copy Sheet from the menu bar where available. Keyboard navigation details can vary with the Mac keyboard and accessibility settings.
Will moving a sheet break formulas?
Moving a sheet within the same workbook usually preserves many references, but you should check important formulas, charts, named ranges, and links. Moving it to another workbook can change references or create links back to the original file, so verify the results before relying on them.
Related
- How to Indent in Google Sheets: Simple Workarounds
- How to Indent in Microsoft Excel: Cells, Text, and Lists
- How to Indent Text in an Excel Text Box Step by Step
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Budget Spreadsheet Free? Find Templates and TipsYes. You can download a free Excel budget spreadsheet template, or create and edit a basic budget in…
- Excel vs Google Sheets for Dashboards: Which Fits?For a dashboard built from larger or messier data, Microsoft Excel for Microsoft 365 on Windows is usually…
- Google Sheets Dropdown From a Table: How It WorksYes. In Google Sheets, create a dropdown from table data by selecting the cells that need the menu,…
- Excel Import CSV: How to Open and Load FilesTo import a CSV into Excel for Microsoft 365 on Windows, choose Data > Get Data > From…
- Excel Consolidated Sum: Combine Data Across SheetsTo create a consolidated sum in Excel for Microsoft 365 on Windows, select the destination cell, choose Data…
- Excel Savings Plan Template: Build a Monthly Goal TrackerAn Excel savings plan template can track a target, current savings, monthly deposits, estimated interest, and the balance…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.