The fastest way to copy a sheet in Excel
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 — in the same file or a different one — and check the box that says Create a copy. Click OK. The sheet duplicates with all its data, formulas, and formatting intact.
This method works the same way in Excel on Windows, Mac, and in Excel Online. The sheet tab is the small labeled area at the very bottom of your spreadsheet, where it says "Sheet1" or whatever you named it. If you don't see tabs, your file has only one sheet, and the tab area is hidden until you add another one.
You can also copy a sheet by right-clicking and selecting Copy, then right-clicking an empty area next to the sheet tabs and selecting Paste Special — but the first method is simpler and does the same thing in one step.
Key Takeaways
- Right-click the sheet tab at the bottom, select Move or Copy, check Create a copy, and choose your destination in one dialog.
- The copied sheet includes all data, formulas, and cell formatting — nothing is left behind.
- You can copy a sheet into the same file, into a different Excel file that is already open, or into a new file you create during the process.
- Renaming the copied sheet when ready after creation helps you keep track of which version is which.
Copying a sheet to a file that is already open
Open both Excel files side by side — the one with the sheet you want to copy and the one where you want it to go. Right-click the sheet tab you want to copy, select Move or Copy, and in the dialog box, look for the dropdown that says To book. Select the name of the destination file from that list. Check Create a copy, choose which sheet you want it to appear before or after, and click OK.
Excel needs both files to be open for this to work. If the destination file is closed, you will see only the current file listed in the dropdown. Open the destination file first, then return to the source file and try again.
Copying a sheet to a brand new file
Right-click the sheet tab and select Move or Copy. In the dialog, look at the To book dropdown and select (new book) at the bottom of the list. Check Create a copy and click OK. Excel creates a new file with only that sheet in it, and the new file opens automatically.
The new file is unsaved. You will see an asterisk (*) in the title bar next to the filename, which means there are unsaved changes. Save it right away by pressing Ctrl+S (Windows) or Command+S (Mac), then give it a name and choose where to store it.
What happens to formulas and links when you copy a sheet
Formulas copy exactly as they are. If your original sheet has a formula that adds up cells in another sheet — for example, =SUM(Sheet2!A1:A10) — the copied sheet will have the same formula pointing to the same cells in Sheet2. This is usually what you want, but it means both sheets are still connected.
If you copy a sheet to a different file and that file does not have the sheet the formula refers to, Excel will show an error. For example, if you copy a sheet that references Sheet2 to a new file that has no Sheet2, the formula breaks. You can fix this by editing the formula to point to the correct sheet, or by copying the referenced sheet as well.
Formatting — colors, fonts, column widths, borders — all copy over without any changes. Charts and images embedded in the sheet copy too.
Renaming a copied sheet so you know which is which
After you copy a sheet, Excel names it automatically. If you copy "Sales Data", the copy becomes "Sales Data (2)". If you copy that one, the next becomes "Sales Data (3)". These names work fine, but they can get confusing fast.
Right-click the sheet tab and select Rename. Type a new name — something like "Sales Data - Archive" or "Sales Data - Draft" — and press Enter. The name updates when ready. You can use spaces, hyphens, and most punctuation, but not forward slashes or backslashes.
Copying multiple sheets at once
Hold Ctrl (Windows) or Command (Mac) and click each sheet tab you want to copy. They will highlight in white. Right-click one of the highlighted tabs and select Move or Copy. The dialog works the same way, but this time it copies all the selected sheets together, in the same order they appear in your file.
This is useful when you have a workbook with many sheets and you want to back up several of them, or when you want to create a template file with multiple related sheets.
Undoing a copy if you change your mind
Press Ctrl+Z (Windows) or Command+Z (Mac) when ready after copying. The copied sheet disappears and you are back to where you started. This works only if you have not made any other changes since the copy was created.
If you saved the file after copying and then want to remove the sheet, right-click the sheet tab and select Delete. Excel asks you to confirm. Click Delete again and the sheet is gone. This action cannot be undone once you save the file, so be certain before you confirm.
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 the dropdown. Open the destination file first, then go back to the source file and copy the sheet.
What if I copy a sheet and the formulas show errors in the new location?
The formulas are probably pointing to sheets that do not exist in the destination file. Right-click a cell with an error, select Edit Formula, and change the sheet reference to match what exists in the new file. Or copy the referenced sheet as well so the formulas have something to point to.
Does copying a sheet also copy the data validation rules I set up?
Yes. Data validation, conditional formatting, and all other sheet-level settings copy along with the data and formulas. The copied sheet is an exact duplicate of the original.
Can I copy just some of the columns or rows instead of the whole sheet?
No, the Move or Copy function copies the entire sheet. If you need only part of it, select the cells you want, copy them with Ctrl+C (Windows) or Command+C (Mac), and paste them into a new sheet or file manually.
What is the difference between Move and Copy?
Move removes the sheet from its current location and puts it somewhere else. Copy leaves the original sheet where it is and creates a duplicate. Always check the Create a copy box if you want to keep both versions.