Is there a quick key for jumping from a cell to the formula bar?
thanks,
sb

Yes and no, if you go to toolsoptionsedit 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


"steveb" wrote in message
...
Is there a quick key for jumping from a cell to the formula bar?
thanks,
sb

hi,
go to Toolsoptionsedit tab. uncheck Edit directly in cell.
pressin the space bar will put in in the formula bar.

regards
FSt1

"steveb" wrote:

Is there a quick key for jumping from a cell to the formula bar?
thanks,
sb

pressing F2 should get you there


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=564549

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

On Mon, 24 Jul 2006 18:57:01 -0700, FSt1 wrote:

hi,
go to Toolsoptionsedit tab. uncheck Edit directly in cell.
pressin the space bar will put in in the formula bar.

regards
FSt1

"steveb" wrote:

Is there a quick key for jumping from a cell to the formula bar?
thanks,
sb

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






"steveb" wrote in message
...
Is there a quick key for jumping from a cell to the formula
bar?
thanks,
sb

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"
wrote
in message
...

pressing F2 should get you there


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread:
http://www.excelforum.com/showthread...hreadid=564549