|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Is there a quick key for jumping from a cell to the formula bar?
thanks,
sb
|
|
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
"steveb" <steveb[ at ]discussions.microsoft.com> wrote in message
news:D8930A72-5761-42C7-8892-C16DC5BB4B05[ at ]microsoft.com...
[Quoted Text] > 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
"steveb" wrote:
[Quoted Text] > Is there a quick key for jumping from a cell to the formula bar?
> thanks,
> sb
|
|
|
|
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 <FSt1[ at ]discussions.microsoft.com> wrote:
[Quoted Text] >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
>
>"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" <steveb[ at ]discussions.microsoft.com> wrote in message
news:D8930A72-5761-42C7-8892-C16DC5BB4B05[ at ]microsoft.com...
[Quoted Text] > Is there a quick key for jumping from a cell to the formula
> bar?
> thanks,
> sb
|
|
|
[Quoted Text] > 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"
<davesexcel.2bham7_1153792811.7096[ at ]excelforum-nospam.com> wrote
in message
news:davesexcel.2bham7_1153792811.7096[ at ]excelforum-nospam.com...
>
> pressing F2 should get you there
>
>
> --
> davesexcel
>
>
> ------------------------------------------------------------------------
> davesexcel's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=31708
> View this thread:
> http://www.excelforum.com/showthread.php?threadid=564549
>
|
|
|