To duplicate a worksheet in Excel for Microsoft 365 on Windows, right-click its sheet tab, choose Move or Copy, select where the copy should go, check Create a copy, and click OK. You can also hold Ctrl while dragging a sheet tab to make a copy in the same workbook. Save the workbook first if the sheet is important, and check the copied sheet’s name and formulas afterward.
What You’ll Need
- A workbook open in the Excel desktop app for Windows, with the worksheet you want to copy.
- For copying to another workbook, open that destination workbook too. You can also choose to create a new workbook in the copy dialog.
- Permission to change the workbook structure. If the workbook’s structure is protected, you may need the password or help from its owner.
You do not need to select the worksheet’s cells before copying it. The commands below copy the whole worksheet, including its cell contents and formatting, rather than just the cells you have highlighted.
Step-by-Step
- Open the workbook and find the sheet tab. At the bottom of the Excel window, locate the tab for the worksheet you want to duplicate. If you do not see it, use the sheet-navigation arrows at the bottom left to scroll through the tabs. A hidden sheet will not appear as a tab; to show it, right-click a visible tab, choose Unhide, select the sheet, and click OK. You may need to unhide it before you can make a copy.
- Open the Move or Copy dialog. Right-click the worksheet’s tab and choose Move or Copy from the context menu. Alternatively, select the sheet and go to Home > Cells > Format > Move or Copy Sheet. The dialog lets you choose a destination and whether to move the original or create a duplicate.
- Choose the destination workbook. In the To book list, choose the current workbook to place the copy alongside its existing sheets. To put the copy in another workbook, that workbook generally needs to be open first; then select its name in the list. Choose (new book) if you want Excel to create a separate workbook containing the copied worksheet. A new workbook is a separate file, so save it with a suitable name when you are done.
- Choose where the copy will appear. In the Before sheet list, select the sheet that should come immediately after the new copy. For example, to place the duplicate before a tab called Summary, select Summary. To put it at the end, select the last sheet in the list. The list controls the copy’s position; it does not change the order of the original workbook’s contents.
- Check Create a copy. This is the crucial setting. If the box is left clear, Excel moves the original sheet instead of duplicating it. Confirm that the check mark is visible before proceeding. Then click OK. Excel adds the new worksheet in the location you chose.
- Rename the new sheet. Excel gives a duplicate a name based on the original, often with a number added. To make the purpose clear, double-click the new tab, type a distinct name, and press Enter. Sheet names can be up to 31 characters and cannot contain certain characters, including a colon, slash, question mark, asterisk, opening or closing bracket, or backslash.
- Check the result before editing it. Confirm that the original tab is still present and that the duplicate contains the expected data, formatting, charts, and other sheet content. If you copied the sheet to another workbook, inspect formulas and links in particular: formulas that refer to other sheets or files may still refer to their original source.
Quick method for a copy in the same workbook: Hold down Ctrl, drag the sheet tab to the desired position, and release the mouse button. A small plus sign should indicate that Excel is making a copy. Release Ctrl after the drag. If the original tab disappears from its old position rather than remaining there, undo the action with Ctrl+Z and use the Move or Copy dialog with Create a copy checked. On a Mac, the corresponding drag modifier is generally Option rather than Ctrl; the dialog method is also available from the sheet-tab context menu.
You can also use the ribbon route Home > Cells > Format > Move or Copy Sheet when right-clicking the tab is inconvenient. Both routes open the same dialog, so the key choices are still the destination, the insertion point, and Create a copy.
Common Mistakes
- Forgetting to check Create a copy. This moves the worksheet, which can make it seem as though it vanished. If that happens immediately, press Ctrl+Z to undo, reopen the dialog, check the box, and try again. On Mac, use Command+Z to undo.
- Copying cells instead of the sheet. Selecting a range and using Ctrl+C copies cell contents, not the complete worksheet as a separate tab. Use the sheet-tab menu or Ctrl-drag when you need a true worksheet duplicate.
- Trying to use a name that is already taken. A workbook cannot have two worksheets with exactly the same name. Rename the duplicate with a unique label, such as “Budget – April” or “Budget Copy,” rather than trying to reuse the original name.
- Assuming all references will point to the new sheet. A copied worksheet may contain formulas that still refer to the original sheet or to another workbook. This matters if you plan to edit the copy independently. Check representative formulas and any displayed link warnings before relying on the results.
- Copying into the wrong workbook or position. Read the To book and Before sheet selections before clicking OK. If you choose (new book), Excel creates a separate workbook; it does not add the sheet to the current one.
Tips
- Use a clear naming pattern. Add a date, month, version, or purpose to the copied sheet name. Names such as “Forecast – Q3” are more useful than a series of tabs called “Copy,” “Copy (2),” and “Copy (3).” Check the 31-character limit if Excel rejects the name.
- Use Move or Copy when precision matters. The dialog makes the destination explicit and is less dependent on where you drag the tab. It is a good choice when copying between open workbooks or inserting the duplicate beside a particular sheet.
- Use Ctrl-drag for a quick same-workbook duplicate. This is handy when you want to place the copy near the original. Keep Ctrl held throughout the drag, look for the plus sign, and verify that both tabs remain afterward.
- Save after checking the copy. Once you have confirmed the tab, contents, and references, save the workbook. If you are copying a report or template that must remain unchanged, consider saving a separate backup before making further edits.
- Review linked content, not just visible values. Formulas, charts, data validation, conditional formatting, named ranges, and connections can behave differently depending on what they refer to. A sheet may look right while a formula or chart still draws from the original tab. Inspect the parts that matter to your task.
Troubleshooting
Move or Copy is unavailable, or Excel will not create the duplicate: Check whether the workbook’s structure is protected. In Excel for Windows, look at Review > Protect Workbook. If workbook protection is enabled, the person who set it may need to unprotect it before sheets can be moved or copied. A password may be required; do not try to bypass protection. Ask the workbook owner for access if you do not have permission. Worksheet protection and workbook-structure protection are different settings, so check the workbook setting rather than assuming that locked cells are the cause.
The copied sheet is missing from view: Look along the tab bar and use the navigation arrows to find it; Excel may have placed it off-screen among many tabs. You can also check whether the sheet is hidden by right-clicking a visible tab and choosing Unhide. If there is no suitable hidden sheet to select, check that you chose the correct destination workbook in the dialog.
The copy has unexpected formula results or link prompts: Open a few key formula cells and review their references. When a sheet is copied to a different workbook, formulas that refer to other sheets or external files can retain links to the source workbook. Charts or other objects may also use source ranges. Update references only after confirming what the copied sheet is supposed to use, then verify the displayed results. If Excel asks whether to update links, do not choose blindly; decide whether the source file is trusted and whether those links should remain.
Ctrl-drag moved the original instead of copying it: Press Ctrl+Z immediately, then use the right-click Move or Copy command. In the dialog, select the destination and position, check Create a copy, and click OK. The dialog is the more reliable method if the drag gesture is awkward or the plus sign is hard to see.
You are using Excel for the web: The Windows desktop ribbon steps may not match the browser interface. In Excel for the web, right-click the sheet tab and look for the available duplicate or copy-sheet command; options can vary with the workbook and the web app’s current interface. If you need the desktop Move or Copy dialog or cannot find the command, open the workbook in the Excel desktop app. On Mac, use the sheet-tab context menu for Move or Copy, or try Option-drag for a same-workbook copy.
Frequently Asked Questions
Does duplicating a sheet change the original?
Creating a copy leaves the original worksheet in the workbook. The two sheets are separate tabs, but formulas or charts on the duplicate may still refer to the original sheet or shared source data. Check those references if the copy needs to work independently.
Can I duplicate a sheet into another workbook?
Yes. Open the destination workbook, right-click the source sheet tab, choose Move or Copy, select the destination in To book, choose an insertion point, check Create a copy, and click OK. You can also select (new book) to create a workbook for the copied sheet.
Will the duplicate include formatting, charts, and print settings?
Copying the worksheet tab duplicates the sheet as a whole, so it generally carries its cell formatting and sheet-level objects and settings. Still, check charts, page layout, print area, and other elements you rely on, especially after copying to another workbook.
Why can’t I copy the worksheet?
A protected workbook structure can prevent sheets from being moved or copied. The workbook may also be subject to permissions or restrictions. Check Review > Protect Workbook, and ask the file owner for permission or the password if protection is intentional.
Can I duplicate more than one sheet at a time?
You can select adjacent tabs with Shift-click or nonadjacent tabs with Ctrl-click, then use Move or Copy and check Create a copy. Handle grouped sheets carefully: while multiple tabs are selected, edits can affect every selected sheet. After copying, click a single tab to ungroup them before continuing.
What is the difference between moving and copying a sheet?
Moving relocates the existing worksheet, so it no longer remains in its former position or workbook. Copying creates another worksheet and keeps the original. In the dialog, the Create a copy checkbox determines which action Excel performs.
Related
- How to Delete Duplicate Names in Excel Without Losing Data
- How to Delete Duplicate Data in Excel
- How to Delete Duplicate Entries in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Export Excel List to SharePoint: Step-by-Step GuideTo export an Excel list to SharePoint, format the data as an Excel table, then create a SharePoint…
- Google Sheets Dropdown Equals: Formulas and Rules ExplainedTo check whether a Google Sheets dropdown equals a particular choice, compare the dropdown cell with that value…
- Excel Named Data Range: Create, Use, and Manage NamesAn Excel named data range is a descriptive name assigned to a cell or range of cells, so…
- Outlook View: Restore a Previous Layout or VersionYes. If you mean the older Outlook app, turn off the New Outlook switch in the upper-right corner…
- Add an Automatic Reply to a Shared Mailbox in OutlookTo add an automatic reply to a shared mailbox, open that mailbox in Outlook on the web, then…
- How to Mass Archive Emails in OutlookTo mass archive emails in Outlook, open the folder containing the messages, select the messages you want, and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.