The fastest way to copy a sheet

Right-click the sheet tab at the bottom of your Excel window and select Move or Copy. A dialog box opens. Choose where you want the copy to go — either in the same workbook (under "Before sheet") or in a different workbook (under "To book"). Check the box that says Create a copy, then click OK. Excel duplicates the entire sheet with all its data, formulas, and formatting in seconds.

If you do not see sheet tabs at the bottom, your window may be too narrow. Drag the divider between the sheet tabs and the horizontal scroll bar to the right to make more room. The tabs should appear.

This method copies everything on the sheet — cells, charts, conditional formatting, data validation rules, and all. If you only need certain cells, use a different approach (covered below).

Key Takeaways

  • Right-click a sheet tab and select Move or Copy to duplicate an entire sheet in seconds, keeping all data and formatting intact.
  • The Create a copy checkbox is what makes Excel duplicate the sheet instead of moving it; leaving it unchecked moves the original instead.
  • You can copy a sheet to a different workbook by selecting it from the "To book" dropdown, but both files must be open in Excel first.
  • If you only need specific cells from a sheet, select them, copy with Ctrl+C, and paste into a new sheet rather than copying the entire sheet.
  • Excel names copied sheets with a number in parentheses — Sheet (2), Sheet (3) — which you can rename by right-clicking the tab and selecting Rename.

Copying to a different workbook

Both Excel files must be open at the same time. Open the file that contains the sheet you want to copy, then open the file where you want the copy to go. Right-click the sheet tab in the source file and select Move or Copy. In the dialog, click the "To book" dropdown and select the name of the destination file. Choose where in that file the copy should appear, check Create a copy, and click OK.

If the destination file does not appear in the dropdown, close the dialog, make sure both files are open, and try again. Excel only lists files that are currently running.

The copied sheet keeps its original name. If the destination file already has a sheet with that name, Excel adds a number to avoid confusion — so "Sales" becomes "Sales2".

Renaming a copied sheet

After copying, the new sheet usually has a name like "Sheet (2)" or "Sales2". Right-click the sheet tab and select Rename. Type the new name and press Enter. The name can be up to 31 characters and can include spaces, but cannot include forward slashes, backslashes, question marks, asterisks, or colons.

If you copy the same sheet multiple times, each copy gets a new number automatically. Renaming them helps you remember which is which — for example, "Sales Draft" and "Sales Final" instead of "Sales2" and "Sales3".

Copying only specific cells instead of the whole sheet

If you need only certain data from a sheet, copying the entire sheet wastes space. Instead, select the cells you want. Click the first cell, hold Shift, and click the last cell in the range you need. Or click a cell, type the range into the Name Box (the field showing the cell address on the left side of the formula bar), and press Enter.

Press Ctrl+C to copy the selection. Click the sheet where you want to paste, click the cell where the data should start, and press Ctrl+V. The cells paste with their formatting and formulas intact. If you want only the values without formulas, right-click after pasting and select Paste Special, then choose Values.

This approach is faster than copying an entire sheet when you only need part of it, and it keeps your workbook smaller.

What happens to formulas when you copy a sheet

Formulas copy exactly as they are. If a formula refers to cells in the original sheet (like =A1+B1), the copied sheet's formula still points to those same cells in the original sheet, not to the copied cells. This is usually what you want — both sheets reference the same source data.

If you want the copied sheet's formulas to point to cells within the copied sheet instead, you have two options. First, you can manually edit the formulas in the copied sheet after copying. Second, you can copy only the cells you need (not the entire sheet), paste them into a new sheet, and then adjust the formulas. For most uses, the default behavior is correct and requires no action.

Undoing a copy you did not mean to make

Press Ctrl+Z when ready after copying. Excel removes the new sheet and returns to the state before you copied. If you have already made other changes since copying, undo may remove those changes too — you can redo them afterward by pressing Ctrl+Y.

If you closed the file after copying and want to undo, reopen the file and press Ctrl+Z. Excel remembers the last several actions even after closing, as long as you have not saved. If you have saved the file, the undo history is gone and you will need to delete the copied sheet manually by right-clicking its tab and selecting Delete.

Copying a sheet with charts, images, or other objects

The Move or Copy method copies everything — charts, images, text boxes, buttons, and embedded objects all come along. Formatting like cell colors, borders, and font styles also copies. The only things that do not copy are hidden rows and columns; they remain hidden in the copied sheet.

If a chart in the original sheet is linked to cells outside the sheet, the copied chart still points to those same external cells. If you want the copied chart to reference cells in the copied sheet instead, you will need to edit the chart's data range after copying. Right-click the chart, select Select Data, and change the range to point to the copied sheet's cells.

Frequently Asked Questions

Can I copy a sheet from one Excel file to another without opening both files?

No, both files must be open in Excel at the same time. Open the source file first, then open the destination file. If you try to copy without both open, the destination file will not appear in the "To book" dropdown.

What is the difference between Move and Copy?

Move removes the sheet from the original location and places it in the new one. Copy leaves the original sheet where it is and creates a duplicate elsewhere. The Move or Copy dialog has a checkbox for "Create a copy" — check it to copy, leave it unchecked to move.

Why does my copied sheet have a different name than the original?

Excel automatically names copies with a number in parentheses or as a suffix to avoid duplicate names. You can rename it by right-clicking the sheet tab, selecting Rename, and typing a new name.

If I copy a sheet, do the formulas update to the new sheet?

No, formulas in the copied sheet still reference cells in the original sheet. If you want formulas to point to cells within the copied sheet, you must edit them manually after copying, or use Paste Special with Values and rebuild the formulas.

Can I copy multiple sheets at once?

Yes. Hold Ctrl and click each sheet tab you want to copy. Right-click one of the selected tabs and choose Move or Copy. The dialog will copy all selected sheets together in the same order.