The fastest way to copy a sheet in Excel

Right-click the sheet tab at the bottom of your workbook and select Move or Copy. A dialog box opens. Check the box that says Create a copy, choose where you want the copy to appear in your workbook (before or after an existing sheet), and click OK. Excel creates an exact duplicate with the name of the original sheet plus "(2)" — so "Sales Data" becomes "Sales Data (2)".

This method copies everything: all formulas, formatting, data, and charts. The copy is independent, so changes to one sheet do not affect the other. If you have many sheets, this is faster than selecting all content and pasting it into a new sheet, because you do not have to recreate the sheet structure yourself.

You can also right-click and choose Insert Sheet, then manually copy the content, but the Move or Copy method is simpler and less error-prone.

Key Takeaways

  • Right-click the sheet tab and select Move or Copy, then check Create a copy to duplicate the entire sheet in one step.
  • The copied sheet includes all data, formulas, formatting, and charts from the original.
  • Excel automatically names the copy with "(2)" appended, so you can rename it afterward if needed.
  • The copy is completely separate from the original, so editing one does not change the other.
  • You can choose exactly where the copy appears in your workbook — before or after any existing sheet.

Renaming the copied sheet

After Excel creates the copy, you will probably want to give it a more descriptive name than "Sales Data (2)". Right-click the new sheet tab and select Rename Sheet. Type the new name and press Enter. Sheet names can be up to 31 characters and can include spaces and most punctuation, though you cannot use forward slashes, backslashes, question marks, asterisks, or square brackets.

If you plan to copy a sheet multiple times, consider naming the original sheet something clear before you start — like "Sales Data Template" — so you know which one is the source and which ones are copies.

Copying a sheet to a different workbook

The Move or Copy dialog also lets you copy a sheet into a completely different Excel file. Open both workbooks (the one with the sheet you want to copy and the one where you want it to go). Right-click the sheet tab in the source workbook and select Move or Copy. In the dialog, use the dropdown that says To book and select the name of the destination workbook. Choose where in that workbook the copy should appear, check Create a copy, and click OK.

This is useful when you are building a summary workbook from multiple source files, or when you want to reuse a sheet structure (like a template with formulas already in place) across different projects. The copy includes all formatting and formulas, so if the original sheet references other sheets in its workbook, those references will still point to the original workbook, not the new one.

What happens to formulas when you copy a sheet

When you copy a sheet, Excel preserves all formulas exactly as they are. If a formula on the original sheet refers to another sheet in the same workbook — like =SUM(Totals!A1:A10) — the copy will keep that same reference. This means the copied sheet will pull data from the same source sheets as the original.

If you want the copied sheet to reference itself instead of the original sheets, you will need to edit those formulas manually after copying. Select the cells with formulas, press Ctrl+H to open Find and Replace, and update the sheet references. For example, change Totals! to Totals (2)! if you also copied the Totals sheet.

For most uses, keeping the original references is what you want — it means the copy automatically shows the same calculations based on the same source data.

Copying multiple sheets at once

If you need to copy several sheets, you can select them all before using Move or Copy. Hold Ctrl and click each sheet tab you want to copy. Then right-click any of the selected tabs and choose Move or Copy. Excel will copy all of them to the location you specify, in the same order they appeared in the original workbook.

This saves time when you are reorganizing a workbook or creating multiple versions of the same structure. The copied sheets will be named with "(2)", "(3)", and so on, so rename them afterward to keep your workbook organized.

Undoing a copy if you made a mistake

If you copy a sheet and when ready realize you did not want to, press Ctrl+Z to undo. This removes the copied sheet and returns your workbook to its previous state. You can undo multiple times if you need to go back several steps.

If you have already saved the workbook after copying, you cannot undo through the normal undo function. Instead, close the file without saving, reopen it, and the copy will be gone. If you have already saved and want to keep the file, you will need to right-click the copied sheet tab and select Delete Sheet to remove it manually.

When to copy a sheet instead of creating a new one

Copy a sheet when you want to reuse its structure, formatting, or formulas. This is faster than building a new sheet from scratch, especially if the original has complex formatting, multiple columns with specific widths, or formulas that reference other parts of the workbook.

Create a new blank sheet instead when you are starting something completely different and do not need any of the original sheet's content or structure. Right-click any sheet tab, select Insert Sheet, and choose Blank sheet. This is quicker than copying and then deleting all the content you do not need.

Frequently Asked Questions

Can I copy a sheet from one Excel file to another without opening both at the same time?

No, you need both files open. Open the source file and the destination file, then use the Move or Copy dialog to select the destination workbook from the dropdown. If the destination file is not listed, make sure it is actually open in Excel.

Does copying a sheet also copy the sheet's tab color?

Yes. If the original sheet tab is colored, the copied sheet tab will have the same color. You can change the tab color by right-clicking the sheet tab, selecting Sheet Tab Color, and choosing a new color.

What if the sheet I want to copy has external links to other files?

The copy will keep those same external links. If you copy the sheet to a different workbook and then move or delete the linked file, the copy will show error values. Update the links manually by going to Data > Edit Links and pointing them to the correct file location.

Can I copy just part of a sheet instead of the whole thing?

The Move or Copy function copies the entire sheet. To copy only certain cells, select them, press Ctrl+C, create a new sheet or navigate to an existing one, and press Ctrl+V. This gives you more control over what gets copied.