ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   shortcut key to formula bar (https://www.excelbanter.com/excel-discussion-misc-queries/170601-shortcut-key-formula-bar.html)

kendrick88

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

Dave Peterson

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

Suleman Peerzade[_2_]

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


Suleman Peerzade[_2_]

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



All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com