| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keyboard shortcut for Auto-filter | Excel Discussion (Misc queries) | |||
| Keyboard shortcut to insert comment in excel | Excel Discussion (Misc queries) | |||
| Keyboard shortcut to insert a checkmark | Excel Programming | |||
| Keyboard shortcut to insert a checkmark | Excel Programming | |||
| Keyboard shortcut to insert a checkmark | Excel Programming | |||
Linear Mode
