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

Signature
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
> Is there a quick key for jumping from a cell to the formula bar?
> thanks,
> sb
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
> Is there a quick key for jumping from a cell to the formula bar?
> thanks,
> sb
Gord Dibben - 25 Jul 2006 03:26 GMT
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
>hi,
>go to Tools>options>edit tab. uncheck Edit directly in cell.
[quoted text clipped - 6 lines]
>> thanks,
>> sb
pressing F2 should get you there

Signature
davesexcel
Chip Pearson - 25 Jul 2006 04:11 GMT
> 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.

Signature
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"davesexcel"
>
> pressing F2 should get you there
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

Signature
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
> Is there a quick key for jumping from a cell to the formula
> bar?
> thanks,
> sb