Keyboard shortcut to auto insert $ sign into formula?
 

Is there a shortcut to do this?

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

Keyboard shortcut to auto insert $ sign into formula?
 

Hi

when you are in Edit mode press F4


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Zakynthos" wrote in message ...
Is there a shortcut to do this?

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

Keyboard shortcut to auto insert $ sign into formula?
 

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)

Keyboard shortcut to auto insert $ sign into formula?
 

Ron,

many thanks foryour help

Tony

"Ron de Bruin" wrote:

Hi

when you are in Edit mode press F4


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Zakynthos" wrote in message ...
Is there a shortcut to do this?

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

Keyboard shortcut to auto insert $ sign into formula?
 

Sebastien

many thanks for your help

Tony

"sebastienm" wrote:

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)