How to Copy an Entire Sheet in Excel: Steps and Tips

How-to basics · Updated November 20, 2026

To copy an entire 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 select OK. This creates a separate worksheet that generally retains the original sheet’s content, formulas, formatting, and objects. Before you start, save your workbook and decide whether the copy belongs in the same workbook or another open workbook.

What You’ll Need

  • An Excel workbook containing the worksheet you want to copy. If the sheet is hidden, unhide it first so you can select its tab.
  • If you are copying the sheet to another workbook, that destination workbook should be open in Excel.
  • Permission to change the workbook. If its structure is protected, you may need the password or help from the workbook owner.
  • Enough time to check formulas, links, and any workbook-specific settings after copying, especially if the sheet contains connections or references to other sheets.

Step-by-Step

  1. Open the source workbook. Start Excel and open the workbook with the sheet you want to duplicate. If you are copying to a different workbook, open that workbook too. Having both workbooks open makes the destination available in the copy dialog.
  2. Find the sheet tab. Look along the bottom of the Excel window for the worksheet’s tab. If the tab is not visible, use the arrows at the lower left to scroll through the tabs. If the sheet is hidden, right-click a visible sheet tab, select Unhide, choose the hidden sheet, and select OK. You can hide it again after copying if needed.
  3. Open the sheet’s copy options. Right-click the tab of the sheet you want to duplicate. Select Move or Copy from the context menu. If you use a touchpad, a two-finger click may open the same menu; a right-click or equivalent secondary click also works.
  4. Choose the destination workbook. In the Move or Copy dialog, open the To book list. Choose the current workbook to make a copy beside the original, or select the other open workbook to copy the sheet there. If the destination workbook is not listed, check that it is open in the same Excel session. For a separate destination file, open it and try again.
  5. Choose where the new tab will appear. In Before sheet, select the sheet that should come immediately after the new copy. Choose (move to end) to place it after the last sheet. This setting controls tab order; it does not change the copied sheet’s cells or content. Consider choosing a nearby tab if you want the duplicate next to related worksheets.
  6. Check Create a copy. This is the crucial step. Tick the Create a copy box before selecting OK. If you leave it unchecked, Excel moves the original sheet to the chosen location instead of making a duplicate. When copying to another workbook, leaving the box unchecked removes the sheet from the source workbook after it is moved.
  7. Finish the copy. Select OK. Excel creates a new sheet tab in the destination workbook. It often gives the tab a name such as the original name followed by a number, for example Sales (2). Click the new tab and confirm that it is the sheet you intended to copy.
  8. Rename and review the duplicate. Double-click the new tab name, type a clear name, and press Enter. Then check a few representative areas: headings, formulas, formats, charts, and print layout. If the sheet refers to other worksheets or external files, review those links before using the copy for new work.

The copied worksheet is separate from the original: changing a cell in one does not normally change the corresponding cell in the other. However, formulas in either sheet can still refer to shared cells, other worksheets, or external workbooks. A duplicate therefore does not automatically make every formula independent of the rest of the workbook.

Common Mistakes

  • Forgetting to tick Create a copy. The dialog is called Move or Copy, so it is easy to miss the checkbox. Without it, Excel moves the original sheet rather than keeping the original and making another one. If the tab disappears from the source workbook, check the destination and use Undo immediately if appropriate.
  • Copying cells instead of the worksheet. Selecting the grid and pressing Ctrl+C copies a selected range, not the complete worksheet as a separate tab. It may omit objects, page setup, or other sheet-level features. Use the sheet-tab menu when you need a full worksheet duplicate.
  • Choosing the wrong destination or position. The To book and Before sheet fields are easy to confuse. Confirm the workbook name in the first field and the intended tab position in the second before you click OK.
  • Assuming every reference becomes independent. Copying a sheet can preserve links to other worksheets, named ranges, or external workbooks. A copied budget or report may still draw values from the original workbook. Inspect important formulas and data connections before editing or sharing the duplicate.
  • Ignoring duplicate names. Excel will make the new tab name unique, often by adding a number. That name may not suit your workbook’s naming scheme, and formulas or instructions that expect a specific sheet name may need attention.
  • Trying to copy a sheet while workbook structure is protected. Structure protection can block adding, moving, deleting, hiding, or copying worksheet tabs. Do not remove protection unless you are authorized; ask the workbook owner for the password or an unlocked copy.

