Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

quick key to go to formula bar

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
steveb - 25 Jul 2006 02:46 GMT
Is there a quick key for jumping from a cell to the formula bar?
thanks,
sb
Peo Sjoblom - 25 Jul 2006 02:54 GMT
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
FSt1 - 25 Jul 2006 02:57 GMT
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
davesexcel - 25 Jul 2006 02:57 GMT
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
Chip Pearson - 25 Jul 2006 04:08 GMT
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

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.