The fastest way to copy a sheet
Right-click the sheet tab at the bottom of your Excel file and select Move or Copy. A dialog box opens. Choose Create a copy, then decide where the copy goes — before or after your current sheet, or into a different file entirely. Click OK. Excel duplicates the entire sheet with all formulas, formatting, and data intact.
This method takes about five seconds and preserves everything exactly as it was. The copy gets a name like "Sheet1 (2)" or "Sales Data (2)" — you can rename it afterward by right-clicking the tab again and selecting Rename.
If you cannot see the sheet tabs at the bottom of your screen, look for a small arrow on the left side of the tab area. Click it to reveal hidden tabs, or widen the tab area by dragging the divider between the tabs and the scroll bar to the right.
Key Takeaways
- Right-click the sheet tab at the bottom and select Move or Copy, then check Create a copy to duplicate the entire sheet in seconds.
- The copied sheet includes all data, formulas, and formatting from the original, so you do not have to rebuild anything.
- You can place the copy right after the current sheet or move it to a different position in the same file or a different file.
- Renaming the copied sheet afterward helps you keep track of which version is which, especially if you plan to make changes to one copy.
Copying a sheet to a different file
If you want the copy to live in a separate Excel file, open both files first — the one you are copying from and the one you want to copy into. Then right-click the sheet tab in the source file and select Move or Copy. In the dialog, under "Before sheet", you will see a dropdown that says something like "Book1" or the name of your current file. Click that dropdown and select the name of the destination file instead.
Choose where in that file the copy should go, check Create a copy, and click OK. Excel moves the sheet tab to the other file. Both files must be open for this to work — if the destination file is closed, the dropdown will not show it as an option.
When copying does not work the way you expect
If your sheet contains links to other sheets in the same file — formulas that reference cells from a different tab — the copy will still reference the original sheet, not the copied one. For example, if Sheet1 has a formula that says =Sheet2!A1, and you copy Sheet1, the formula in the copy still points to Sheet2, not to a copy of Sheet2. This is usually what you want, but if you need the copy to be completely independent, you will need to update those formulas by hand.
Charts, pivot tables, and conditional formatting all copy correctly. Images and text boxes copy as well. The only thing that sometimes behaves unexpectedly is external links — formulas that pull data from a file outside your current workbook. Those links stay pointed at the original external file in both the original sheet and the copy.
Copying just the visible cells
If your sheet has hidden rows or columns and you only want to copy what you can see, use copy and paste instead of the sheet duplication method. Select all the cells you want (use Ctrl+A on Windows or Cmd+A on Mac to select everything), then right-click and choose Copy. Create a new sheet by right-clicking a tab and selecting Insert Sheet, then paste the data there.
When you paste, Excel automatically includes only the visible cells — hidden rows and columns do not come along. This is useful if you have filtered data or deliberately hidden rows you do not want in the copy. If you want hidden content included, use the Move or Copy method instead, which copies the entire sheet structure.
Renaming and organizing copied sheets
After you copy a sheet, Excel names it automatically by adding a number in parentheses. You can change this to something more useful. Right-click the sheet tab and select Rename, then type a new name. Sheet names can be up to 31 characters long and can include spaces, but they cannot include forward slashes, backslashes, question marks, asterisks, or colons.
If you have many sheets in one file, you can also color-code the tabs to organize them visually. Right-click a tab, select Sheet Tab Color, and pick a color. This does not change the data — it just makes it easier to find the sheet you need at a glance, especially in files with dozens of tabs.
Copying a sheet without formulas
If you want a copy of the sheet but with values only — no formulas — you need a different approach. First, duplicate the sheet using the Move or Copy method. Then, in the copied sheet, select all cells with Ctrl+A (Windows) or Cmd+A (Mac). Right-click and choose Copy. Then right-click again and select Paste Special. In the dialog, check only Values and click OK. This replaces all the formulas with their results.
This approach is useful when you want to share a snapshot of data without revealing how the calculations work, or when you plan to delete the original sheet and want the copy to stand alone without broken formula references.
Frequently Asked Questions
Can I undo a sheet copy?
Yes. Press Ctrl+Z (Windows) or Cmd+Z (Mac) when ready after copying. If you have made other changes since then, undo will step backward through each change until it reaches the copy action. Once you save the file, you cannot undo the copy anymore.
What happens to the sheet name when I copy it?
Excel adds a number in parentheses to the original name. "Sales" becomes "Sales (2)", "Sales (3)", and so on. You can rename it to anything you want by right-clicking the tab and selecting Rename.
Can I copy a sheet from one Excel file to another without opening both?
No. Both files must be open in Excel for the Move or Copy dialog to show the destination file as an option. Open the destination file first, then use the method described in the "Copying a sheet to a different file" section.
Does copying a sheet also copy the print settings?
Yes. Page breaks, margins, headers, footers, and print area all copy along with the sheet. If you want different print settings on the copy, right-click the sheet tab, select Print Preview, then adjust the settings under Page Layout.