The fastest way: right-click the sheet tab and select Move or Copy

Open both workbooks on your screen. In the workbook that contains the sheet you want to copy, right-click on the sheet tab at the bottom of the window. A menu appears with the option "Move or Copy". Click it.

A dialog box opens asking where you want the sheet to go. Under "Book", select the name of the workbook you're copying to. Under "Before sheet", choose which sheet in the destination workbook you want this one to appear before — or select the last option to put it at the end. Check the box that says "Create a copy" so you keep the original sheet in place. Click OK.

The sheet now exists in both workbooks. All the data, formulas, formatting, and charts copy over exactly as they were. This method takes about 30 seconds and is the one most people should use.

Key Takeaways

  • Right-clicking the sheet tab and selecting "Move or Copy" is the standard method and copies everything — data, formulas, formatting, and charts — in one step.
  • You must check "Create a copy" in the dialog box if you want to keep the original sheet; leaving it unchecked moves the sheet instead of copying it.
  • Both workbooks must be open at the same time for the sheet tab method to work.
  • If you're copying a sheet with external links or complex formulas that reference other sheets, those references may break and need to be fixed manually in the new workbook.
  • Copying a sheet with many rows or columns takes longer, but the process is the same regardless of sheet size.

When both workbooks are not open at the same time

If you can't have both workbooks open together — because one is on another computer, or you're working on a shared file that only one person can edit at a time — you can copy the sheet by saving it as a separate file first.

Open the workbook containing the sheet you want to copy. Right-click the sheet tab, select "Move or Copy", and in the dialog box, under "Book", select "new book". Click OK. Excel creates a new workbook with just that sheet. Save this new workbook with a temporary name. Then open the destination workbook, right-click a sheet tab, select "Move or Copy", choose the temporary workbook from the list, and complete the process. Delete the temporary file when you're done.

This route takes longer but works when you can't have both files open at once.

Copying only the data without formulas

If the sheet contains formulas that reference cells in the original workbook, those formulas will break when you copy the sheet to a new workbook. The new workbook won't have access to the data the formulas were pulling from.

To copy only the values (the results of the formulas, not the formulas themselves), select all the cells in the sheet you want to copy. Press Ctrl+C to copy. Open the destination workbook, right-click the sheet where you want to paste, and select "Paste Special". In the dialog, under "Paste", select "Values" and click OK. This pastes only the numbers and text, not the formulas.

You'll lose the ability to update the data automatically if the source changes, but the numbers themselves will be correct and won't show errors.

Fixing broken links after copying

When you copy a sheet with formulas that reference other sheets in the original workbook, those formulas still point to the old workbook after the copy. In the new workbook, you'll see error messages like #REF! or #NAME? in cells that had formulas.

To fix this, open the destination workbook and look for the broken formulas. Click on a cell showing an error. In the formula bar at the top, you'll see the formula. It probably references the original workbook by name. Edit the formula to reference sheets in the current workbook instead. If the formula was =Sheet1!A1 and you want it to pull from a sheet called "Data" in the new workbook, change it to =Data!A1.

If there are many broken formulas, you can use Find and Replace (Ctrl+H) to change all references at once. Search for the old workbook name and replace it with the new one, but be careful to match the exact syntax Excel uses.

Copying a sheet to a workbook that already has a sheet with the same name

Excel won't let you paste a sheet if a sheet with that exact name already exists in the destination workbook. When you try, you'll get an error message.

The solution is to rename the sheet before copying it. Right-click the sheet tab in the source workbook, select "Rename", and type a new name. Then proceed with the copy. Once the sheet is in the destination workbook, you can rename it again if you want it to match the original name.

Alternatively, you can rename the existing sheet in the destination workbook first, then copy the sheet with its original name.

Copying multiple sheets at once

If you need to copy more than one sheet, you can select them together and copy them all in a single operation. In the source workbook, click the first sheet tab you want to copy. Hold Ctrl and click each additional sheet tab. All selected tabs will highlight. Right-click any of the highlighted tabs and select "Move or Copy". The dialog works the same way, and all selected sheets copy to the destination workbook in the same order they appeared in the original.

This saves time if you're reorganizing data across multiple files or consolidating sheets from several workbooks into one.

What happens to charts, images, and formatting

When you copy a sheet using the right-click method, everything copies: charts, images, conditional formatting, cell colors, fonts, borders, and column widths. The new sheet looks identical to the original.

The one exception is external images or objects that are linked to files outside the workbook. If the sheet contains an image that's linked to a file on your computer, that link may break in the new workbook if the file path is different. You'll see a broken image placeholder instead. To fix it, right-click the image, select "Change Picture", and point to the file in its new location.

Conditional formatting rules (like "highlight cells if the value is greater than 100") copy over and continue to work in the new workbook, as long as the rules reference cells within the sheet itself and not cells in other sheets.

Frequently Asked Questions

Does copying a sheet also copy the data validation rules I set up?

Yes. Data validation rules (like dropdown lists or restrictions on what numbers can be entered) copy along with the sheet. If the validation rule references cells in the original workbook, you may need to update those references in the new workbook so the validation points to the correct cells.

Can I copy a sheet from a workbook that's open in a different program, like Google Sheets?

Not directly using the right-click method. You'll need to read the Google Sheet as an Excel file first, then open it in Excel. After that, you can copy the sheet using the standard method. Alternatively, you can select all the data in Google Sheets, copy it, and paste it into a new sheet in your Excel workbook, though this won't preserve all formatting.

What if the sheet I'm copying is very large and the copy seems to be stuck?

Large sheets with thousands of rows or complex formulas take longer to copy. Wait a few minutes before assuming something went wrong. If Excel is truly frozen (not responding), you can force it to close and try again. To speed up the process next time, consider copying only the data you need rather than the entire sheet.

Will copying a sheet also copy the print settings and page layout?

Yes. Page orientation, margins, print area, headers, and footers all copy to the new sheet. If you want different print settings in the copied sheet, you can change them after the copy is complete by going to the Page Layout tab and adjusting the settings.

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

Yes. Press Ctrl+Z when ready after copying to undo the operation and remove the sheet from the destination workbook. This works as long as you haven't saved the destination workbook yet. If you've already saved, you'll need to delete the sheet manually by right-clicking its tab and selecting "Delete Sheet".