How to Make a Copy of a Sheet in Excel

To copy a sheet 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 select OK. This creates a separate worksheet while leaving the original in place. You can copy a sheet into the same workbook or, if the destination workbook is open, into another workbook.

What You’ll Need

An Excel workbook containing the sheet you want to copy. Save your changes first so the duplicate includes the latest work.
If copying to another workbook, open both the source and destination workbooks in Excel. The destination file should be editable and saved in a location where you can access it.
If the workbook has protection enabled, you may need permission to change its structure. Sheet protection and workbook-structure protection are different; the latter can prevent adding or copying sheets.

Step-by-Step

Open the source workbook and find the sheet tab. The sheet tabs appear along the bottom of the Excel window, usually with names such as Sheet1 or Sales. If you cannot see the tab you need, use the tab scrolling controls at the bottom left to move through the tabs. If the sheet is hidden, right-click any visible sheet tab, choose Unhide, select the sheet, and select OK. You cannot copy a hidden sheet from its tab until it is unhidden.
Save the workbook before copying. Press Ctrl+S on Windows. Saving first gives you a clear starting point and reduces the chance of losing recent changes if you later close the source or destination file. If you are working with a shared workbook, make sure your edits have finished syncing before you continue.
Open the Move or Copy dialog. Right-click the tab of the sheet you want to duplicate, then select Move or Copy. In Excel for Microsoft 365 on Windows, this opens a dialog with a To book list, a Before sheet list, and a Create a copy checkbox. If you do not see Move or Copy, check whether workbook structure protection is on or whether you clicked a chart or another object instead of a worksheet tab.
Choose the destination workbook. To put the duplicate in the current workbook, leave the current workbook selected in the To book list. To copy it elsewhere, select the destination workbook from the list. The destination workbook must already be open in desktop Excel. To create a separate workbook containing the copied sheet, choose (new book), if that option appears. Excel creates the new workbook; save it with a suitable name and location.
Choose where the new sheet should appear. In Before sheet, select the sheet that should come immediately after the copy. For example, selecting Budget places the new sheet before the existing Budget tab. Choose (move to end) to put the copy after the destination workbook’s current sheets. This setting affects the new sheet’s position, not the original sheet.
Check Create a copy. This is the key step. If the box is not checked, Excel moves the original sheet instead of making a duplicate. Confirm that the destination and position are right, then select OK. Excel adds a new sheet tab, usually with a name such as Sales (2), while keeping the original tab in place.
Rename the duplicate and verify it. Double-click the new tab, type a clear name, and press Enter. Sheet names can be up to 31 characters and cannot contain a colon, backslash, slash, question mark, asterisk, or square brackets. Check a few important cells, formulas, and formatting in both sheets. A copied formula may still refer to the same cells or workbook as the original, which can be correct or may need adjustment.
Save the destination workbook. Press Ctrl+S after copying and renaming. When you copy between workbooks, confirm the duplicate is in the intended file before closing either workbook. If you used (new book), save that new workbook separately; creating the copy does not choose a permanent file name or folder for you.

Quick alternative in desktop Excel: You can copy a sheet within the same workbook by holding Ctrl while dragging its tab to a new position. Keep Ctrl held as you drag, then release the mouse button before releasing Ctrl. Excel displays a small plus sign when it is copying. If you drag without Ctrl, you move the original sheet instead. The Move or Copy dialog is usually safer when you need to choose another workbook or want to confirm the destination.

Excel for the web: In many current versions, right-click the sheet tab and choose Duplicate to make a copy in the same workbook. The web interface can differ as Microsoft updates it, and some desktop Move or Copy options may not be available. If you need to copy between workbooks, create a copy in the desktop app using the dialog above; this gives you clearer control over the destination workbook.

Common Mistakes

Forgetting Create a copy. The Move or Copy dialog can move a sheet if the checkbox is clear. Check the box before selecting OK. If the original tab has disappeared from its old position, you may have moved it; use Ctrl+Z promptly to undo if the move is still the most recent action.
Dragging without the copy modifier. Dragging a tab normally changes its position or moves it to another workbook. When using the Ctrl-drag method on Windows, look for the plus sign that indicates a copy before releasing the mouse.
Copying to the wrong workbook or position. In the dialog, the To book choice determines the file, while Before sheet determines where the new tab goes. Check both fields rather than assuming the copy will go to the workbook currently in front.
Assuming a copy is independent in every way. The copied sheet has its own cells and layout, but formulas can still refer to the original sheet, other sheets, or external workbooks. Changing a referenced source can therefore change calculated results in the duplicate too.
Using a name that Excel will not accept. A new tab may receive an automatic name, but a custom name must be unique within that workbook and follow Excel’s sheet-name rules. If Excel rejects a name, shorten it, remove the restricted character, or choose a name that is not already in use.

