Excel Keyboard Shortcut to Duplicate a Sheet Quickly

In Excel for Microsoft 365 on Windows, there is no single dedicated key combination that instantly duplicates a worksheet. The quickest keyboard route is Alt+H, O, M to open the Move or Copy dialog; select Create a copy, choose where the copy should go, and select OK.

Is There a Dedicated Shortcut to Duplicate a Sheet?

Excel does not assign a default one-step shortcut such as Ctrl+D to duplicate the active worksheet. Ctrl+D fills cells downward, so using it does not copy a sheet. The ribbon key sequence Alt+H, O, M is a shortcut to the relevant dialog, but you still need to tell Excel to create a copy rather than move the original.

Read the sequence as a series of key presses, not as keys to hold down together: press Alt, then H, then O, then M. These are Excel ribbon Key Tips. The letters may appear on screen after you press Alt, helping you follow the next step. The sequence applies to Windows desktop Excel; it can vary if you use another platform, a different interface language, or customized ribbon settings.

If you are comfortable using a mouse, Ctrl-dragging a sheet tab is often faster. That shortcut and the keyboard-dialog method both create a worksheet in the same workbook; the dialog is more useful when you need to choose a destination or copy the sheet to another open workbook.

Duplicate a Sheet with the Windows Keyboard

Use these steps when you want to make a copy and keep the original worksheet in its current position:

Select the worksheet tab you want to copy.
Press Alt, then H, then O, then M. The Move or Copy dialog opens.
In the To book list, choose the workbook that should receive the copy. To duplicate the sheet in its current workbook, choose that workbook.
Under Before sheet, select the tab that should appear after the new copy. Excel places the copy immediately before the selected sheet. Choose the option to move to the end if you want the copy at the end of the tab row.
Select the Create a copy checkbox. This is the important step: without it, Excel moves the original sheet instead of duplicating it.
Select OK. Excel inserts the copied sheet in the chosen location.

You can operate the dialog with the keyboard after opening it: use Tab to move between controls, the arrow keys to change a list selection, and the Space bar to toggle a focused checkbox. The exact focus order can depend on the dialog state, so check that Create a copy is enabled before confirming. If it is not selected, pressing Enter may move the original sheet rather than make a duplicate.

Use Ctrl-Drag for a Faster Copy

For a quick duplicate within the same workbook, hold down Ctrl and drag the sheet tab to the place you want the copy. Keep Ctrl held while dragging, then release the mouse button and Ctrl. Excel creates a copy instead of moving the original. A small plus indicator may appear while dragging to signal that the action will copy.

This method is convenient when the destination is visible on the sheet-tab bar. For example, if a workbook has tabs named January, February, and March, you can Ctrl-drag February beside March to create a copy there. The copied tab will typically receive a name such as February (2); you can rename it afterward.

Ctrl-drag is a mouse-and-keyboard gesture, not a purely keyboard shortcut. It can also be awkward when the workbook has many tabs, the horizontal tab area is crowded, or the destination is in a different workbook. In those situations, the Move or Copy dialog gives you more direct control over where the copy goes.

How the Mac and Web Methods Differ

On Excel for Mac, the Windows Alt-based ribbon sequence does not apply in the same way. A common quick method is to hold Option while dragging the worksheet tab to its new position; this creates a copy. You can also use the sheet’s context menu or the Move or Copy command available from Excel’s sheet controls, then select the copy option in the dialog. Menu wording and available controls can differ slightly by Mac version.

In Excel for the web, use the sheet tab’s context menu and choose Duplicate when that command is available. The Windows desktop sequence Alt+H, O, M is not a reliable shortcut for the web interface, whose ribbon and menus are browser-based. If you cannot find Duplicate, check that you have editing permission and that the workbook is open in an editing mode rather than read-only view.

Do not assume that a shortcut documented for Windows will work identically on a Mac or in a browser. The key combinations, drag modifiers, and available commands depend on the platform. If a desktop workbook is open in the web app, the safest approach is to use the visible sheet-tab commands provided in that interface.

What Excel Copies—and What It Does Not

A worksheet copy generally carries the sheet’s contents and much of its worksheet-level setup. This commonly includes cell values, formulas, formatting, column widths, row heights, and objects such as charts or shapes placed on the sheet. It is a useful way to make a new month’s template or preserve a working version before changing a report.

A copied sheet is not a separate workbook. It remains part of the destination workbook, and formulas or references in the copy may still point to other sheets or workbooks just as they did in the original. For example, a formula in a copied report that refers to a data sheet may continue to use that data sheet; copying the report does not automatically create a new independent data source.

Some workbook features have their own rules or dependencies. A copied sheet can bring along worksheet-level settings and objects, but it does not necessarily duplicate every external resource or change links to suit a new purpose. After copying, review items such as formulas, named ranges, charts, data connections, print settings, and links to other workbooks if the copy will be used as a separate report. If the sheet contains buttons or macros, remember that the code may rely on workbook-level procedures or specific sheet names.

