How to copy formulas without...

How can I copy and paste the formulas from an existing spreadsheet into a new spreadsheet so that the formulas in the new sheet do not refer back to the existing sheet.

Formulas and Functions

fjlnyg

Copper Contributor

Aug 18, 2023

mathetes

Thank you so much for responding.

Just to be clear, the sheet is substantial. It has about fifteen tabs and there are dozens of cells with formulas in each tab.

When I do a copy and paste of an entire tab from the existing sheet, call it SHEET1 into a new sheet, call it SHEET2, every formula in SHEET2 begins with the reference to SHEET1.

For example, if the formula in a cell in SHEET1 is:

='Income'!BF7

Then the formula for that cell in SHEET2 shows up as:

='[SHEET1.xlsx]Income'!BF7

I want is the formula in SHEET2 to not have the [SHEET1.xlsx] component in it.