On Nov 29, 11:25 am, Gord Dibben <gorddibbATshawDOTca wrote:
Maybe =$G$6 will do.

Gord Dibben MS Excel MVP



On Wed, 28 Nov 2007 15:55:29 -0800 (PST), wrote:
Hi,

I have a formula in a cell, say, =G6. How can I copy this formula to
another cell. At present, when I copy the formula changes because it
is not referenced. When I copy, paste special with formulas the
formula still moves. Anyone have a solution without cutting and
pasting or referencing the cell ?

Thanks,
Tom- Hide quoted text -

- Show quoted text -

Thanks for the suggestions. But is there an alternative to using the $-
signs and making the cell refence absolute ?

Tom