Assuming FC identified your need, here are a couple possibilities.

If you have several formulas to copy, do a Find/Replace with =/zzz= to kill
the formulas. Then copy to another location and undo the kill with
zzz/(nothing). I do this when lookups are bogging down the calculations and
I replace formulas with values.

Consider using named ranges. Names dont change when you copy or move
formulas. The formula must be devoid of battleship grid names. Setting up
named ranges is a bit of a nuisance, and using them is another effort. But
the formulas can be crystal clear: =Cats+Dogs instead of =A33+B19.


"FC" wrote:

If by any chance you mean that you don't want the formula to change ( same
column and same row from the original ) when you paste it in another cell
then do this: select the cell with the formula to copy.
go to the formula bar and highlight the whole formula.
press f4 once.
press enter.
copy and paste in another cell.
If this is not what you are looking for then please give more details.

"texbetty" wrote:

I'm a self-taught Excel user (semi-intermediate level), although I'm having a
"formula" problem:
When I copy the "value" of a cell from cell A (which contains a formula)€¦.
And paste special to cell B (for value only)€¦. I don't want the contents in
cell A to change. I wish for them to stay as a formula. Can this be done?
My setting under TOOLS is for the calc = Automatic.

I use massive formulas on a month-to-month basis and have to constantly
double-check my "copied from formulas" to ensure they are edited back to a
formula.
texbetty