Can You Duplicate an Excel Sheet? Yes, Here’s How

How-to basics · Updated November 21, 2026

Yes. In Excel for Microsoft 365 on Windows, right-click the worksheet tab, choose Move or Copy, select where to place the copy, check Create a copy, and click OK. You can also hold Ctrl while dragging a sheet tab to copy it within the same workbook.

How to duplicate a sheet in the same workbook

The Move or Copy command is the clearest method because it lets you choose the copy’s position and makes the copy operation explicit. Keep the workbook open, then follow these steps:

  1. Right-click the tab of the worksheet you want to duplicate.
  2. Choose Move or Copy. Alternatively, use Home > Format > Move or Copy Sheet.
  3. In the dialog box, choose the current workbook in the To book list.
  4. Under Before sheet, select where the new sheet should appear.
  5. Check Create a copy, then select OK.

Excel adds a separate worksheet, usually with a name such as Sales (2). You can rename it by double-clicking the new tab, typing a name, and pressing Enter. Sheet names must be unique in a workbook and cannot exceed 31 characters.

For a quick copy beside the original, hold Ctrl and drag the sheet tab to a new position, then release the mouse button before releasing Ctrl. If you drag without holding Ctrl, you move the sheet rather than copy it. The dialog method is less prone to that mistake and is more useful when the copy needs to go in a particular place.

Copying a sheet to another workbook

You can use the same dialog to copy a worksheet into another open workbook. Right-click the tab, select Move or Copy, choose the destination workbook in To book, select a position under Before sheet, check Create a copy, and click OK. To put the sheet in a new workbook, select (new book) in the destination list. Excel creates a workbook containing the copied sheet.

When copying between workbooks, consider whether the sheet depends on other sheets, named ranges, or data sources in the original file. For example, a copied Summary sheet might contain formulas that refer to a Data sheet. If Data is not also available in the destination, the formulas may continue to refer to the original workbook or show errors, depending on the references and what was copied. Check the copied sheet before relying on it, and copy related sheets too when the destination needs them.

If the destination workbook is not listed, open it first. Also check the workbook’s file format and save it in an appropriate format. A workbook saved as a macro-enabled file can retain VBA content, whereas saving as a standard .xlsx file does not preserve VBA macros.

What a worksheet copy includes

A duplicated sheet is more than a fresh blank grid with the same values. Excel generally copies the worksheet’s contents and many of its sheet-level settings, which can make duplication useful for creating a new month, department, or scenario from an existing layout. Depending on what the sheet contains, a copy can include:

  • Cell values, formulas, formatting, comments or notes, and hyperlinks.
  • Row heights, column widths, hidden rows or columns, and freeze panes.
  • Tables, charts, shapes, images, data validation, and conditional formatting.
  • Page layout settings, print areas, and page breaks.

Still, do not assume every workbook feature behaves independently after copying. Some names and connections apply at workbook level, and Excel may adjust or rename certain items to avoid conflicts. A copied table, for example, needs a unique table name in the same workbook; Excel may assign one automatically. Review important charts, tables, validation lists, and print settings after duplication, especially in a workbook used for reporting or printing.

How formulas and links behave

Duplicating a sheet does not automatically create a fully independent version of every reference it contains. Formulas that refer to cells on the copied sheet can behave differently from formulas that point to another worksheet or an external workbook. A formula on a copied report that refers to a separate Inputs sheet may still refer to that same Inputs sheet, rather than a newly copied version of Inputs.

That distinction matters when using a template. Suppose a workbook has January and February sheets, plus a shared Rates sheet. If you copy January to create March, the new sheet may still use Rates as its source. That is often exactly what you want. If each month should instead use its own set of assumptions, you may need to copy those assumption sheets too and inspect or update the formulas.

After copying, click representative formula cells and inspect the formula bar. Check formulas that reference other sheets, named ranges, external files, or data connections. Also look for warnings about links when opening the destination workbook. A copied sheet can preserve a link to the original file; duplicating the worksheet does not automatically make external data local.

