Hi,

Put the $ sign before the reference, which you want to freeze (do not move).

Thanks
--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"Sooky-la-la" wrote:

I have a formula in a cell A1x3, how do i copy it to cells below, without
having to change it to A2 x3, A3 x 3 etc?