Tips

  • Save before copying. Saving gives you a clean recovery point if you choose the wrong option or the workbook behaves unexpectedly. This is particularly useful with large files, shared workbooks, or workbooks containing external data.
  • Use the tab menu for a complete duplicate. This is generally more reliable than selecting all cells and copying them. A worksheet copy is designed to carry sheet-level features such as column widths, formatting, charts, and page settings along with the cell contents.
  • Copy to another workbook while both files are open. In the dialog, select the destination under To book. After copying, save the destination workbook. If the sheet contains formulas that refer to other sheets, check whether those referenced sheets also exist in the destination.
  • Give the duplicate a useful name straight away. Names such as Monthly Report – Draft or Forecast – 2026 are easier to recognize than an automatically numbered tab. Excel does not allow certain characters in worksheet names, including a colon, slash, backslash, question mark, asterisk, or square brackets; names are limited to 31 characters.
  • Check calculations and external links deliberately. A copied worksheet can retain formulas and data connections. If you plan to use it as a template, decide whether formulas should continue to pull from the original source, point to a new source, or be replaced with values. Make changes only after confirming what the workbook is intended to do.
  • Use a keyboard-assisted shortcut only when appropriate. In Windows desktop Excel, hold Ctrl and drag a sheet tab to another position in the same workbook to create a copy there; a small plus sign indicates copying. This is quick for a same-workbook duplicate, but it is less explicit than the dialog. For another workbook or a precise destination, use Move or Copy.
  • On a Mac, use the sheet-tab menu. Control-click or right-click the tab and choose Move or Copy or Move or Copy Sheet, depending on the Excel version. Choose a destination, tick Create a copy, and confirm. The Windows Ctrl-drag gesture is not the same on Mac; use the menu instead.
  • In Excel for the web, look for Duplicate. Right-click the worksheet tab and choose Duplicate when that option is available. To copy a sheet to another workbook or use the desktop dialog, open the file in the Excel desktop app. The web version’s available sheet commands can differ from those in desktop Excel.

Troubleshooting

Move or Copy is unavailable or Excel will not complete the action: Check whether the workbook structure is protected. In desktop Excel, look under Review for workbook protection controls; if the structure is protected, you may need to unprotect the workbook with authorization. Also check whether the file is read-only or whether your permissions prevent changes.

The other workbook is missing from To book: Open the destination workbook in Excel, then return to the source and reopen the Move or Copy dialog. Make sure both files are open in the same Excel application session. If the destination is in a browser or has not been opened, it will not appear as a selectable workbook in the desktop dialog.

The original sheet moved instead of being copied: If the workbook is still open and you have not made other changes, press Ctrl+Z on Windows to undo the move. On Mac, use Edit > Undo or the equivalent Undo command. If Undo is no longer available, move the sheet back or reopen a saved version; check carefully before continuing.

The copy is present but formulas show errors: Inspect formulas that refer to another sheet, a named range, or an external workbook. The copied sheet may depend on a source that is absent, renamed, or unavailable. Confirm the referenced sheet names and external file paths, and use Excel’s link or connection controls only if you understand how the workbook is configured.

Some formatting or objects appear different: Confirm that you copied the sheet tab rather than only a range. Check for hidden rows or columns, filtered data, conditional formatting, and objects that may be positioned outside the visible area. If the file is opened in Excel for the web, inspect it in desktop Excel too; a feature can display or behave differently between versions.

A hidden sheet cannot be selected: Unhide it from the sheet-tab context menu first. If Unhide is unavailable or the sheet is very hidden due to workbook settings, ask the workbook owner to make it accessible. Do not change workbook code or protection settings unless you are authorized.

Frequently Asked Questions

Does copying a worksheet copy everything on it?
It copies the worksheet as a sheet, usually including cell contents, formulas, formatting, column widths, charts, and many sheet-level settings. Still review specialized features such as external connections, links, and protected settings, since they may rely on other parts of the workbook.

How do I copy a sheet into a different workbook?
Open both workbooks in desktop Excel. Right-click the source tab, select Move or Copy, choose the destination in To book, select a position, tick Create a copy, and click OK. Save the destination file afterward.

Can I copy several sheets at once?
Yes. In desktop Excel, select adjacent tabs by clicking the first and Shift-clicking the last, or select individual tabs with Ctrl-click on Windows. Right-click one of the selected tabs and choose Move or Copy, then tick Create a copy. Take care: commands applied to grouped sheets can affect every selected sheet.

Will the formulas in the copy still work?
Usually, formulas are copied with the sheet, but their references may still point to other worksheets, named ranges, or external files. Check important formulas in the new location, particularly after copying to a different workbook where a referenced sheet might not be present.

Can I copy a sheet in Excel for the web?
Often, you can right-click the tab and choose Duplicate to copy it within the workbook. For copying to a separate workbook or when the command is missing, open the workbook in desktop Excel and use Move or Copy.

What is the difference between copying a sheet and copying all its cells?
Copying a sheet creates a new worksheet tab and is the better choice when you need a whole-sheet duplicate. Copying cells duplicates only a selected range and may not carry sheet-level settings, so it is not equivalent to copying the entire worksheet.

Related

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.