How to Copy Formulas in Excel to a New Workbook Safely

To copy formulas into a new Excel workbook, open both workbooks, copy the formula cells in the source, then paste them into the destination. Use Home > Paste > Formulas if you want to leave formatting behind, or copy the whole worksheet if the formulas depend on other cells and tabs. Check references before saving: formulas that rely on sheets you did not copy may link back to the original workbook.

The instructions below are for Excel for Microsoft 365 on Windows. Copying formulas is straightforward, but the result can change depending on where you paste and whether you also bring along referenced sheets. Pick the method that matches what you want the new file to contain.

What You’ll Need

The source workbook containing the formulas and a destination workbook. If you do not have a destination yet, you can create one during the process.
Permission to edit both workbooks, and a folder where you can save the finished file.
A clear idea of whether you need formulas only, formulas plus formatting, or a complete worksheet with its supporting data and tabs.

Step-by-Step

Open the source and destination workbooks. Open the workbook with the formulas, then open the workbook where you want to put them. To make a blank destination in Excel for Windows, choose File > New > Blank workbook. Save it with a useful name using File > Save As before pasting, so you know which file you are editing.

If you are creating a new workbook, keep the source open. You can switch between open workbooks with Ctrl+Tab on Windows. On Mac, use Command+Tab to switch apps if needed, or select the workbook from Excel’s Window menu. In Excel for the web, use the workbook tabs in your browser; both files may be open in separate browser tabs.
Identify the formula range and its dependencies. In the source workbook, click the sheet tab containing the formulas. Select the cells you want to transfer. If you need a continuous block, click its upper-left cell, hold Shift, and click the lower-right cell. For nonadjacent ranges, hold Ctrl while selecting each range on Windows; on Mac, hold Command.

Before copying, look at what the formulas use. A formula may rely on values in nearby cells, another worksheet, a named range, a table, or a defined name. If those inputs are essential, plan to copy them too or keep them available in the destination. Moving only the formula cells does not automatically bring over every dependency.
Copy the selected cells. Press Ctrl+C on Windows. On Mac, press Command+C. A moving border appears around the selection. Leave the source workbook open while you switch to the destination; do not cut the cells unless you intend to remove them from the source.

To copy an entire worksheet instead of a range, right-click its sheet tab and choose Move or Copy. In the To book list, choose (new book) or the destination workbook. Check Create a copy, then select OK. The new or destination workbook receives a copy of the sheet, including its cell contents and formatting. This is often the better choice when calculations depend on a whole tab.
Choose where the copied cells should go. Switch to the destination workbook and select the sheet where the formulas belong. Click the top-left cell of the destination area. If you want to maintain the same layout as the source, select the corresponding starting cell. For example, if the source range starts at the top-left of a data block, paste at the top-left of the matching block in the new file.

Make sure the destination area is empty or that you are comfortable replacing its contents. Pasting over existing cells replaces them. If the copied selection contains several rows and columns, leave enough space for the entire selection to fit.
Paste formulas, or paste everything. To paste the cells as copied, press Ctrl+V on Windows or Command+V on Mac. This normally brings over formulas and formatting, along with other copied cell content. Use this when the destination should look like the source.

To paste formulas without the source formatting, use the ribbon: choose Home > Paste > Formulas. In Excel for Microsoft 365 on Windows, you can also right-click the destination and choose the Formulas paste option from the paste options. Ribbon labels or the available right-click icons can vary slightly by Excel build. On Mac, use the Home tab’s Paste menu and choose Formulas; if the option is not visible, open the Paste Special dialog from the menu rather than relying on a Windows shortcut.

Formula-only pasting is useful when the destination already has its own fonts, fills, borders, and number formats. It does not copy the source cell’s appearance, and it cannot supply missing input cells or worksheet tabs.
Check how references behave. Click several pasted cells and inspect the formula bar. Relative references can shift when you paste to a different position, because Excel adjusts them according to the move. Absolute references stay fixed to their specified cell addresses, but that does not guarantee the referenced cells exist in the new workbook. If a formula refers to another worksheet that was not copied, Excel may create a link to the original workbook.

For example, if a pasted calculation expects an input to remain in the same relative position, paste the range into the corresponding layout in the destination. If the calculation must keep pointing to a particular cell, confirm that the formula still points to the intended cell after pasting. Do not assume that keeping the same cell address automatically preserves the original meaning.
Test the result and save the new workbook. Compare a few pasted results with the source, and check that cells display numbers or text rather than errors such as #REF! or #NAME?. If the destination is meant to work independently, close the source workbook and see whether the formulas still return the expected results. Then save the destination using Ctrl+S on Windows or Command+S on Mac. Choose an Excel workbook format such as .xlsx unless you specifically need a macro-enabled workbook.

