I want to copy formulas with relative references to another range without changing the formula / updating those relative references. I know there are some paid add-ons that do that but I'm not looking to give money to people for something this simple.

Example:

A1 contains `=C2+B3`

(and is functioning/resolving)

Copy A1 into X1

X1 now contains `=C2+B3`

(and is functioning/resolving)

I do this and then i slightly modify the new copy of formulas via replacements and other means. (So i need them functional and not paste special - links)

Currently, I just replace `=`

with `x=`

, copy/paste, and then replace `x=`

with `=`

. I've seen people over the years use fancier ways via native XLS functionality but I don't know how. I need to do this for hundreds of different formulas at once so copying/pasting the formula from each one individually is not going to work.

/// There is an incomplete solution left to figure out:

Change cell format to text. Type `=A1`

now you get just text. Changing the format back to general doesn't resolve the formula. How can we resolve an array of these to start working as formulas again, not just text? (Other than going into every single one and pressing enter)

... (and for anyone curious Kutools add-on does that - exact copy)

same exact formulashowing in A1? Wemightbe working on an XY Problem - can you describe the purpose/main idea behind what you're trying to do?