cut/pasting disturbs formula

  • Thread starter Thread starter Ryan H.
  • Start date Start date
R

Ryan H.

Hi,

Lets say I placed the number 5 in cell A1 and the number 7 in cell B1, and
then placed the formula =A1+B1 in cell C1.

Now lets say I cut cell B1 and pasted it in cell E6. The formula in cell C1
will automatically change to =A1+E6.

How can I stop this from happening? How can I make static references to
certain cells?

I've even tried changing the formula to =$A$1+$B$1 but that didn't work.
 
Ryan,

One way is to copy/paste instead of cut paste, then delete the original.
 
If you copy from the formula bar then the adjustment won't take
place -- if that is what you are trying to avoid.
 
David,

If he copies the number from the formula bar, then he still must delete the
original cell.

You may be thinking that he's copying the formula, and getting relative cell
adjustments. I think he's instead cutting/pasting a precedent cell,
resulting in a change to the formula reference, since cut/paste is an
effective move of the cell (and there ain't NO stopping that! <g>).

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

David McRitchie said:
If you copy from the formula bar then the adjustment won't take
place -- if that is what you are trying to avoid.
Click to expand...
 
Back
Top