Copy and Replicate exact formulas

[Richhall]

Hi

I have a range with formulas in, say A1:F50. I want to copy the exact
formulas over to G1:L50, but if I select the range and copy and paste,
it changes all the values in the formulas, when I want an exact
replica, not adjusted ones? How can I do this? At the moment I'm doing
it and just doing a bulk find and replace for each bit back to the
original. I've been into paste special, and just selected formulas,
but is still amends the formulas.

Cheers

Rich

 

[Guest]

Hi Rich,

Are these formulas that if you copy one then you could simply copy the rest
down the column? If so, you can copy the formula in one cell by highlighting
it in the Formula Bar and copy, then press return, and then paste to the new
location. This way you do not loose the original cell references.

Don't forget to press Return after copy and before you click in the new cell
to paste otherwise you will mess up the original formula.

I don't know of a way to copy multiple cells this way but perhaps someone
else does.

Regards,

OssieMac

 

[Richhall]

Hi, yes unfortunately this is the only other way I could do it, and
found the find and replace quicker! THanks for your help.

 

[Dave Peterson]

You could select a1:f50
change all the formulas to strings
edit|replace
what: =
with: $$$$$=
replace all

Copy and paste to G1:L50
and select a1:f50 and g1:l50
and change all the strings back to formulas
edit|replace
what: $$$$$=
with: =
replace all

 

[Guest]

Press Ctrl+` (for formula auditing mode) then copy range A1:F50 by pressing
ctrl+C twice and paste with clipboard icon. Press Ctrl+` again to show values.
[For smaller ranges, undo and paste special as text so that only text is
pasted]