How to Copy a Sheet in Excel (Same or Another Workbook)

Copying a whole sheet is one of those jobs that's either instant or maddening, depending on whether you know the trick. Select all, copy, paste into a new tab works, sort of, but you lose column widths, sometimes formatting, and you've got to rename everything yourself.

Excel has a dedicated copy-the-tab feature built in, and it keeps the sheet exactly as you left it: formulas, formatting, widths, the lot. I use it constantly for monthly reports and client templates. Here's how it works on Windows, Mac and in the browser, plus how to send a copy to a different workbook.

Copying a sheet in Excel by dragging the tab

This is the quickest method, and it works within the same file.

1. Find the sheet tab you want to copy along the bottom of the window.
2. On Windows, hold down Ctrl. On a Mac, hold down Option.
3. Click the tab and drag it left or right along the row of tabs. A small arrow shows where the copy will land.
4. Let go of the mouse button first, then the key.

That last step is the one that trips people up. Microsoft's Mac instructions are explicit: release the mouse button before you release the Option key. Let go of the key first and you may end up moving the sheet rather than copying it. If that happens, press Undo and try again.

Copying a sheet with the Move or Copy box

If dragging feels fiddly, especially with lots of tabs, use the menu instead. On Windows:

1. Right-click the sheet tab.
2. Select Move or Copy.
3. Tick the Create a copy box. This is essential, otherwise the sheet just moves.
4. Under Before sheet, choose where the copy should sit, or pick the last option to put it at the end.
5. Select OK.

The new tab appears in the position you chose. Double-click it to give it a clear name, for example from January to February.

Copying a sheet in Excel for the web

The browser version keeps it very simple: right-click the tab name and select Duplicate. That's it.

Microsoft does flag one snag. Duplicating a sheet that contains a chart, a picture or a shape may fail on the web. If that happens, you'll need the copy-and-paste method in the next section, or open the file in the desktop app.

Copying an Excel sheet into a different workbook

This is handy when you've built a great template in one file and want it in another, such as a client dashboard you reuse.

1. Open both workbooks: the one with the sheet and the one you want to copy it into.
2. In the source file, right-click the sheet tab and select Move or Copy.
3. Under To book, choose the destination workbook. You can also pick new book to put the copy in a brand-new file.
4. Under Before sheet, choose a position.
5. Tick Create a copy and select OK.

On a Mac, Microsoft's help puts this under the Edit menu: Edit, Sheet, then Move or Copy Sheet, with the same To book and Create a copy options.

Copying sheet contents between workbooks on the web

Microsoft says the Move or Copy option isn't available in Excel for the web. The workaround is to copy the contents rather than the tab itself:

1. Select all the data on the sheet. Microsoft suggests Ctrl and Spacebar, then Shift and Spacebar.
2. Press Ctrl and C to copy.
3. Open the other workbook and select the plus sign to add a blank sheet.
4. Click the first cell and press Ctrl and V to paste.

Be aware Microsoft says you'll lose any conditional formatting when you paste this way. If your sheet relies on colour rules, you'll need to set them up again, or do the copy in the desktop app.

Checking formulas after you copy an Excel sheet

Copying within the same workbook is usually painless. Copying to another workbook needs a quick check. Microsoft says that when you move a sheet to another workbook, you should check any formulas or charts that refer to data on that sheet.

For example, if your copied sheet has a formula that pulls from a Settings tab in the original file, it may still point back to that original file. Click a few formula cells and look at the formula bar. If you see another file's name inside it, update the reference so it points to the right place.

Microsoft also warns that moving a sheet that's part of a 3-D reference, a formula that spans several sheets, can change which data the calculation includes.

Ways creators and small businesses use copied sheets

Use	Why copying the tab helps
Monthly reports	Same layout and formulas, just new numbers
Client templates	Each client gets an identical starting sheet
Content calendars	A fresh tab per quarter or campaign
Before big edits	A safety copy of the sheet to fall back on

That last one is my favourite habit. Before I clean up or restructure a sheet, I copy the tab first, so there's always an untouched version to compare against. If you're building trackers in Google instead, my guides to the SUM function in Google Sheets and checkbox columns in Google Sheets cover the same kind of template there.

If you can't copy a sheet in Excel

1. Move or Copy greyed out? The workbook structure may be protected. Check Review, then Protect Workbook.
2. Sheet moved instead of copied? You let go of Ctrl or Option too early, or forgot to tick Create a copy.
3. Destination file not in the To book list? Open it first. Excel only lists workbooks that are open.
4. Duplicate failed on the web? The sheet may contain a chart, picture or shape. Use copy and paste, or the desktop app.

Frequently asked questions

What's the fastest way to copy a sheet in Excel?

Hold Ctrl on Windows, or Option on a Mac, and drag the sheet tab along the row of tabs. Let go of the mouse button before the key.

How do I copy a sheet to another workbook?

Open both files, right-click the tab, choose Move or Copy, pick the other file under To book, tick Create a copy and select OK.

Why did my sheet move instead of copying?

Either Create a copy wasn't ticked, or you released Ctrl or Option before the mouse button while dragging.

Can I copy a sheet in Excel for the web?

Yes, right-click the tab and select Duplicate. Moving a copy to another workbook isn't available on the web, so copy and paste the contents instead.

Will copying a sheet keep the formulas?

Yes, a tab copy keeps formulas and formatting. Microsoft advises checking formulas and charts that refer to the sheet when you copy it into another workbook.