In Excel for Microsoft 365 on Windows, the quickest way to duplicate a worksheet is to hold Ctrl, drag its sheet tab to a new position, and release the mouse button. Excel makes a copy instead of moving the original. For a dialog-based method, use Home > Format > Move or Copy Sheet and select Create a copy. The drag method uses both a key and the mouse; there is no single-key shortcut that duplicates a sheet by itself.
What You’ll Need
- An open Excel workbook with the worksheet you want to copy.
- Permission to make changes to the workbook. If it is protected or read-only, you may need the owner to unlock it or provide an editable copy.
- A keyboard and mouse or trackpad for the drag shortcut. You can use Excel’s Move or Copy Sheet command instead if dragging is difficult.
Step-by-Step
- Save or identify the workbook. Open the workbook and check that you are working in the right file. If you are about to make a major set of changes, save a separate copy first. Duplicating a sheet is usually reversible with Ctrl+Z, but a saved backup is useful if the copy needs extensive edits or the workbook is shared.
- Find the worksheet tab. Sheet tabs appear along the bottom of the Excel window, such as January or Summary. If you cannot see the tab, use the tab navigation arrows at the lower left to scroll through the tabs, or widen the Excel window. Do not click a cell inside the sheet; the tab itself is the target.
- Duplicate it with Ctrl-drag on Windows. Press and hold Ctrl, click the tab of the sheet you want to copy, and keep the mouse button held down while dragging the tab to the spot where you want the copy. A small plus sign may appear beside the pointer to indicate that Excel will copy rather than move the sheet. Release the mouse button first, then release Ctrl. The new tab normally appears next to the original or at the position where you dropped it.
- Check the new tab. Excel commonly gives the copied sheet a name such as Summary (2). Click the new tab and verify that it contains the expected cells, formatting, charts, and other sheet content. If you dropped it in the wrong place, drag its tab to the desired position or undo and repeat the copy.
- Rename the copy if needed. Double-click the new sheet tab, type a clear name, and press Enter. Sheet names cannot be blank, contain a colon, slash, question mark, asterisk, left or right bracket, or backslash, and cannot exceed 31 characters. A name already used by another tab is not allowed.
- Use the Move or Copy dialog if you prefer not to drag. Select the sheet tab, then choose Home > Format > Move or Copy Sheet. In the dialog, choose the destination workbook in To book (choose the current workbook to keep the copy there), select where the copy should appear under Before sheet, and tick Create a copy. Select OK. If you leave Create a copy unticked, Excel moves the original sheet instead.
Keyboard access to the dialog on Windows: With the worksheet active, press Alt, then H, O, and M in sequence to open Move or Copy Sheet in Microsoft 365. These are ribbon key tips, not a simultaneous key combination. Key tips can differ if the ribbon or language settings differ; if the sequence does not open the dialog, use the ribbon path above.
On a Mac: Hold Option while dragging the sheet tab to duplicate it. To use the dialog, Control-click or right-click the tab and choose Move or Copy (the wording or menu placement can vary by Excel for Mac release), then select the copy option and destination. The Windows Ctrl-drag and Alt ribbon sequence are not the Mac equivalents.
In Excel for the web: Right-click the sheet tab and choose Duplicate if that command is available in your workbook. Use this rather than assuming that the Windows Ctrl-drag behavior will work in a browser. Web commands can depend on the workbook and current Excel web interface; if Duplicate is unavailable, open the workbook in the desktop app or use another supported copy method.
Common Mistakes
- Dragging without holding Ctrl. On Windows, dragging a sheet tab without Ctrl moves the original tab; it does not create a duplicate. If the original moved, press Ctrl+Z promptly to undo, then try again while holding the key throughout the drag.
- Releasing the key or mouse too early. Keep Ctrl pressed while you drag. Release the mouse button before releasing the key. If you let go of Ctrl during the movement, Excel may treat the action as a move.
- Forgetting Create a copy in the dialog. The Move or Copy Sheet dialog handles both actions. Confirm the checkbox is selected before choosing OK; otherwise, Excel relocates the original sheet.
- Copying the wrong tab. When tabs are narrow or similar in name, it is easy to select a neighboring sheet. Read the tab name before dragging, then inspect the copy before editing it.
- Assuming a duplicated sheet is independent. The copied cells and formatting are separate, but formulas may still refer to the original sheet or other worksheets. Charts, defined names, data connections, and links can also behave differently depending on how they were set up. Check important references rather than assuming every dependency has been redirected.
- Trying to reuse an existing sheet name. Excel requires each worksheet in a workbook to have a unique name. Rename the copy with a new, valid name instead of typing the name of an existing tab.
Tips
- Choose the copy’s position deliberately. Drag it beside the original for easy comparison, or use Before sheet in the dialog to place it before a specific tab. The order of tabs does not change the order of worksheets in formulas or the workbook’s data.
- Use the dialog to copy between open workbooks. In To book, choose another open workbook, choose a position in its tab list, and select Create a copy. If you are copying to a different workbook, check whether formulas, named ranges, charts, and external links still point where you intend.
- Give working copies descriptive names. Names such as Budget – Draft or January – Revised make it easier to tell the copy from the source. Before sharing, remove temporary copies or label them clearly so readers do not edit the wrong sheet.
- Check grouped tabs first. If several sheet tabs are selected as a group, Excel can apply actions to multiple sheets. Look for the word Group in the title bar or check whether multiple tabs are highlighted. Click a single tab to ungroup them before copying one worksheet.
- Remember that the copy includes the worksheet, not the whole file. It is useful for reusing a template, layout, or report structure while keeping the rest of the workbook intact. To make a completely separate workbook, use File > Save As instead.
Troubleshooting
- The original sheet moved instead of being copied: On Windows, undo with Ctrl+Z if the action is still in the undo history. Repeat the drag while holding Ctrl from the moment you pick up the tab until after you release the mouse. Alternatively, use the dialog and verify Create a copy.
- The sheet will not move or copy: Check whether workbook structure protection is turned on. In desktop Excel, look under Review > Protect Workbook; if workbook structure is protected, you need the password or help from the workbook owner to change sheet tabs. A read-only file or restricted shared workbook may also prevent changes. Save an editable copy if you have permission, or ask the owner to enable editing.
- You cannot see the tab or have room to drag it: Use the sheet navigation controls at the bottom left to scroll to the tab. You can also drag the divider near the horizontal scroll bar to make more room for sheet tabs, or use the Move or Copy dialog, which does not require dragging.
- The duplicate does not show the results you expected: Compare it with the original and inspect formulas, chart series, pivot tables, data validation, conditional formatting, and links. A sheet copy can preserve references to other sheets in the same workbook; copying into a different workbook can also create external references. Update only the references that should point somewhere new.
- The shortcut does nothing or the dialog sequence fails: Confirm that the pointer is on a sheet tab, not a cell or the horizontal scroll bar. Try a right-click on the tab and select the copy command, or use Home > Format > Move or Copy Sheet. On a Mac, use Option-drag; in a browser, use the tab’s Duplicate menu command when available.
- Excel says the sheet name is invalid: Use a unique name of no more than 31 characters and remove prohibited characters such as
/,:, or?. If Excel reports that the name already exists, choose a different one.
Frequently Asked Questions
Is there a keyboard-only shortcut to duplicate a sheet in Excel?
There is no universal one-key or keyboard-only duplicate command. On Windows, Ctrl-dragging the sheet tab is the quick shortcut-style method. The ribbon key sequence Alt, H, O, M opens the Move or Copy Sheet dialog, where you still need to select Create a copy.
What is the fastest way to copy a sheet in Excel for Windows?
Hold Ctrl, drag the sheet tab to the desired position, release the mouse button, and then release Ctrl. Verify the new tab appeared before making changes.
Does Ctrl-drag work on a Mac?
No. The Mac equivalent is to hold Option while dragging the sheet tab. You can also open the tab’s Move or Copy command and select the copy option.
Can I duplicate a sheet into another workbook?
Yes. Use Home > Format > Move or Copy Sheet, choose the destination workbook under To book, select a position, and tick Create a copy. Review formulas and links after copying between workbooks.
Will duplicating a sheet copy its formulas and formatting?
It copies the worksheet content and much of its sheet-level formatting, including formulas and charts. References may continue to point to the same cells or sheets as before, so verify formulas and connected objects if the copy is meant to be a new, independent report.
Can I duplicate a sheet in Excel for the web?
Often you can right-click the tab and select Duplicate. If the command is missing, use the desktop app or another available copy option; browser commands can differ from desktop Excel.
Related
- Delete Everything Highlighted in Excel: Step-by-Step
- How to Delete Extra Rows in Excel
- How to Delete Duplicate Values in Excel Without Losing Data
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 Conditional Formatting With IFYes. In Google Sheets, use Format > Conditional formatting, choose Custom formula is, and enter a formula that…
- Excel Data Tables: What They Do and How to Use ThemIn Microsoft Excel, a Data Table is a What-If Analysis tool that recalculates a formula for different values…
- Excel Split Cell After a Character: Methods That WorkIn Excel for Microsoft 365 on Windows, split a cell at a character with Data > Text to…
- How to Wrap Text in Google Sheets on a PC: A GuideTo wrap text in Google Sheets on a PC, select the cell or cells, then choose Format >…
- Excel Sum Keyboard Shortcut: Use AutoSum in SecondsIn Excel for Microsoft 365 on Windows, press Alt+= to insert AutoSum, which creates a SUM formula for…
- How to Center a Table on a Page in Excel for PrintingTo center a table on a printed page in Excel, open Page Layout, launch the Page Setup dialog,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.