View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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)