shortcut key to formula bar

K

kendrick88

Hi can I navigate to formula bar using shortcut key instead of using mouse?
appreciate yr help.
 
D

Dave Peterson

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)
 
S

Suleman Peerzade

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)
 
S

Suleman Peerzade

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keyboard shortcut to 'Formula Bar' ? 5
/ keyboard key doesn't work in Excel 2007 1
shortcut key to go to formula bar 2
Keyboard shortcuts 5
Edit formula while entering Excel 2000 5
Shortcut for sheet tabs, name box, outline buttons 1
shortcut mouse right side key 1
Shortcut Key Creation 2

Top