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

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.

--
Regards

Roger Govier


"George" wrote in message
...
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

Thanks Roger...


"Roger Govier" wrote:

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.

--
Regards

Roger Govier


"George" wrote in message
...
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

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


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=547106