Copy Formula Problem

[Guest]

I am trying to copy a formula from one cell to another but when I paste
it into the new cell the column and row number changes to the new
cell that I am pasting it into. How can I make it stay the same as the
original ?

Thanks - George

 

[Roger Govier]

Hi George

Instead of copying the cell, then pasting, highlight the cell, but then
mark the formula in the formula bar at the top of the sheet and copy
that, then press escape.
Now, navigate to your destination cell and paste.

 

[Guest]

Thanks Roger...

Hi George

Instead of copying the cell, then pasting, highlight the cell, but then
mark the formula in the formula bar at the top of the sheet and copy
that, then press escape.
Now, navigate to your destination cell and paste.

 

[tony h]

You may also want to consider using $ in the formulae. A $ prefix fixes
that part of the cell reference

so a formula of =$A$10 will copy and paste (or drag) as $A$10.
Whereas =A$10 will go to B$10 C$10 etc
and
=$A10 will go to $A11 $A12 etc

hope this helps