Hi AK

not AFAIK, however F4 is the shortcut key for this and takes you through a
cycle of
A1 - column & row relative
$A$1 - column & row absolute
A$1 - column relative & row absolute
$A1 - column absolute & row relative

would using a mixed absolute / relative reference solve your problem?

Cheers
JulieD


"AK" wrote in message
...
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.