Tips

Copy before editing a template. Keep a clean original sheet, then duplicate it for a new month, department, or project. Rename each copy clearly, such as April Orders or West Region, so readers can tell the sheets apart.
Copy several adjacent sheets together when appropriate. Select the first sheet tab, hold Shift, and select the last tab to group the sheets in between. Right-click one of the selected tabs and use Move or Copy. Select Create a copy, then verify the result. Be careful: while sheets are grouped, some edits can affect all selected sheets. Click a single tab afterward to ungroup them.
Watch for named ranges and links. A copied sheet may bring along sheet-level names, formulas, charts, and formatting. Names that already exist in the destination workbook can behave differently from names that are unique to the copied sheet. After a cross-workbook copy, review formulas and links, especially if they refer to sheets or files that are not in the destination.
Use a descriptive name right away. Renaming the copy immediately makes it easier to verify that you are editing the right sheet and helps prevent accidental changes to the source. You can also use tab colors from the sheet-tab context menu to distinguish copies, if that feature is useful for your workbook.

Troubleshooting

Move or Copy is unavailable or copying is blocked: The workbook may have its structure protected. On the Review tab, look for Protect Workbook; if workbook protection is active, you need the password or permission from the workbook owner to change the structure. Protect Sheet is a separate setting that limits edits to cells and does not always prevent copying the whole sheet. In a shared or organization-managed file, ask the owner or administrator if you cannot change protection.

The destination workbook is missing from To book: Open the destination file in the same desktop Excel session, then reopen the Move or Copy dialog. If it still does not appear, check that it is open as an editable workbook rather than only in a browser or preview. You can also copy the sheet into a new workbook and then save that workbook, but check any formulas and links before relying on the result.

The copy appears in the wrong place, or the original seems to have moved: If the action just happened, press Ctrl+Z once and inspect the tabs. Then open Move or Copy again, choose the correct destination and Before sheet setting, and check Create a copy. Avoid making unrelated changes before undoing, because Ctrl+Z reverses the most recent actions rather than targeting a particular sheet operation.

Formulas or charts look different after copying: Check whether formulas point to other sheets, named ranges, or external files. A reference that worked in the source may point back to the original workbook after a cross-workbook copy. Inspect a formula in the formula bar and confirm the referenced sheet or file exists in the destination. Charts may also use source ranges elsewhere in the workbook, so verify their data source if the displayed values do not match expectations.

You cannot find the copied tab: Look through the tabs at the bottom, including tabs that may be off-screen. The copy may have been placed before the selected sheet or at the end of a long tab row. If the workbook is in a narrow window, widen it or use the sheet-tab navigation controls. Also check whether the destination workbook, rather than the source, received the copy.

Frequently Asked Questions

Does copying a sheet also copy its formulas and formatting?
Usually, yes. Excel copies the worksheet contents and much of its layout, including formulas, cell formatting, and objects on the sheet. Formulas may keep references to the original sheet or workbook, so check important calculations after copying.

How do I copy a sheet to another workbook?
Open both workbooks in desktop Excel, right-click the source sheet tab, choose Move or Copy, select the destination in To book, choose a position, check Create a copy, and select OK. Save the destination workbook afterward.

Can I copy a sheet without opening a dialog?
On Windows desktop Excel, hold Ctrl and drag the sheet tab to the desired position in the same workbook. Release the mouse while Ctrl is still held. Check for the plus sign as you drag. The dialog is a better choice when copying between workbooks.

What is the difference between Move or Copy and Duplicate?
Move or Copy is the desktop command that lets you choose a workbook and position, and its Create a copy checkbox determines whether Excel duplicates or moves the sheet. Duplicate is a simpler command available from the sheet-tab menu in many versions of Excel for the web and creates a copy in that workbook.

Can I copy a protected sheet?
Cell-level sheet protection may still allow you to copy the worksheet, depending on workbook settings. Workbook-structure protection can block adding, deleting, moving, or copying sheets. If Excel asks for a password or disables the command, contact the workbook owner rather than trying to bypass protection.

Will changes to the original sheet update the copy?
Not automatically just because the sheet was copied. The duplicate is a separate worksheet. However, formulas in it may refer to cells on the original sheet, so the displayed results can change when those referenced cells change. Review formulas if you want the copy to work independently.

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.