| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
shortcut key to formula bar
Hi can I navigate to formula bar using shortcut key instead of using mouse?
appreciate yr help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
shortcut key to formula bar
Hit F2.
If you have Tools|Options|Edit tab|Edit directly in cell turned on, then you'll be editing within the cell--not in the formula bar. (xl2003 menu system) kendrick88 wrote: Hi can I navigate to formula bar using shortcut key instead of using mouse? appreciate yr help. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
shortcut key to formula bar
Hi,
There seems to be no shortcut key for to enter into formula bar. But there is a shortcut key that can take you to formula wizard. 1. ALT+I+F. This will take you to formula wizard/Insert function window and you can select what ever formula you want to enter.(excel 2003) -- Thanks Suleman Peerzade "Dave Peterson" wrote: Hit F2. If you have Tools|Options|Edit tab|Edit directly in cell turned on, then you'll be editing within the cell--not in the formula bar. (xl2003 menu system) kendrick88 wrote: Hi can I navigate to formula bar using shortcut key instead of using mouse? appreciate yr help. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
shortcut key to formula bar
Hi,
While doing some task i have come across one more way to do this. Tools/Options/View tab/ check the formula bar check box and Ok. By doing this the formula bar will appear below the menu bar you can either put the formula directly or just click the fx sign and the wizard will open. -- Thanks Suleman Peerzade "Suleman Peerzade" wrote: Hi, There seems to be no shortcut key for to enter into formula bar. But there is a shortcut key that can take you to formula wizard. 1. ALT+I+F. This will take you to formula wizard/Insert function window and you can select what ever formula you want to enter.(excel 2003) -- Thanks Suleman Peerzade "Dave Peterson" wrote: Hit F2. If you have Tools|Options|Edit tab|Edit directly in cell turned on, then you'll be editing within the cell--not in the formula bar. (xl2003 menu system) kendrick88 wrote: Hi can I navigate to formula bar using shortcut key instead of using mouse? appreciate yr help. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Absolute value with a quick formula / shortcut? | Excel Worksheet Functions | |||
| Keyboard shortcut to 'Formula Bar' ? | Excel Discussion (Misc queries) | |||
| use shortcut key to navigate to formula bar | Excel Discussion (Misc queries) | |||
| Shortcut in copying a formula that links 2 workbooks | Excel Discussion (Misc queries) | |||
| Excel shortcut key "Cut" Ctrl+X come up a formula to me why? | Excel Discussion (Misc queries) | |||
Linear Mode
