I often have to fix and then unfix cell references using the $ sign to fix
and then find and replace to unfix.

Is there a menu option to fix column / fix row / fix reference (and unfix).
If there is I cant find it.