cut/pasting disturbs formula

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.
 
E

Earl Kiosterud

Ryan,

One way is to copy/paste instead of cut paste, then delete the original.
 
D

David McRitchie

If you copy from the formula bar then the adjustment won't take
place -- if that is what you are trying to avoid.
 
E

Earl Kiosterud

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
Click to expand...
 
Top