The fastest way to copy a sheet between workbooks

Open both the source workbook (the one with the sheet you want to copy) and the destination workbook (where you want it to go) so you can see them side by side. Right-click the sheet tab at the bottom of the source workbook, select Move or Copy, choose the destination workbook from the dropdown, pick where in that workbook you want the sheet to land, check the box that says Create a copy, and click OK. The sheet and all its data, formulas, and formatting copy over intact.

If you only have one workbook open, you can still copy the sheet — Excel will let you create a new workbook to hold it, or you can open the destination workbook first and then perform the same steps. The sheet tab method works the same way regardless.

Key Takeaways

  • Right-click the sheet tab at the bottom of your workbook and select Move or Copy to access the copy dialog without using menus.
  • The destination workbook must be open in Excel before you can copy a sheet to it, or you can let Excel create a new workbook.
  • Copying a sheet preserves all data, formulas, formatting, and charts — nothing is lost or flattened in the transfer.
  • If you move a sheet instead of copying it, the original sheet is deleted from the source workbook, so use the Create a copy checkbox to keep both.

Opening both workbooks at once

Before you copy, have both files open in Excel. Open the source workbook first, then open the destination workbook — you can do this by going to File > Open and navigating to the file, or by double-clicking the file in Windows Explorer or Finder. Once both are open, you can switch between them using the taskbar (on Windows) or the Window menu in Excel.

If you want to see both workbooks on screen at the same time, go to the View tab and select Arrange All or View Side by Side. This splits your screen so you can watch the sheet appear in the destination workbook as soon as the copy finishes. This step is optional — the copy works the same whether you can see both windows or not.

Right-clicking the sheet tab and using the dialog

At the bottom of your Excel window, you will see tabs with sheet names — usually Sheet1, Sheet2, and so on, unless you renamed them. Right-click the tab of the sheet you want to copy. A menu appears with options including Insert, Delete, Rename, and Move or Copy. Click Move or Copy.

A dialog box opens with two key choices. The first is a dropdown labeled To book — click it and select the destination workbook from the list of open files. The second is a list showing where in that workbook the sheet will land. Click the sheet name or position where you want the copy to appear — if you want it at the end, click the last sheet in the list. Then check the box that says Create a copy. If you do not check this box, Excel will move the sheet instead, removing it from the source workbook. Click OK.

What happens if the destination workbook is not open

If you start the copy process and the workbook you want is not open, the To book dropdown will show only the current workbook and any others you have open. You have two choices: cancel the dialog, open the destination workbook, and start over, or let Excel create a new workbook to hold the copy.

Creating a new workbook is useful if you want to send the sheet to someone else or store it separately. After the copy finishes, you can save the new workbook with a name of your choice. If you need the sheet in a specific existing file, it is faster to cancel, open that file, and redo the copy — it takes only a few seconds.

Checking that formulas and links copied correctly

When you copy a sheet, Excel copies the formulas as they are. If a formula in the source sheet refers to another sheet in the same workbook (like =Sheet2!A1), that reference comes along. If the destination workbook does not have a sheet with that name, the formula will show an error until you create the missing sheet or update the formula to point to the right place.

Open the copied sheet and scan a few cells with formulas to make sure they still calculate correctly. If you see #REF! errors, it means a formula is looking for a sheet or cell that does not exist in the destination workbook. You can fix these by editing the formula or by copying the sheets that the formulas depend on as well.

Copying multiple sheets at once

If you need to copy more than one sheet, you can select them together before copying. Hold Ctrl (on Windows) or Command (on Mac) and click each sheet tab you want to copy. All selected tabs will highlight. Then right-click any of the selected tabs, choose Move or Copy, and follow the same steps. Excel will copy all of them to the destination workbook in the order they were selected.

This is faster than copying sheets one at a time, especially if the sheets are related or if you want to preserve the structure of your workbook. After the copy finishes, check that all sheets arrived and that any formulas linking between them still work.

Frequently Asked Questions

Will copying a sheet break any formulas that reference it?

No. Formulas in other sheets that reference the copied sheet will still point to the original sheet in the source workbook. The copy is independent. If you want formulas in the destination workbook to reference the copied sheet, you will need to update those formulas manually or recreate them.

Can I copy a sheet to a workbook that is not open?

Not directly through the Move or Copy dialog. You must open the destination workbook first, or let Excel create a new one. If you need to copy to a file that is not currently open, open it before starting the copy process.

What if the sheet name already exists in the destination workbook?

Excel will rename the copied sheet automatically by adding a number to the end — so Sales becomes Sales_2. You can rename it afterward by right-clicking the tab and selecting Rename. Type the new name and press Enter.

Does copying a sheet include charts and images?

Yes. Charts, images, shapes, and all other objects on the sheet copy along with the data and formatting. Everything that appears on the sheet transfers to the destination workbook.

Can I undo a sheet copy if I change my mind?

Yes. Press Ctrl+Z (or Command+Z on Mac) when ready after the copy finishes to undo it. The sheet will disappear from the destination workbook and return to the source only. This works as long as you have not saved the destination workbook yet.