quick key to go to formula bar

  • Thread starter Thread starter Guest
  • Start date Start date
Yes and no, if you go to tools>options>edit and uncheck edit directly in
cell, then you can press F2 to get there
If you have edit directly in cell checked then you can press f2 to get into
the cell but not the formula bar


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
 
hi,
go to Tools>options>edit tab. uncheck Edit directly in cell.
pressin the space bar will put in in the formula bar.

regards
FSt1
 
Not if you want to edit what is in the cell.

But, technically you're correct........it is a quick way to jump from cell to
formula bar.


Gord Dibben MS Excel MVP
 
There is no built in shortcut to go to the formula bar. I, like I
thing most users, use F2 to edit in cell. If, however, you want a
keyboard shortcut to the formula bar, you can put the following
procedure in a regular code module in your Personal.xls workbook
and assign a shortcut key to it.

Public Declare Function SetFocus Lib "user32" (ByVal hwnd As
Long) As Long
Public Declare Function FindWindow Lib "user32" Alias
"FindWindowA" _
(ByVal lpClassName As String, ByVal lpWindowName As String)
As Long
Public Declare Function FindWindowEx Lib "user32" Alias
"FindWindowExA" _
(ByVal hWnd1 As Long, ByVal hWnd2 As Long, _
ByVal lpsz1 As String, ByVal lpsz2 As String) As Long

Sub SetFocusFormulaBar()
SetFocus FindWindowEx(FindWindow("XLMAIN",
Application.Caption), _
0&, "EXCEL<", vbNullString)
End Sub



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
pressing F2 should get you there

That will work only if "Edit directly in cell" is disabled.
Otherwise, you'll be editing in the cell, not the formula bar.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"davesexcel"
in message
news:[email protected]...
 
Back
Top