The fastest way to duplicate a sheet

Right-click the sheet tab at the bottom of your Excel window and select Move or Copy. A dialog box opens. Check the box that says Create a copy, then click OK. Excel creates an exact duplicate of the sheet with all formulas, formatting, and data intact, and names it with "(2)" at the end — so "Sales" becomes "Sales (2)".

This method takes five seconds and works the same way whether you are using Excel on Windows, Mac, or the web version. The duplicate appears right next to the original sheet, which you can then rename or move to a different position in your workbook.

If you prefer not to use the right-click menu, you can also hold down Alt (on Windows) or Option (on Mac) while dragging the sheet tab to a new position. This also creates a copy instead of moving the original.

Key Takeaways

  • Right-click the sheet tab and choose Move or Copy, then check Create a copy to duplicate the entire sheet in seconds.
  • The copied sheet includes all data, formulas, and formatting from the original, so you do not have to rebuild anything.
  • Excel automatically names the copy with "(2)" at the end, but you can rename it when ready by right-clicking the tab and selecting Rename.
  • You can position the copy anywhere in your workbook by selecting where it should go before clicking OK in the dialog box.
  • Holding Alt or Option while dragging a sheet tab also creates a copy, which is faster if you already know where you want it to go.

When you need to copy a sheet instead of just referencing it

Copying a sheet is useful when you want to test changes without affecting the original data. For example, if you have a budget sheet that works correctly, you might copy it to create next month's budget without starting from scratch. The formulas stay the same, so you only need to change the numbers.

Copying is also the right move when you are building a template for repeated work. Create one sheet with all the formatting and formulas you need, copy it multiple times, and then fill in different data on each copy. This is faster and more consistent than building each sheet individually.

Do not copy a sheet if you only need to reference data from another sheet. Instead, use a formula that points to the other sheet — for example, =Sheet1!A1 pulls the value from cell A1 on Sheet1. This way, if the original data changes, your formula automatically updates.

Renaming the copied sheet

After you copy a sheet, Excel names it with "(2)" appended to the original name. You should rename it to something that describes what it contains, especially if you plan to copy the same sheet multiple times.

Right-click the sheet tab and select Rename. The tab becomes editable — type the new name and press Enter. Keep names short and descriptive: "Budget 2024", "Test Version", or "Q2 Sales" are all clear. Avoid names with special characters like asterisks or question marks, because Excel will not accept them.

Copying a sheet to a different workbook

If you want to copy a sheet to a completely different Excel file, the process is slightly different. Right-click the sheet tab and select Move or Copy. In the dialog box, look for the dropdown that says To book and select the other workbook from the list. If the workbook is not open, you will need to open it first.

Check Create a copy, choose where in the destination workbook you want the sheet to appear, and click OK. The sheet is copied with all its data and formulas. This is useful when you are consolidating work from multiple files or sharing a template with someone else.

What happens to formulas when you copy a sheet

All formulas copy exactly as they are, but Excel adjusts any references that point to cells on the same sheet. For example, if the original sheet has a formula that adds up column A, the copied sheet will have the same formula structure but will reference column A on the copy, not the original.

Formulas that reference other sheets stay the same. If your original sheet has a formula like =Sheet2!B5, the copy will still point to Sheet2, not to itself. This is usually what you want, but if you need the copy to reference itself instead, you will need to edit those formulas manually after copying.

Charts, pivot tables, and conditional formatting all copy along with the sheet. If a chart is based on data in that sheet, the copy will have a chart based on the copied data, which is usually correct. Test your formulas and charts after copying to make sure they are calculating what you expect.

Copying multiple sheets at once

If you need to copy more than one sheet, you can select them together and copy them all at the same time. Hold Ctrl (on Windows) or Command (on Mac) and click each sheet tab you want to copy. All selected tabs highlight.

Right-click any of the selected tabs and choose Move or Copy. Check Create a copy and click OK. Excel copies all the selected sheets together, in the same order, with the same relationships between them. This is faster than copying sheets one at a time if you have a set of related sheets that need to be duplicated.

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 (on Windows) or Command+Z (on Mac) to undo. This removes the copied sheet and returns your workbook to its previous state. Undo works as long as you have not made other changes since the copy.

If you have already made changes and want to remove the copy later, right-click the sheet tab and select Delete. Excel asks you to confirm. Click Delete again and the sheet is removed. You cannot undo a deletion after you confirm it, so make sure you do not need the sheet before you delete it.

Frequently Asked Questions

Can I copy a sheet that has external data connections?

Yes, the sheet copies with its data connections intact. If the original sheet pulls data from an external source, the copy will try to pull from the same source. Test the copy to make sure the connection works, because sometimes external sources have limits on how many connections they allow.

What if I copy a sheet and the formulas break?

Formulas usually copy correctly, but if they reference cells outside the sheet in a way that does not translate, you may need to edit them. Open the copied sheet, click a cell with a formula, and look at the formula bar to see what it is referencing. If it points to the wrong place, edit it manually or use Find and Replace to fix multiple formulas at once.

Does copying a sheet also copy the sheet's print settings?

Yes, print settings copy along with everything else. If the original sheet has custom margins, page breaks, or a specific print area, the copy will have the same settings. You can change them on the copy without affecting the original.

Can I copy a sheet from a read-only workbook?

You can copy the sheet, but you cannot save the copy unless you save the workbook with a new name. If the workbook is read-only, Excel will not let you make permanent changes. Save the file as a new workbook first, then copy the sheet within that new file.

What is the difference between copying a sheet and copying all the data in a sheet?

Copying a sheet duplicates the entire sheet tab with all its formatting, formulas, and structure. Copying all the data means selecting every cell and pasting it somewhere else, which loses the sheet structure and can break formulas. Copying the sheet is almost always the better choice because it preserves everything.