The fastest way to copy a sheet
Right-click the sheet tab at the bottom of your Excel window. A menu appears with the option "Move or Copy". Click that. A dialog box opens asking where you want the copy to go — you can put it in the same file or a different one. Check the box that says "Create a copy" so Excel makes a duplicate instead of moving the original. Click OK, and you now have two identical sheets.
This method works the same way in Excel on Windows, Mac, and in the web version. The sheet tab is always at the bottom of the screen, and the right-click menu is always the fastest route. If you cannot see the sheet tabs, 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.
Key Takeaways
- Right-click the sheet tab at the bottom and select "Move or Copy" to duplicate a sheet in seconds.
- Check the "Create a copy" box in the dialog to keep the original sheet and make a duplicate instead of moving it.
- You can copy a sheet into the same file, into a different Excel file you already have open, or into a brand-new file.
- If you copy a sheet with formulas that reference other sheets, those formulas will update automatically to point to the correct sheets in the new location.
Copying to a different file you already have open
When you right-click and choose "Move or Copy", the dialog shows you a list of all Excel files you currently have open. Select the file where you want the copy to land, then pick which sheet you want it to appear after. Check "Create a copy" and click OK.
This is useful when you are building a summary sheet or combining data from multiple files. The copy happens when ready, and all the data and formatting come along exactly as they were. If the original sheet has formulas that pull data from other sheets in the same file, those formulas will automatically adjust to reference the correct sheets in the destination file — you do not have to fix them by hand.
Copying to a file that is not yet open
If the file you want to copy to is not currently open in Excel, you have two options. The first is to open that file before you copy — then it will appear in the "Move or Copy" dialog. The second is to copy the sheet into a new blank file, save that file with a new name, and then move it later if you need to.
For most people, opening the destination file first is simpler. Open both files side by side, then right-click the sheet tab in the source file and choose "Move or Copy". The destination file will be listed in the dialog. Select it, choose where in that file the copy should go, check "Create a copy", and click OK.
What happens to formulas and links when you copy
If your sheet contains formulas that reference other sheets in the same file — like =Sheet2!A1 or =SUM(Data!B2:B10) — Excel automatically updates those references when you copy the sheet. The formulas will point to the correct sheets in the new location, whether that is elsewhere in the same file or in a different file entirely.
If your sheet contains links to external files — formulas that pull data from a completely different workbook — those links stay the same. Excel will try to find the external file in its original location. If you move or rename the external file, the links may break, and you will see an error or a prompt asking you to update the link. This is rarely a problem when copying within the same file, but it matters when copying to a different workbook.
Copying multiple sheets at once
You can select more than one sheet tab and copy them all together. Hold Ctrl (or Cmd on Mac) and click each sheet tab you want to copy. Then right-click one of the selected tabs and choose "Move or Copy". The dialog works the same way — pick your destination, check "Create a copy", and all the selected sheets will be copied together in the same order.
This is faster than copying sheets one at a time when you need to duplicate a whole section of your workbook. The sheets stay in the same order in the destination, and all the internal references between them stay intact.
Copying a sheet by dragging (Windows only)
On Windows, you can hold Ctrl and drag a sheet tab to a new location to copy it instead of moving it. Drag it to the right of where you want it to appear, and a vertical line shows you where it will land. Release the mouse, and the copy is made.
This method is faster if you are copying within the same file and you can see both the source and destination locations on screen. It does not work for copying to a different file, and it does not work on Mac. If dragging feels awkward, the right-click method is always available and works everywhere.
Renaming the copied sheet
When you copy a sheet, Excel names it by adding a number to the original name. If your original sheet is called "Sales", the copy becomes "Sales_2". If you copy again, the next one is "Sales_3". You can rename it when ready after copying or any time later.
Right-click the sheet tab and select "Rename". Type the new name and press Enter. Sheet names can be up to 31 characters long and can include spaces and most punctuation, but they cannot include forward slashes, backslashes, question marks, or asterisks. If you try to use one of those characters, Excel will reject the name and ask you to try again.
Frequently Asked Questions
Can I copy just some of the cells from a sheet instead of the whole thing?
Yes, but that is not the same as copying a sheet. Select the cells you want, copy them (Ctrl+C or Cmd+C), click where you want them to go, and paste (Ctrl+V or Cmd+V). This copies the data and formatting but not the sheet structure itself. If you need a whole sheet with only certain data, copy the entire sheet first, then delete the rows and columns you do not need.
What if I copy a sheet and the formulas break?
This usually happens when the sheet references external files or when you copy to a file that does not have the sheets the formulas are looking for. Open the destination file and check whether the referenced sheets exist. If they do not, you may need to recreate them or update the formulas by hand. Use the "Find & Replace" feature (Ctrl+H) to change formula references quickly if you have many to update.
Can I undo a sheet copy?
Yes. Press Ctrl+Z (or Cmd+Z on Mac) when ready after copying, and the duplicate sheet will be removed. If you have made other changes since copying, undoing will reverse those too, so be careful. If you want to delete the copy later without undoing other work, just right-click the sheet tab and select "Delete Sheet".
Does copying a sheet also copy the sheet formatting like colors and fonts?
Yes. When you copy a sheet, everything comes along — all the data, all the formulas, all the colors, fonts, borders, column widths, and conditional formatting. The copy is an exact duplicate of the original at the moment you made the copy. Any changes you make to the original afterward do not affect the copy.