Instead of, for example, =A1, use =$A$1
This can also be achieved by pressing F4 when the cursor is on the address
in the formula bar.

--
Kind regards,

Niek Otten

"macsworks" wrote
in message ...

I wish to copy cells containing formula to another cell but when I paste
I want the
the formula I to have the same references as the original cell


--
macsworks
------------------------------------------------------------------------
macsworks's Profile:
http://www.excelforum.com/member.php...o&userid=29235
View this thread: http://www.excelforum.com/showthread...hreadid=489578