Hi Velu,

Replacing formula in one row is possible as per your method. But my requirement is to change all the formulas.
It's no like that.. rather I have said below:-

To replace anything in formula OR to edit formula, select the formula range (or if it is entire workbook, then select any one formula), press Ctrl +H..
so you can replace entire workbook's formula.. as per your example.. column 14 contains $P14*$L14..
not what you need to replace.. I can replace $P14 to $L14.. to do that... I'll select the entire column 14 and press ctrl + H - rest process, I have given in post#6. thanks.

regards,
DILIPandey

<click on below 'star' if this helps>