Also distinguish duplicating a worksheet from copying a range of cells. Copying cells transfers selected cell content; duplicating a sheet creates another tab with a broader set of sheet-level content and layout. If your goal is only to reuse a table in another location, copying the range may be more appropriate.

Choose the Copy’s Position and Rename It

In the Move or Copy dialog, Excel’s Before sheet selection controls where the new tab appears. Selecting a worksheet places the copy immediately before that worksheet; choosing the end option places it after the existing tabs. This is about tab order, not the position of cells within the worksheet. You can change the tab order later by dragging the tab, or reopen the dialog if you need more control.

Excel normally gives a duplicate a variation of the original sheet name, such as Sales (2). That prevents a name collision because sheet names in a workbook must be unique. To rename the duplicate, double-click its tab, type the new name, and press Enter. You can also right-click the tab and choose Rename.

Use a name that makes the copy’s purpose clear, such as Sales – Forecast or April Template. A descriptive name matters when formulas refer to sheets by name, when other people use the workbook, or when several versions of a report are open side by side. If you rename a sheet later, Excel generally updates direct worksheet references in formulas, but check external links and any code that depends on the original name.

Common Problems and How to Fix Them

The original tab moved instead of copying: In the dialog, Create a copy was probably not selected. Undo immediately with Ctrl+Z if appropriate, then repeat the steps and verify the checkbox before selecting OK.
Ctrl-drag moves the tab: Keep Ctrl pressed throughout the drag and release it only after you release the mouse button. If dragging is difficult, use the dialog instead.
The keyboard sequence does nothing: Confirm that you are using desktop Excel for Windows and press each Key Tip in order. In a localized version or with a modified ribbon, the letters may differ; use the displayed Key Tips or open the command from the ribbon or sheet-tab context menu.
The destination workbook is missing: The other workbook may not be open, or it may not be available as an editable destination. Open the workbook first and check whether it is protected or read-only.
The copy has a number in its name: Excel adds a suffix to keep the tab name unique. Rename it after copying if you need a specific label.
The duplicate does not behave independently: Check formulas, external references, named ranges, and connections. A sheet copy can preserve references to the original workbook’s other sheets rather than create separate copies of those sources.

If the workbook is protected, sharing-restricted, or opened with limited permissions, Excel may prevent moving or copying sheets. In that case, check the workbook’s protection and access status rather than assuming the shortcut is wrong.

Duplicate, Move, or Copy to Another Workbook?

Use Duplicate or Create a copy when you need both the original and a second version in the same workbook. Use a normal move when you want to change the original sheet’s position without creating another one. The checkbox in the Move or Copy dialog decides which of these actions Excel performs.

The same dialog can copy a sheet to another open workbook. Select the destination in To book, choose its insertion point, check Create a copy, and confirm. If you leave the checkbox clear, Excel transfers the sheet instead. Before copying between workbooks, consider whether formulas in the sheet refer to tabs that exist only in the source workbook; those references may need attention afterward.

For a one-time duplicate, the built-in dialog or tab-drag method is usually enough. If you need to reproduce a complex process repeatedly, consider whether a reusable template is a better fit. Templates can provide a clean starting point without requiring users to remember which sheet to duplicate, but they require extra setup and should be designed around the workbook’s formulas, links, and intended workflow.

Frequently Asked Questions

What is the keyboard shortcut to duplicate a sheet in Excel?

There is no single dedicated default shortcut. In Excel for Windows, press Alt, H, O, M to open Move or Copy, then check Create a copy and confirm. The ribbon letters are pressed in sequence.

Does Ctrl+D duplicate a worksheet?

No. Ctrl+D fills the selected range downward from the top row. It does not create a worksheet. To duplicate a sheet, use the Move or Copy dialog or Ctrl-drag its tab in Windows.

How do I duplicate a sheet without using the mouse?

On Windows, use Alt, H, O, M, then navigate the dialog with Tab and the arrow keys. Make sure Create a copy is selected before confirming. There is not a default one-key shortcut that completes the whole operation automatically.

How do I duplicate a sheet in Excel for Mac?

Hold Option while dragging the sheet tab to copy it, or open the sheet’s menu and use Move or Copy with its copy option. Windows Alt-based Key Tips are not the same on Mac.

Can I duplicate a sheet into another workbook?

Yes. Open both workbooks, open Move or Copy, choose the destination workbook under To book, select the insertion point, and check Create a copy. Review formulas afterward because they may still refer to the source workbook.

Why did Excel move my sheet instead of duplicating it?

The Create a copy checkbox was likely left unchecked in the dialog. Undo the move if needed, reopen Move or Copy, select the checkbox, and then confirm.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.