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.

Oliver wrote:

Sometimes you need to to copy a range of cells with formulas without
adjusting - meaning any cells references remain unaltered. I know you can
$A$1 etc but sometimes you need to 'not adust' and then later adj etc. And
its worksome to input all the $'s and thn remove them. also I can move the
range instead of copy but the I lose the original range that I need.
Thank you.

--

Dave Peterson