When to duplicate, move, or copy cells

These operations sound similar but serve different purposes. Choose based on whether you need another worksheet, a relocated worksheet, or only a portion of its contents.

  • Duplicate a sheet: Use Move or Copy with Create a copy checked, or Ctrl-drag the tab. The original remains in place.
  • Move a sheet: Use Move or Copy without checking Create a copy. The sheet leaves its current position or workbook.
  • Copy cells: Select a range, press Ctrl+C, and paste it elsewhere. This copies cell content and formatting, not the entire worksheet structure or tab.
  • Create a new sheet from scratch: Insert a blank worksheet when you need a clean layout rather than a replica.

Copying a range is useful when you need a table or a block of values but not the original sheet’s print settings, hidden columns, charts, or other objects. Conversely, duplicating a whole sheet can bring along material you did not intend to reuse. Decide what the destination needs before choosing the method.

Common problems and how to fix them

If Move or Copy is unavailable or Excel will not complete the operation, check whether the workbook structure is protected. Workbook-structure protection can restrict adding, moving, deleting, hiding, or renaming sheets. If you have permission and the password, use Review > Protect Workbook to turn off the protection, then try again. Do not try to bypass a password; ask the file owner if you do not have authorization.

Other issues are usually caused by references, names, or the destination workbook:

  • The sheet moved instead of copied: Repeat the operation and make sure Create a copy is checked. With Ctrl-drag, keep Ctrl held while dragging.
  • The new sheet has an unexpected name: Excel may add a number because the original name is already in use. Rename the copy after checking that the new name is unique.
  • Formulas show errors or old values: Check references to other sheets, named ranges, external workbooks, and data connections. A copied sheet does not guarantee that all dependencies were copied or refreshed.
  • A chart or dropdown behaves differently: Inspect its data source or validation list. It may point to a range or name that remains on the original sheet.
  • The copy command fails in a shared file: Save or make a personal copy if appropriate, and check whether permissions, workbook protection, or simultaneous editing is limiting changes.

For an important workbook, save a separate copy before reorganizing sheets or changing links. That gives you a recovery point if the copied sheet relies on unexpected references or the result is not what you intended.

Excel for Mac and Excel for the web

In Excel for Mac, right-click or Control-click the worksheet tab and choose Move or Copy; the dialog’s options are similar, although the interface can vary slightly by release. Option-dragging a sheet tab can also copy it in many Mac versions. If the gesture is awkward or uncertain, use the dialog and check Create a copy.

In Excel for the web, the sheet-tab context menu may offer Duplicate. Choose that option to make a copy in the current workbook. Web features and menus can change, and some desktop workbook operations are not available in every browser experience. If you need to move a sheet between workbooks or manage complex workbook features, open the file in the desktop application and use Move or Copy.

Frequently Asked Questions

Can I duplicate an Excel sheet without changing the original?
Yes. Use Move or Copy and check Create a copy, or Ctrl-drag the tab on Windows. Excel creates another worksheet while leaving the original in the workbook.

Can I duplicate a sheet into a new Excel file?
Yes. In the Move or Copy dialog, choose (new book) in To book, check Create a copy, and click OK. Review the new file for formulas or links that still depend on the original workbook.

Does duplicating a sheet copy its formulas?
Yes, formulas on the sheet are copied. However, references to other worksheets, named ranges, or external workbooks may still point to their existing sources, so inspect dependencies if the copy must work independently.

Why can’t I move or copy a worksheet?
Workbook-structure protection, file permissions, or restrictions in a shared or browser-based workbook can prevent the operation. Check protection and access with the workbook owner, or try the desktop app if the web version does not offer the needed command.

What is the difference between duplicating a sheet and copying cells?
Duplicating creates a new worksheet and generally carries its layout and sheet-level content. Copying cells transfers only the selected range, so it does not reproduce the entire worksheet or its tab-level settings.

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.