Common Mistakes

Copying formulas without their inputs: A formula can paste successfully but show an error or an unexpected result because its source data, lookup table, or supporting sheet was left behind. Review dependencies before copying. When in doubt, copy the whole worksheet or include the required data range.

Assuming formula-only paste also copies formatting: The Formulas paste option is meant to transfer formulas, not the source cell’s styling. If the destination needs the same borders, colors, or number formats, use regular paste or apply formatting separately.

Overwriting destination data: Pasting a large selection into a populated area replaces its contents. Confirm the upper-left destination cell and the size of the copied range before you paste.

Ignoring workbook links: References to sheets that remain only in the source workbook can become external links. Such formulas may work while both files are available but can show link prompts or fail if the source file is moved, renamed, or unavailable.

Using Cut instead of Copy: Ctrl+X moves the selected cells rather than making a safe duplicate. Use Ctrl+C unless you deliberately want to remove the original cells. Also remember that copying formulas to a different location can adjust relative references.

Tips

Use the whole-sheet copy method when the calculation is tied closely to one sheet’s layout, formatting, and supporting cells. It gives you more context than copying a small formula range, although formulas that refer to other tabs still need attention. Copy any required supporting tabs as well, then review whether cross-sheet references point to the copied tabs or the original file.

For a clean handoff, decide whether the new workbook should remain linked to the source. Links are useful when the destination should update from a central source file. If it should stand alone, bring over the required sheets and data, then inspect the formulas and any link warnings. Do not break links casually: converting linked formulas to fixed values removes their ability to update.

Use a small test before transferring a large range. Copy a few representative formula cells, paste them into the destination, and confirm both the displayed results and the references shown in the formula bar. This can reveal an unexpected shift or external link before it affects a whole report.

Keep a copy of the original destination if it contains important information. Saving a new file under a different name makes it easier to compare the result and recover if you paste into the wrong area. Excel’s Undo can reverse a recent paste, but saving a separate copy is a safer precaution when many cells or sheets are involved.

Troubleshooting

The pasted cell shows #REF!: The formula refers to a cell or sheet Excel can no longer find. Check the formula bar for the missing reference. Copy the needed source sheet or data into the destination, or edit the formula to point to the correct destination range.

The formula points to the old workbook: This can happen when a formula depends on a worksheet that was not included in the copy. If the link is intentional, keep the source workbook in a stable location. If it is not, copy the required tab into the destination and update the formula references. Then test with the source closed.

The answer changes after pasting: Check whether relative references shifted because the destination range starts in a different location. Compare a source formula with its pasted counterpart in the formula bar. Paste at the matching position or edit the references to fit the new layout. Confirm that the source cells contain the same input values before judging the result.

Paste Special is unavailable or behaves differently: Make sure you copied cells in Excel rather than text from another application, and select a compatible destination cell. Try Home > Paste > Formulas from the ribbon. Excel for the web has a more limited interface than desktop Excel, so if a particular paste option is missing, open the files in the desktop app and repeat the paste there.

Results do not update: First check whether the pasted formulas are still formulas by selecting a cell and looking at the formula bar. If they are formulas but results appear stale, press F9 to recalculate in Windows Excel. If calculation is set to manual, choose Formulas > Calculation Options > Automatic. On Mac, use the Formulas tab to find Calculation Options; menu placement may differ by build.

Frequently Asked Questions

Can I copy formulas without copying formatting?
Yes. Copy the cells, select the destination, and choose Home > Paste > Formulas. The destination keeps its existing formatting while receiving the formulas.

Will formulas keep working if I move them to a different cell?
Usually, but relative references adjust based on the new position. Check the formula bar and verify the result, especially when the destination layout differs from the source.

How do I copy formulas and keep references to other sheets?
Copy the referenced worksheets into the destination too, then check the formulas. If the referenced sheet is not in the destination, Excel may refer back to the source workbook instead.

Can I copy an entire worksheet into a new workbook?
Yes. Right-click the sheet tab, choose Move or Copy, select (new book) in To book, check Create a copy, and click OK. Save the new workbook afterward.

Can I do this in Excel for the web?
You can copy cells between workbooks using the browser’s Excel interface, but available paste choices and sheet-management options can differ. Use desktop Excel for Windows or Mac if you need a particular Paste Special option or cannot copy a sheet between workbooks.

Should I paste formulas or values?
Paste formulas when the new workbook should recalculate as its inputs change. Paste values when you need fixed results that no longer depend on the original calculations; choose the Values option from the Paste menu for that purpose.

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.