How to Duplicate an Excel Page With Formulas Intact

Formulas & functions · Updated November 20, 2026

To duplicate an Excel worksheet with its formulas, right-click the sheet tab, choose Move or Copy, select Create a copy, and click OK. Excel copies the sheet’s contents and formatting; then check formulas that refer to other sheets or use fixed references. In Excel, a worksheet is a tab in the workbook. If by page you mean a printed page, see the note in the steps below, because printed pages and worksheets are different things.

What You’ll Need

  • An Excel workbook that you can edit, open in Microsoft Excel for Microsoft 365 on Windows.
  • Permission to change the workbook structure. If the workbook is protected, you may need its password or the owner’s help.
  • A clear idea of whether you need a copy of a whole worksheet or just a block of cells. Duplicating the worksheet is the better choice when you want to retain formulas and sheet-level formatting together.

Step-by-Step

  1. Confirm what you mean by page. A worksheet is represented by a tab along the bottom of the workbook. A printed page is one portion of a worksheet as laid out for printing, and it does not have its own tab. The steps here duplicate a whole worksheet, which is usually what people mean when they want a new page with the same formulas. If you only need a section of cells, copying that range may be more suitable, but it will not bring along all worksheet-level settings.
  2. Save a working copy first. Choose File > Save As and save a separate copy if the workbook is important or the formulas are difficult to recreate. This gives you a fallback if the copied sheet changes references or settings in a way you did not expect. If you are working in OneDrive or SharePoint, confirm that your changes have finished syncing before closing the file.
  3. Find the sheet you want to duplicate. Look at the sheet tabs at the bottom of the Excel window and select the correct tab. If you cannot see it, use the tab navigation arrows to scroll through the tabs, or right-click those arrows to see a list of sheets. If the sheet is hidden, use Home > Format > Hide & Unhide > Unhide Sheet, if you have permission, and select it before copying.
  4. Open the Move or Copy dialog. Right-click the sheet tab and choose Move or Copy. In the dialog, choose where the copy should appear from the Before sheet list. To place it at the end, select the option that puts it after the last listed sheet. The selected position determines where the new tab appears; it does not change the original sheet.
  5. Tell Excel to make a copy. In the Move or Copy dialog, check Create a copy, then click OK. Leave that box unchecked and Excel moves the original sheet instead of duplicating it. A new tab appears, usually with the original sheet name followed by a number, such as Sales (2). The copied worksheet includes cell contents, formulas, formatting, many data validations, and sheet layout settings.
  6. Rename the copied sheet. Double-click the new tab, type a distinct name, and press Enter. Choose a name that makes its purpose or period clear, such as Sales – April or Budget – Draft. Excel sheet names must be unique in the workbook, cannot contain certain characters such as a slash, and are limited to 31 characters. Avoid a name that could be confused with the original when formulas refer to sheets by name.
  7. Check a formula in the duplicate. Click a cell that should contain a formula and look at the formula bar. For a simple example, suppose B2:B4 contain 12, 18, and 20, and B5 contains =SUM(B2:B4). In the copied sheet, B5 should still total 50 because 12 + 18 + 20 = 50. If the formula is missing, the cell may have been blank or may have contained a pasted value in the original; compare it with the source sheet.
  8. Review references before changing the copy. Relative references, such as a formula pointing to a nearby cell, generally continue to point to the corresponding position in the duplicated sheet. Absolute references, which use dollar signs to lock a row or column, remain locked. References to another worksheet commonly continue to use that other worksheet, which is useful when both copies should use the same lookup or rates sheet. If a formula explicitly names the original sheet, inspect it to confirm whether it should keep referring to the original or use the new sheet instead. Click a formula cell and use the formula bar to verify the target sheet and cell.
  9. Check sheet features that formulas depend on. Look for tables, named ranges, dropdown lists, conditional formatting, charts, and pivot tables. Some workbook-level names or connections may be shared rather than independently copied, and a copied chart or pivot table may still use its original data source. If the duplicate is intended to work independently, test its inputs and outputs and review any source references before relying on it.
  10. Test the copy with a safe change. Change a sample input in the duplicate, then confirm the expected result updates there and that the original remains unchanged. Use a value that you can restore afterward. If the formula should respond but does not, check whether calculation is set to automatic under Formulas > Calculation Options > Automatic. Restore the test value and save when your review is complete.
  11. If you meant a printed page, check print layout separately. Duplicating the worksheet also copies many print settings, but it does not create a separate print-page object. To make a second printed page of the same content, you may need to copy the relevant cell range elsewhere, insert a page break, or adjust scaling and print area. Use View > Page Break Preview to see where Excel divides the sheet, and use Page Layout settings to review orientation, margins, scaling, and print area.

Excel for Mac and the web: In Excel for Mac, Control-click or right-click the sheet tab and look for Move or Copy; the dialog and Create a copy option may appear with slightly different wording or placement. Option-dragging a tab can also copy a sheet in some Mac versions, but the dialog is easier to verify. In Excel for the web, right-click the tab and choose Duplicate when that command is available. If the web version does not offer the command for your workbook, open it in the desktop app and use Move or Copy.

