To duplicate a page in Excel, right-click its 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 the original content and layout, so you can edit the copy without changing the source. In Excel, people often use page to mean worksheet; if you mean a printed page, see the note below about print layout.
The steps below are for Microsoft Excel for Microsoft 365 on Windows. Before you begin, identify the correct worksheet and decide whether you want the copy in the same workbook or a different one. Duplicating a sheet is different from copying a range of cells: it copies the worksheet as a whole, including much of its formatting and sheet setup.
What You’ll Need
- An Excel workbook open in the desktop app, with the worksheet you want to copy.
- A clear place for the copy: the current workbook, another open workbook, or a new workbook.
- If the worksheet contains formulas, links, or data connections, access to the related sheets or files so you can check that the copy still works as intended.
You do not need a special add-in or a macro. If the workbook is read-only, protected, or shared with restrictions, you may need permission to make changes. Save the workbook first if you are unsure about its current state.
Step-by-Step
-
Find the worksheet tab. Look along the bottom of the Excel window for the tab whose contents you want to duplicate. If the tab is not visible, use the sheet navigation arrows at the lower left to scroll through tabs. You can also right-click those arrows to see a list of worksheet names in many desktop versions. Confirm the worksheet by opening it and checking its headings or data before copying.
-
Open the Move or Copy dialog. Right-click the worksheet tab and choose Move or Copy. You can also use the ribbon: select the worksheet, then choose Home > Cells > Format > Move or Copy Sheet. The dialog lets you choose a destination and, importantly, whether to move the original or create a separate copy.
-
Choose the destination workbook. In the To book list, choose the workbook where the duplicate should appear. To keep it alongside the original, select the current workbook name. To put it in another workbook, that workbook generally needs to be open so it appears in the list. Choose (new book) if you want Excel to create a separate workbook containing the copied sheet.
-
Choose where to place the sheet. In the Before sheet list, select the worksheet that should come immediately after the copy. For example, select a summary sheet if you want the duplicate placed just before it. Choose the end-of-list option, often shown as (move to end), to put the copy after the existing tabs. The position changes the tab order, not the contents of either sheet.
-
Turn on Create a copy. Check the Create a copy box before you click OK. This is the key step: if the box is clear, Excel moves the original worksheet rather than duplicating it. Check both the destination and the box if you are copying to another workbook; a wrong destination can make the sheet seem to have disappeared from the original file.
-
Click OK and confirm the new tab appears. Excel creates the duplicate next to the position you selected. The copied tab often has a number appended to its name, such as Budget (2). Click the new tab and inspect a few cells, formulas, and visual elements to make sure the intended sheet was copied.
-
Rename the duplicate. Double-click its tab, type a distinctive name, and press Enter. A practical name might identify the period, department, or version, such as Budget – Q3. Worksheet names must be unique within a workbook, cannot exceed 31 characters, and cannot include characters such as a colon, slash, question mark, asterisk, or square brackets. If Excel rejects a name, shorten it or remove the invalid character.
-
Check formulas and links before using the copy. A copied sheet brings its formulas along, but a formula that points to another worksheet or workbook may still point to the original destination. Check representative formulas, dropdowns, charts, and linked data. If the copy is meant to be an independent template, update any references that should point to the new sheet or its new source data.
Quick alternative on Windows: Hold down Ctrl, drag the worksheet tab to the desired position, and release the mouse button before releasing Ctrl. Excel makes a copy rather than moving the tab. On a Mac, hold Option while dragging the tab. This gesture can be easy to miss, so use Move or Copy if you need to choose another workbook or want to verify that Create a copy is selected.
Excel for the web: Right-click the worksheet tab and choose Duplicate when that option is available. Excel places a copy in the current workbook. The web app does not offer all the same destination choices as the desktop Move or Copy dialog; open the workbook in the desktop app if you need to copy the sheet into another workbook or the web menu does not show Duplicate. On a Mac desktop, the Move or Copy dialog is also available from the sheet-tab context menu, and Option-drag is the corresponding tab-copy gesture.
If you mean a printed page: Excel worksheets can span several printed pages. To duplicate only what appears on one printed page, first identify the cells in that page using View > Page Break Preview or Page Layout view. Copy those cells to a new worksheet or another area, then check print settings under Page Layout. The Move or Copy method above duplicates the entire worksheet, not just one printed page.
Common Mistakes
-
Moving instead of copying. In the Move or Copy dialog, leaving Create a copy unchecked relocates the original tab. If that happens, use Ctrl+Z immediately if the action is still undoable, or move the sheet back to its former position. Confirm the checkbox before proceeding next time.
-
Copying the wrong worksheet. Tabs can look similar, especially in workbooks with monthly or regional versions. Open the source sheet and verify its title and key content before you duplicate it. Rename the copy as soon as it is created so you do not edit the source by mistake.
-
Assuming every reference becomes independent. Cell formulas, chart series, named ranges, and links can refer to other sheets or files. A worksheet copy does not automatically create copies of every related sheet or external source. Inspect dependencies before sharing or changing the copied sheet.
-
Copying cells when you meant to copy a sheet. Selecting a range and using Copy duplicates only those cells, not the worksheet tab or its full setup. Use the tab menu for a whole-sheet duplicate. Conversely, copying a whole sheet may include more content than you want if you only need one print area or table.
-
Trying to use a name Excel will not accept. A duplicate name must be unique in its workbook and meet Excel’s worksheet-name rules. If the copied tab has a number added automatically, rename it to something useful, but do not give it the exact name of an existing tab.
Tips
-
Keep a clean original. Treat the source as a template and make changes only in the duplicate. This is especially useful for recurring reports, invoices, schedules, and forms. Consider marking the template tab with a consistent name or tab color so it is easy to recognize.
-
Review print setup on the copy. A copied sheet usually retains its sheet-level formatting and print settings, but verify print area, orientation, scaling, headers, and page breaks if the duplicate will be printed or exported to PDF. A small change in data can cause a worksheet to spill onto an extra printed page.
-
Make the tab name informative. Include a period or version when that helps distinguish the copy, but keep the name short enough for Excel’s 31-character limit. Clear names reduce the risk of entering data in last month’s sheet or sending the wrong version to someone else.
-
Check hidden items and sheet structure. If the source has hidden rows, columns, or objects, the copy may preserve them. Review the View and Home ribbon options if expected content seems missing. Also check whether the worksheet is protected; protection can limit edits in the duplicate even though the sheet was copied successfully.
-
Use a new workbook only when you need separation. Creating the duplicate in a new workbook can be convenient for sharing one sheet, but formulas that depend on other tabs may no longer have the needed context. If you choose (new book), inspect links and save the new file with a clear name.
Troubleshooting
-
The Move or Copy command is unavailable. Check whether the workbook structure is protected. In desktop Excel, review Review > Protect Workbook; if workbook structure protection is on, you will need the password or permission to turn it off before adding, moving, or copying sheets. If the file is read-only or opened with restricted permissions, save an editable copy or ask the owner for access.
-
The sheet moved instead of duplicating. Open Move or Copy again and confirm Create a copy is checked. If you just moved it, Ctrl+Z on Windows may undo the move; on Mac, use Command+Z. If you have made later edits, avoid undoing a long sequence blindly. Instead, use Move or Copy to return the original tab to its intended workbook and position.
-
The copied sheet is missing or in the wrong workbook. Check the destination selected in To book and look at the workbook windows or open workbook list. If you chose (new book), Excel may have opened a separate workbook window. Save that workbook if it contains the copy. If the copy went to the wrong open workbook, repeat the process with the correct destination and then remove the unwanted copy only after verifying the correct one exists.
-
Formulas show errors or unexpected values. Click a problem cell and inspect its formula bar. Look for references to the original sheet name or an external workbook path. If a referenced sheet was not copied, either copy that dependency too or revise the formula to use a valid source. For external links, check Data > Workbook Links if the command is available in your Excel version, and confirm the source file is accessible.
-
The duplicate tab is not visible. Tabs may be hidden because there are many worksheets, the horizontal scrollbar takes up space, or the sheet itself is hidden. Use the navigation arrows to scroll, widen the tab area by dragging the divider beside the horizontal scrollbar, or right-click a visible tab and choose Unhide if the sheet is hidden. Very hidden sheets require changing their visibility through VBA or the workbook’s author.
-
The web app does not show Duplicate. Check that you are right-clicking a worksheet tab rather than a cell, and confirm you have edit permission. If Duplicate is still absent, open the file in Excel for Microsoft 365 on Windows or Mac and use Move or Copy. Menu availability can vary with the workbook’s permissions and the current web interface.
Frequently Asked Questions
Does duplicating a worksheet change the original?
No. A successful copy creates a second worksheet, and edits to ordinary cells in the duplicate do not alter the source. However, both sheets can still use common sources, such as another worksheet, an external file, or a data connection. Changing a shared source can affect what you see in both places.
Can I duplicate a worksheet into another workbook?
Yes. Open both workbooks, right-click the source tab, choose Move or Copy, select the destination workbook in To book, choose a position, check Create a copy, and click OK. Verify formulas and links afterward because the destination workbook may not contain the sheets or files that the formulas reference.
Will the copy include formatting, charts, and print settings?
A whole-sheet copy generally carries cell formatting, formulas, charts and other sheet objects, and much of the worksheet’s page setup. Still, check items that matter to your work, especially print areas, page breaks, charts linked to other sheets, data validation, and hidden rows or columns. Features connected to workbook-level settings or external data may need separate attention.
How do I duplicate a worksheet without its formulas?
First duplicate the worksheet, then select the relevant cells in the copy and use Home > Paste > Paste Special > Values to replace formulas with their current results. This changes only the selected cells, so leave formulas in place if the sheet needs to recalculate. Check charts and other objects separately, since they may still be linked to source data.
Is an Excel page the same as a worksheet?
Not always. A worksheet is the tab you work in; a printed page is one portion of a worksheet as arranged for printing. The Move or Copy command duplicates the whole worksheet. If you need just one printed page, identify and copy that page’s cell range, then adjust the new sheet’s print settings.
Related
- Excel Calendar With Correct Dates: A Step-by-Step Guide
- Excel AutoSave: How to Turn It Off and Keep Changes Safe
- Delete a Protected Sheet in Excel: Steps and Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Row Height in Inches: Conversion and SettingsExcel measures row height in points, not inches: divide the height in points by 72 to convert it…
- How to Add Page Numbers in a Word Booklet CorrectlyTo add page numbers to a Word booklet, set up the booklet layout first, then choose Insert >…
- How to Set Out of Office in Microsoft OutlookTo set an out-of-office message in Outlook, open Automatic Replies, turn them on, write your message, and—if you…
- Excel Compare Two Sheets and Show Differences ClearlyTo compare matching cells on two worksheets, put this formula in a third sheet and fill it across…
- Google Sheets COUNTIF Not Blank: Formula and ExamplesTo count nonblank cells in Google Sheets, use =COUNTIF(A2:A100,"<>"), replacing A2:A100 with your range. The criterion "<>" means…
- How to Share a Calendar Link in Outlook for OthersTo share an Outlook calendar as a link, open Outlook on the web, go to Settings > Calendar…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.