Hi
While in Edit mode in the cell containing the formula, put the cursor in a
part of the text containing a reference and press F4, it will cycle within
the 4 modes: A1, $A1, A$1, $A$1.

--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Zakynthos" wrote:

Is there a shortcut to do this?

In other words, to change (a1+b1) to ($a$1+$b$1)
or ($a1+$b1)