| Home |
| Search |
| Today's Posts |
|
#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) |
| 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 | |||
Threaded Mode
