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 Create a copy, pick where you want the new sheet to land in your file (before or after an existing sheet), and click OK. Excel duplicates the entire sheet — all formulas, formatting, and data — in seconds.
This method copies everything on the sheet exactly as it appears. If the original sheet has formulas that reference other sheets in the same file, those references stay intact and point to the same places. If you want the copy to reference different sheets instead, you will need to edit those formulas after copying.
The right-click menu also lets you move a sheet without copying it, which removes it from its current position and places it elsewhere. Moving is useful when you have reorganized your thinking about how sheets should be ordered; copying is what you use when you want to keep the original and have a duplicate to modify.
Key Takeaways
- Right-click the sheet tab and select Move or Copy to duplicate an entire sheet with all its data and formatting in one step.
- When you copy a sheet, formulas that reference other sheets in the same file continue to point to those same sheets in the copy.
- You can copy a sheet to a different Excel file by selecting that file from the dialog box, but the new file must already be open in Excel.
- If you only need to copy specific cells or a range rather than the whole sheet, select those cells, press Ctrl+C (or Cmd+C on Mac), and paste them into the destination.
Copying a sheet to a different Excel file
Open both the file you are copying from and the file you want to copy to in Excel. Right-click the sheet tab you want to copy, select Move or Copy, and in the dialog box, use the dropdown under "To book" to select the destination file. Choose Create a copy, pick the position, and click OK.
Both files must be open for this to work. If the destination file is not listed in the dropdown, open it first, then return to the source file and try again. When the copy is complete, switch to the destination file to verify the sheet arrived with all its content intact.
What happens to formulas when you copy a sheet
Formulas that reference cells within the same sheet adjust automatically when you copy. If the original sheet has a formula in cell B2 that adds A1 and A2, the copy will have the same formula in B2 that adds the copy's A1 and A2. The relative references shift with the copy.
Formulas that reference other sheets in the same file stay pointed at those other sheets. If your original sheet has a formula that says =Sheet2!A1, the copied sheet will also reference Sheet2!A1, not a copy of Sheet2. This is usually what you want — you are duplicating one sheet, not the entire workbook. If you need the copy to reference different sheets, you will need to edit those formulas by hand after copying.
When you copy a sheet to a different file, formulas that reference other sheets in the original file will break in the copy, because those other sheets do not exist in the new file. You will see a #REF! error in those cells. Plan ahead: if you need a sheet with working formulas in a new file, copy the sheets it depends on as well, or rewrite the formulas to work without external references.
Copying just part of a sheet instead of the whole thing
If you only need certain cells, rows, or columns rather than the entire sheet, select what you want, press Ctrl+C (Windows) or Cmd+C (Mac), then click where you want to paste and press Ctrl+V or Cmd+V. This copies the data and formatting but leaves the sheet structure alone.
When you paste, Excel gives you options. A small icon appears near the pasted cells with a dropdown arrow. Click it to choose whether to paste values only (numbers and text, no formulas), formulas only, formatting only, or everything. This is useful when you want to copy data from one sheet to another but do not want the formulas to recalculate based on the new location.
Renaming the copied sheet
Excel names the copy by adding a number to the original name. If your sheet is called "Sales Data", the copy becomes "Sales Data (2)". If you copy again, the next one is "Sales Data (3)". You can rename it when ready after copying or any time later.
Right-click the sheet tab and select Rename, or double-click the tab itself. Type the new name and press Enter. Sheet names can include spaces and most characters, but Excel does not allow pipe symbols (|), question marks (?), asterisks (*), or forward slashes (/) in sheet names. If you try to use one of these, Excel will reject the name and ask you to choose again.
Undoing a copy if you change your mind
Press Ctrl+Z (Windows) or Cmd+Z (Mac) when ready after copying to undo it. The copied sheet disappears and you are back to your original state. You can undo multiple times to step back through your recent actions.
If you have made other changes since copying and want to remove only the copied sheet without undoing everything else, right-click the sheet tab and select Delete. Excel will ask you to confirm. This is safer than undo if you have done other work in between.
When copying a sheet is better than other methods
Copying a sheet is the right choice when you want to reuse a structure — the same columns, headers, formulas, and layout — but with new data. It is faster than building the sheet from scratch and less error-prone than trying to recreate formulas by hand.
If you only need to move data around without keeping the original, use move instead of copy. If you need to combine data from multiple sheets into one, copying individual sheets is not the right tool — you would instead select and copy specific ranges, or use a pivot table if you need to summarize. If you are trying to back up your work, copying a sheet within the same file does not protect you; save a separate copy of the entire file instead.
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 for the Move or Copy dialog to show the destination file in its dropdown. If you only have the source file open, you can still copy the sheet, but you will have to paste it into the destination file manually after opening that file.
What if the sheet I want to copy has charts or images?
Charts, images, and other objects copy along with the sheet. They keep their size, position, and formatting. If a chart references data on the original sheet, the copy's chart will reference the copy's data instead, so the chart will update if you change numbers in the copied sheet.
Does copying a sheet also copy the sheet's print settings?
Yes. Page size, margins, headers, footers, and print area all copy to the new sheet. If you do not want the same print settings on the copy, right-click the sheet tab, select Sheet, then Page Setup, and adjust them.
Can I copy a sheet from an older Excel file format to a newer one?
Yes. Open both files in Excel, use Move or Copy to duplicate the sheet into the newer file, and save. Excel handles the format conversion automatically. The sheet will work in the new file format without extra steps.
What is the difference between copying a sheet and copying all the cells in a sheet?
Copying the sheet itself preserves the sheet as a separate tab with its own name and structure. Copying all cells and pasting them into a new sheet copies only the data and formatting, not the sheet object itself. Sheet copying is faster and cleaner when you want a complete duplicate; cell copying is better when you want to paste into an existing sheet or rearrange the data as you paste.