The quickest way to duplicate a worksheet

Right-click the sheet tab at the bottom of your Excel window and select Move or Copy. A dialog box opens. Check the box labeled Create a copy, choose where you want the new sheet to appear in your workbook, and click OK. Excel creates an exact duplicate with all formulas, formatting, and data intact.

The sheet tab is the small labeled rectangle at the very bottom of your screen — you'll see "Sheet1", "Sheet2", or whatever you've named your sheets. If you don't see the sheet tabs, your window may be too small. Drag the border between the sheet tabs and the horizontal scrollbar upward to reveal them.

This method works whether you want to copy a sheet within the same workbook or move it elsewhere. The duplicate appears when ready and is ready to edit.

Key Takeaways

  • Right-click any sheet tab at the bottom of Excel and select Move or Copy to duplicate the entire worksheet in seconds.
  • Check the Create a copy box in the dialog to make a duplicate rather than moving the original sheet.
  • You can position the copied sheet anywhere in your workbook — before or after existing sheets — by selecting it in the list before clicking OK.
  • The duplicate contains all formulas, formatting, cell values, and charts from the original, so you don't have to rebuild anything.
  • If sheet tabs aren't visible, drag the divider between the tabs area and the horizontal scrollbar to make room.

Understanding what gets copied

When you copy a worksheet, Excel duplicates everything on that sheet: all cell values, formulas, number formatting (like currency or percentages), font styles, background colors, borders, merged cells, charts, images, and comments. If your original sheet has a frozen pane or hidden rows and columns, those settings copy too.

One thing that does not copy is the sheet's print settings — page breaks, print area, margins, and header/footer text stay with the original. If you've customized how the sheet prints, you'll need to adjust those settings on the duplicate separately.

Formulas that reference other sheets in your workbook will still point to those same sheets after copying. For example, if your original sheet has a formula that sums values from "Sheet2", the copied sheet's formula will also reference "Sheet2", not create a new copy of it.

Copying a sheet to a different workbook

To copy a worksheet into a completely different Excel file, the process is almost identical, but you need both files open first. Open the workbook you want to copy from and the workbook you want to copy into — you can have multiple Excel files open at the same time.

Right-click the sheet tab you want to copy and select Move or Copy. In the dialog, look for the dropdown that says To book: and select the name of the other workbook from the list. Then choose where in that workbook the sheet should go and check Create a copy. Click OK.

If the other workbook doesn't appear in the dropdown, make sure it's actually open. Switch to that file (using Alt+Tab on Windows or Command+Tab on Mac), then come back and try again. The dropdown only shows workbooks that are currently open in Excel.

Renaming the copied sheet

Excel names your duplicate "Sheet1 (2)" or "Sheet2 (2)" depending on what the original was called. You'll usually want to give it a more meaningful name. Right-click the new sheet tab and select Rename, then type the new name and press Enter.

Sheet names can be up to 31 characters long and can include spaces and most punctuation. They cannot include forward slashes, backslashes, question marks, asterisks, or square brackets — Excel will reject those characters and ask you to try again.

Copying just the visible cells

If your worksheet has hidden rows or columns and you want to copy only what's visible on screen, the right-click method still copies everything, including hidden content. To copy only visible cells, you need a different approach.

Select all the cells you want to copy (or press Ctrl+A to select the entire sheet), then copy them with Ctrl+C. Create a new sheet by right-clicking a sheet tab and selecting Insert Sheet. In the new sheet, right-click a cell and select Paste Special. In the dialog, check Skip empty cells if you want, then click OK. This method is slower but gives you control over what pastes.

For most situations, the straightforward right-click duplicate method is faster and cleaner. Use this approach only if you specifically need to exclude hidden rows or columns.

Undoing a copy you didn't mean to make

If you copied a sheet by mistake, press Ctrl+Z when ready to undo. Excel will remove the duplicate sheet and restore your workbook to its previous state. This works as long as you haven't saved the file yet.

If you've already saved, you can still delete the unwanted sheet. Right-click its tab and select Delete Sheet. Excel will ask you to confirm — click Delete to remove it permanently. This action cannot be undone after you confirm, so make sure you're deleting the right sheet.

Copying multiple sheets at once

To copy more than one sheet in a single operation, hold Ctrl (or Command on Mac) and click each sheet tab you want to copy. They'll all highlight. Then right-click one of the highlighted tabs and select Move or Copy. The dialog will show that you're moving or copying multiple sheets. Check Create a copy, choose the destination, and click OK.

Excel will copy all selected sheets in the same order they appeared in the original workbook. If you selected "Sales", "Expenses", and "Summary" in that order, the copies will appear in that same order in the destination.

Frequently Asked Questions

Will copying a sheet also copy the sheet's print settings?

No. The copied sheet will have Excel's default print settings. You'll need to adjust page breaks, print area, margins, and headers or footers on the duplicate if you want them to match the original. Open the Page Layout tab to change these settings.

Can I copy a sheet from one Excel file into another without having both open?

Not with the right-click method. Both files must be open in Excel at the same time. If the file you want to copy into isn't open yet, open it first, then use the Move or Copy dialog to select it from the dropdown list.

What happens to formulas that reference other sheets when I copy?

They keep pointing to the original sheets. If your formula says =SUM(Sheet2!A1:A10), it will still reference Sheet2 after copying, not create a new copy of Sheet2. If you need the formulas to reference a different sheet, you'll have to edit them manually.

Can I copy just some cells from a sheet instead of the whole thing?

Yes, but that's different from copying an entire worksheet. Select the cells you want, press Ctrl+C to copy, then click where you want them and press Ctrl+V to paste. This copies the content into existing cells rather than creating a new sheet.

What if I want to copy a sheet but leave out the hidden rows?

The standard right-click method copies everything, including hidden content. To exclude hidden rows, select all cells, copy them, create a new sheet, then use Paste Special instead of regular paste. This gives you more control over what appears in the duplicate.