Pasting formulas but not the links help needed

Z

zilla37

How can I paste a formula onto a seperate spreadsheet from a template I
made but not have the link from the template included in the formula?
 
D

Dave Peterson

If it's just one cell, I copy it from the formula bar and paste into the formula
bar.

If it's a bunch of cells, I do this:

Select the range to copy
edit|Replace
what: =
with: $$$$$
replace all

Do the copy|paste while my "formulas" are just text.

Tnen reverse it (in both locations).
edit|Replace
what: $$$$$
with: =
replace all

And the Text formulas will change back to formula formulas.
 
Z

Zilla

It works. Thanks for the help
Dave said:
If it's just one cell, I copy it from the formula bar and paste into the formula
bar.

If it's a bunch of cells, I do this:

Select the range to copy
edit|Replace
what: =
with: $$$$$
replace all

Do the copy|paste while my "formulas" are just text.

Tnen reverse it (in both locations).
edit|Replace
what: $$$$$
with: =
replace all

And the Text formulas will change back to formula formulas.
Click to expand...
 
Top