View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Zakynthos Zakynthos is offline
external usenet poster
 
Posts: 115
Default 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)