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. Excel duplicates the entire sheet with all its data, formulas, and formatting in seconds.

If you do not see sheet tabs at the bottom, your window may be too narrow. Drag the border between the sheet tabs and the horizontal scroll bar to the right to reveal them. The tabs show the name of each sheet — usually "Sheet1", "Sheet2", or custom names you have given them.

This method copies everything: cell values, formulas, charts, conditional formatting, and column widths. The copy gets a new name automatically — if you copy "Sales Data", Excel calls the duplicate "Sales Data (2)". You can rename it right away by right-clicking the new tab and selecting Rename.

Key Takeaways

  • Right-click a sheet tab, choose Move or Copy, check Create a copy, and select your destination to duplicate an entire sheet in seconds.
  • The copied sheet includes all data, formulas, charts, and formatting — nothing is left behind.
  • You can copy a sheet into the same file or into a completely different Excel workbook in one step.
  • Rename the copied sheet when ready after creation to keep your file organized and avoid confusion.
  • If you only need certain cells or data, copy and paste individual ranges instead of duplicating the whole sheet.

Copying a sheet to a different Excel file

The Move or Copy dialog works across files. Before you start, open both the file you are copying from and the file you want to copy into. Then right-click the sheet tab in the source file and select Move or Copy. In the dialog, the dropdown at the top shows all open workbooks. Select the destination file from that list.

The dialog then shows you every sheet in that destination file. Choose where in the order you want the copy to appear — before "Sheet1", after "Sales Data", or at the end. Check Create a copy and click OK. Excel copies the sheet into the other file without removing it from the original.

If the destination file is not open, you can still do this. In the Move or Copy dialog, click Browse at the bottom and navigate to the file on your computer. Excel will open it temporarily, add the copy, and save it automatically.

Copying just the data without formulas

Sometimes you want the numbers and text from a sheet but not the formulas behind them. This matters when you are sending a file to someone else and do not want them to see your calculations, or when you want to lock in values that might otherwise change.

Copy the entire sheet using the method above, then right-click the new sheet tab and select Select All Sheets. Now select all cells by pressing Ctrl+A (or Cmd+A on Mac). Copy with Ctrl+C. Right-click and choose Paste Special. In the dialog, select Values only and click OK. This replaces every formula with its result.

A faster route: after copying the sheet, select all cells, copy them, then use Paste Special > Values on the same sheet. This converts formulas to numbers in place without needing a second sheet.

Renaming and organizing copied sheets

After you copy a sheet, Excel names it automatically by adding "(2)" or "(3)" to the original name. This works fine for temporary copies, but if you are keeping the sheet long-term, a descriptive name is clearer. Right-click the sheet tab and select Rename. Type a new name — "Sales Data - 2024", "Archive", "Draft" — and press Enter.

You can also reorder sheets by dragging their tabs left or right. Click and hold a tab, then drag it to a new position. This does not change the data, only the order in which sheets appear. Organize related sheets together so your file is easier to navigate.

If you have many sheets, right-click a tab and select Sheet Color to add a colored bar to the tab. This helps you spot sheets at a glance — use one color for active data, another for archives, another for drafts.

What happens to linked formulas when you copy a sheet

If your original sheet contains formulas that reference other sheets — like =SalesData!B5 — those formulas copy as-is. The copied sheet will reference the same cells in the same other sheets. This is usually what you want, but it means changes to the original data affect both the original sheet and the copy.

If you want the copy to be independent, use Paste Special > Values after copying to convert all formulas to their results. Now the copy will not change if the original data changes.

If your sheet references cells in a different file entirely, those links copy too. When you open the copied sheet later, Excel may ask whether to update the links. Click Update to refresh them or Do Not Update to keep the old values.

Copying a sheet with charts and images

Charts, images, and other objects copy along with the sheet when you use the Move or Copy method. The chart formulas stay intact — if the chart was based on cells A1 through A10, the copy will reference the same range in the copied sheet.

If a chart in your original sheet references data in a different sheet, the copy will reference the same external data. This means both charts update together. To make the copy independent, you would need to change the chart's data range manually after copying.

Images and shapes copy exactly as they appear — same size, same position, same formatting. If an image is linked to a file on your computer rather than embedded in the workbook, the copy will look for the same file. Moving or deleting that file will break the link in both the original and the copy.

Copying a sheet without certain elements

The standard copy includes everything. If you want to exclude certain elements — like charts, or comments, or conditional formatting — you need a different approach. Select all cells in the sheet with Ctrl+A, copy with Ctrl+C, then create a new blank sheet. Use Paste Special and choose only what you want: Numbers, Formulas, Formats, or Comments.

You can also select just the data range you need instead of the whole sheet. Click the first cell, hold Shift, and click the last cell of the range you want. Copy and paste that range into a new sheet. This gives you a partial copy with only the cells you selected.

For charts and images, select them individually by clicking them, copy with Ctrl+C, and paste into the new sheet. This lets you choose which objects to include and which to leave behind.

Frequently Asked Questions

Can I undo a sheet copy if I made a mistake?

Yes. Press Ctrl+Z when ready after copying to undo. If you have already done other work, you can still delete the copied sheet by right-clicking its tab and selecting Delete Sheet. Excel will ask you to confirm.

What if I copy a sheet and the formulas show errors?

This usually means the formulas reference cells that do not exist in the copied sheet or point to data that has changed. Check the formula bar by clicking a cell with an error. Look for references to other sheets or files. If the reference is wrong, edit the formula or use Find & Replace to fix all instances at once.

Can I copy a sheet from an older Excel file format to a newer one?

Yes. Open both files and use Move or Copy as normal. Excel handles the conversion automatically. However, if the older file uses features not supported in the newer format, those features may not copy correctly. Test the copy to make sure all data and formulas work as expected.

Does copying a sheet increase the file size?

Yes, because you now have two copies of the same data. If your original sheet is 5 MB, the file grows by roughly 5 MB when you copy it. If file size is a concern, delete sheets you no longer need or move old data to a separate archive file.