Common Mistakes

  • Choosing Move instead of copy. If Create a copy is not checked, Excel relocates the original tab. If you notice this immediately, use Ctrl+Z on Windows or Command+Z on Mac, then repeat the steps with Create a copy selected.
  • Copying cells when you need a whole worksheet. Copy and paste can preserve cell formulas, but it may not reproduce print settings, tab color, column widths, sheet protection, or other sheet-level details. Use the sheet-tab command for a full duplicate.
  • Assuming every reference switches to the new sheet. A copied formula can still refer to the original worksheet or a shared support sheet. Do not assume the copy is self-contained; inspect formulas that include a sheet name, workbook name, or external file reference.
  • Overlooking absolute references. A dollar sign in a reference locks its row or column. That is often intentional, for example when many formulas use one fixed assumption. If you expected the reference to move with the copied content, check whether the original formula was designed to use a relative reference instead.
  • Editing a shared source by mistake. If both sheets refer to the same lookup table, changing that table affects both copies. Confirm which data is shared and which should be separate before entering new values.
  • Ignoring formulas that display as values or errors. A displayed number may still be the result of a formula, while a displayed error may be caused by a missing source or an invalid reference. Use the formula bar and test the inputs instead of replacing the cell with a typed number.

Tips

  • Give the copy a useful name immediately. Clear names make formulas such as sheet-to-sheet references easier to follow and help prevent edits to the wrong tab.
  • Keep a blank template worksheet if you regularly create similar periods or projects. Duplicate the template each time, rather than copying a sheet that already contains last period’s entries or special-case formulas.
  • Use Find to review formulas that mention a sheet name. Press Ctrl+F on Windows or Command+F on Mac, search for the original sheet name, and check the search options so the search includes formulas if needed. A search result is a prompt to review, not proof that the reference is wrong.
  • Consider protecting the finished template if other people will enter data into it. Protect Sheet can limit edits to selected cells, but it is not a substitute for keeping a backup, and workbook-structure protection can also prevent sheet copies or renaming.
  • For a large or business-critical workbook, test the duplicate in a separate file before replacing an existing reporting process. Verify key totals, lookup results, charts, and print output, not just one formula cell.
  • If the workbook uses external links, make sure the linked files remain available. A duplicated worksheet does not automatically copy the other workbooks it relies on or make those external sources independent.

Troubleshooting

Move or Copy is unavailable: The workbook structure may be protected, or the file may be opened in a mode that restricts editing. Check Review > Protect Workbook for structure protection. If a password is required, ask the workbook owner rather than trying to bypass it. In a shared or browser-based file, try opening it in the desktop app if you have editing access.

The duplicate has no formulas: Select a cell that should calculate and check the formula bar. If it shows a fixed number rather than a formula, the source cell may have been pasted as a value. If the cell is blank, check that you copied the intended sheet and that the source formula was present before duplication.

The copied formula points to the wrong sheet: Click the cell and inspect the formula bar for the sheet name. Decide whether the copy should use its own cells, a shared support sheet, or the original sheet. Correct only the references that need changing, then test the result. For many linked formulas, make a backup before using Find and Replace, since replacing a sheet name can affect formulas you intended to keep.

Values do not recalculate: Go to Formulas > Calculation Options and select Automatic. You can also press F9 to recalculate in Windows Excel; on some laptops, you may need the Fn key. On Mac, use the equivalent recalculation command available for your keyboard and Excel version. Check for circular references or missing input values if results still look wrong.

The copied sheet looks different when printed: Open View > Page Break Preview and compare the page breaks, then check Page Layout options for scaling, margins, orientation, and print area. Printer settings can affect pagination, so a duplicate may not break onto paper in exactly the same way on another device.

The sheet name or tab is missing: Check whether the copy was placed among hidden or far-right tabs, and scroll through the tab bar. If you cannot rename or move it, workbook structure protection may be enabled. Save your changes and ask the workbook owner for access if needed.

Frequently Asked Questions

Will duplicating a worksheet keep its formulas?
Yes. The Move or Copy method duplicates formula cells along with the rest of the sheet. Always verify formulas that refer to other sheets, named ranges, or external workbooks, because those references may intentionally remain shared.

Do formulas automatically change to use the new sheet?
Relative cell references generally continue to refer to corresponding cells on the copied sheet, while references to other sheets may continue pointing to the same supporting sheet. Formulas that explicitly name a worksheet should be checked individually to confirm the intended destination.

Can I duplicate a worksheet without copying its formulas?
Yes. After making the copy, select the formula cells and use Home > Paste > Paste Values to replace formulas with their displayed results. This is irreversible once you save and close unless you have a backup, so keep the original formulas or save a separate copy first.

Can I copy a worksheet to another workbook?
Yes. Open both workbooks, right-click the source tab, choose Move or Copy, select the destination workbook in the To book list, check Create a copy, and confirm. If the destination workbook is not listed, make sure it is open and editable. Review formulas afterward because references to sheets or files may behave differently in the new workbook.

Will the duplicate update when I change the original?
Not necessarily. The copied cells are a separate worksheet, but formulas in the duplicate can still refer to the original sheet or to shared data. Whether it updates depends on those references. Test a change in a reversible input cell to see which parts are linked.

Can I undo a worksheet copy?
Usually, press Ctrl+Z on Windows or Command+Z on Mac shortly after creating it. If you have made several other changes or closed the workbook, undo may no longer remove just the copy. In that case, confirm the tab contents before deleting it, and use your saved backup if necessary.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.