To copy a tab in Excel, right-click the worksheet tab, choose Move or Copy, check Create a copy, select where the duplicate should go, and click OK. This makes a separate worksheet with its own contents, so you can use the original as a template or keep a snapshot before making changes. The steps below are for Excel for Microsoft 365 on Windows; Mac and web options are included where they differ.
What You’ll Need
- An Excel workbook with the worksheet you want to duplicate. A tab represents a worksheet, not just the cells currently visible on screen.
- If you are copying the worksheet into a different workbook, have that destination workbook open too. You can also choose to create a new workbook during the copy process.
- Permission to make changes to the workbook. If its structure is protected, or the file is read-only, you may need to remove the restriction or save an editable copy first.
- If the workbook contains important data, save it before you begin. Copying a sheet is usually easy to reverse, but saving first gives you a clean fallback.
Step-by-Step
- Open the workbook and locate the right tab. Open the Excel file and find the worksheet tab along the bottom of the window. If you cannot see it, use the tab navigation arrows at the lower left to scroll through the sheet tabs. If the sheet tabs themselves are hidden, go to File > Options > Advanced, find the display options for this workbook, and confirm that Show sheet tabs is selected. In Excel for Mac, use Excel > Preferences (or Settings, depending on the release), then check the workbook’s view or sheet-tab settings.
- Open the worksheet tab menu. Right-click the tab you want to copy. On a touchpad, use the secondary-click gesture configured for your computer. Make sure the tab itself is selected; right-clicking a cell opens a different menu. From the tab menu, choose Move or Copy. If you do not see that command, look for a workbook-structure restriction or use the Excel desktop app if you are working in a browser.
- Choose the destination workbook. In the Move or Copy dialog box, open the To book list. To make a duplicate in the current file, leave the current workbook selected. To place the sheet in another open workbook, choose that workbook from the list. To create a separate workbook containing the copied sheet, choose (new book). The destination file must be open for it to appear in the list; open it first if necessary.
- Choose where the copy should appear. In Before sheet, select the tab that the copy should come before. For example, if you want the duplicate immediately after the original, select the tab that currently follows the original. To put the copy at the end, choose (move to end). Excel uses this list to set the copied sheet’s position; it does not change the order of the data inside the sheet.
- Check Create a copy. This is the key setting. If the box is not checked, Excel moves the original worksheet to the destination instead of leaving the original in place. With Create a copy checked, the source remains where it is and Excel adds a duplicate at the destination. Review both the destination and placement before continuing.
- Click OK and confirm the new tab. Excel creates the copy. In the same workbook, the new tab commonly has the original name followed by a number, such as Summary (2). Click the new tab and inspect a few cells, formulas, and objects to make sure you copied the intended sheet. If you chose (new book), a separate workbook opens; save it with File > Save As and give it a clear name.
- Rename the copy if needed. Double-click the new tab name, type a distinctive name, and press Enter. You can also right-click the tab and choose Rename. Keep the name short and avoid characters Excel does not allow in sheet names, including brackets, asterisks, question marks, slashes, and colons. A clear name such as April Forecast is easier to recognize than a sequence of numbered duplicates.
Quick alternative on Windows: Hold down Ctrl and drag the worksheet tab to a new position. Release the mouse button before releasing Ctrl. Excel makes a copy rather than moving the original; a small plus sign may appear as you drag. This is convenient for copying a tab within the same workbook, but the dialog method is more reliable when you need to choose another workbook or a new workbook.
On a Mac: You can use the same Move or Copy command from the worksheet tab’s context menu. Another quick method is to hold Option while dragging the tab to a new position. On Excel for the web, right-click the tab and choose Duplicate if that command is available. The browser version’s options can differ from desktop Excel, so use the desktop app for the full destination and placement controls.
Common Mistakes
- Forgetting to check Create a copy. Without the checkbox, the sheet moves, which can make it appear that the original disappeared. If you notice immediately, press Ctrl+Z on Windows or Command+Z on Mac. You can also move the sheet back using the same dialog.
- Copying cells instead of the worksheet. Selecting a range and pressing Ctrl+C copies only those cells. It does not duplicate the tab, sheet-level layout, or the whole worksheet. Start from the tab menu when your goal is a full-sheet copy.
- Choosing the wrong destination. When multiple workbooks are open, check the To book field carefully. A copied sheet can end up in a different file than intended. If you selected a new book, remember that it is a separate workbook that needs its own save location and filename.
- Assuming formulas become independent. A copied sheet carries formulas with it, but a formula that refers to another worksheet may still refer to the original worksheet in the same workbook. Copying a sheet is not the same as making every formula value permanent or creating a fully independent workbook. Check formulas that reference other tabs, especially before editing or sharing the copy.
- Using a name that already exists. Sheet names must be unique within a workbook. Excel may append a number to a duplicate name, or you may need to rename the new tab yourself. Avoid assuming the copy kept the exact name you expected.
- Trying to copy a tab in a protected workbook. Workbook structure protection can block moving, copying, renaming, or deleting sheets. This is different from protecting cells on a worksheet. If you are authorized, use Review > Protect Workbook to turn off structure protection, supplying the password if requested.
Tips
- Use the dialog for accuracy. Dragging is fast when duplicating a tab beside the original, but the dialog makes it easier to see which workbook is the destination and where Excel will place the copy.
- Think about formulas and links before copying to another file. Formulas that rely on sheets outside the copied worksheet may continue to refer to the source workbook. After copying, review formulas that use another tab, named ranges, or external workbook references. If you want a standalone snapshot, decide whether the copied sheet should keep live formulas or display fixed values before making further edits.
- Check objects and layout, not just values. A worksheet copy is intended to bring over its sheet contents and layout, including formatting and many objects. Still, inspect charts, images, print settings, page breaks, and data validation if they matter to your use. Features linked to other workbook content may need attention when the copy goes to a different file.
- Rename copies as you make them. Names such as Template – Original, Template – Working, or a month and year make it less likely that you will edit the wrong tab later. Avoid using a name that could be mistaken for the source.
- Copy first, then edit. If you are experimenting with a layout or a formula, duplicate the worksheet before changing it. This preserves the source in the workbook, as long as you check Create a copy.
- Keep the source workbook open during a cross-workbook copy. This makes it easier to select the right destination and to inspect the relationship between formulas in the source and the copied sheet. Once you are satisfied, save both workbooks if both have changed.
Troubleshooting
Move or Copy is missing or disabled: Check whether the workbook structure is protected. On Windows, look under Review > Protect Workbook; if structure protection is on, an authorized user must remove it before sheets can be rearranged or copied. A read-only file or restricted shared workbook can also limit changes. Save an editable copy if you have permission, or ask the workbook owner for access.
The copy is not in the position you expected: Open the tab menu and choose Move or Copy again, select the correct destination workbook, and choose the intended position in Before sheet. If you copied with Ctrl-drag or Option-drag, drag the new tab to the desired place afterward. Be sure you are moving the duplicate, not the original.
The copied formulas show unexpected results: Click a formula cell and inspect the formula bar. If it refers to a different tab or workbook than you expected, the copied sheet may still be linked to the original source. Confirm that the referenced sheet exists in the destination. For a copy within the same workbook, references to other sheets often continue pointing to those existing sheets; this is normal. Do not replace formulas with values unless you are sure you no longer need the calculations to update.
The destination workbook is not listed: Open the destination file in Excel before opening the Move or Copy dialog. If it is open but missing, check that both files are in a compatible Excel session and that the destination is not restricted. As a fallback, choose (new book), create the copy, and then use Save As to store it; this does not automatically place the sheet in a workbook that was not available in the list.
You cannot see the copied tab: Scroll the tab strip using the navigation arrows, check whether the sheet is hidden, and confirm that sheet tabs are displayed. You can use Home > Format > Hide & Unhide > Unhide Sheet to reveal a hidden worksheet, if you have permission. If the new workbook opened separately, switch to that window rather than looking only in the original file.
The tab name has a number or Excel refuses a rename: Another worksheet already uses that name, or the name includes an unsupported character. Choose a unique name of up to 31 characters and try again. If the workbook structure is protected, you must also resolve that restriction before renaming.
Frequently Asked Questions
Does copying a tab copy the entire worksheet?
Yes. The tab-level copy creates a separate worksheet, rather than copying only a selected cell range. It generally carries the sheet’s contents and formatting, but inspect linked formulas, objects, and print setup when exact results matter.
How do I copy a tab in Excel without using the right-click menu?
On Windows, hold Ctrl and drag the tab to its new position. On Mac, hold Option and drag. These shortcuts are best for copying within the same workbook; use Move or Copy when you need to choose another workbook or a new book.
Can I copy an Excel tab to another workbook?
Yes. Open both workbooks, right-click the source tab, choose Move or Copy, select the destination in To book, check Create a copy, choose a position, and click OK. Save the destination workbook afterward.
Will the copied worksheet update when I change the original?
Not as a live duplicate of the entire sheet. The copy is a separate worksheet. However, formulas inside it may still refer to cells on the original sheet or other sheets, so those formula results can change when their referenced cells change.
Can I duplicate a tab in Excel for the web?
Often, yes. Right-click the worksheet tab and choose Duplicate. If the command is unavailable or you need to copy the tab to another workbook with more control, open the file in desktop Excel and use Move or Copy.
Why did Excel move my tab instead of copying it?
The Create a copy box was probably left unchecked in the dialog. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, or move the sheet back. When using the drag shortcut, hold Ctrl on Windows or Option on Mac while dragging so Excel creates a duplicate.
Related
- Enable Editing in Excel: Exit Protected View
- How to Close an Excel Sheet With the Keyboard Quickly
- How to Close an Open Dialog Box in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel: Find Where a Cell Is Used Across SheetsTo see which formulas use a cell in Excel for Microsoft 365 on Windows, select it and choose…
- Christmas Labels in Word: Create, Format, and PrintTo create Christmas labels in Microsoft Word, open Mailings > Start Mail Merge > Labels, choose the label…
- How to Delete Gridlines in Excel Without Hiding Cell BordersTo hide gridlines in Excel, open the worksheet, select the View tab, and clear the Gridlines checkbox. This…
- Excel Power Query Merge vs Append: Which Should You Use?In Excel Power Query, Merge joins two queries side by side using one or more matching columns; Append…
- Word Wrap in Excel: How to Make Text Wrap in CellsTo do word wrap in Excel, select the cell or cells, then choose Home > Wrap Text. Excel…
- Excel: Insert a Checkbox Without the Developer TabYes. In current Microsoft 365 versions of Excel, select the cell or range where you want checkboxes, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.