Keyboard shortcut to 'Formula Bar' ?
 

I have an Excel sheet where I need to do lots of updates -
entering/updating data mostly. If I navigate to a cell, the easiest way
to update is from the 'Formula Bar' near the top of Excel. In order to
go there I have to click the mouse in the Formula Bar. After several
hundred clicks my wrist usually gets very tired.

The question: is there a keyboard shortcut that moves the cursor into
the Formula Bar, rather than removing my hand from the keyboard, seeking
the mouse, moving to the Formula Bar, and clicking in it?

P.S. Excel 2003, b.t.w.

Keyboard shortcut to 'Formula Bar' ?
 

F2

"Pat Willener" wrote:

I have an Excel sheet where I need to do lots of updates -
entering/updating data mostly. If I navigate to a cell, the easiest way
to update is from the 'Formula Bar' near the top of Excel. In order to
go there I have to click the mouse in the Formula Bar. After several
hundred clicks my wrist usually gets very tired.

The question: is there a keyboard shortcut that moves the cursor into
the Formula Bar, rather than removing my hand from the keyboard, seeking
the mouse, moving to the Formula Bar, and clicking in it?

P.S. Excel 2003, b.t.w.

Keyboard shortcut to 'Formula Bar' ?
 

F2 will put you into the formula bar in edit mode.


Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 18:12:39 +0900, Pat Willener
wrote:

I have an Excel sheet where I need to do lots of updates -
entering/updating data mostly. If I navigate to a cell, the easiest way
to update is from the 'Formula Bar' near the top of Excel. In order to
go there I have to click the mouse in the Formula Bar. After several
hundred clicks my wrist usually gets very tired.

The question: is there a keyboard shortcut that moves the cursor into
the Formula Bar, rather than removing my hand from the keyboard, seeking
the mouse, moving to the Formula Bar, and clicking in it?

P.S. Excel 2003, b.t.w.

Keyboard shortcut to 'Formula Bar' ?
 

I should have said "F2 will put you into edit mode in the cell"


Gord

On Thu, 12 Jul 2007 07:42:08 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

F2 will put you into the formula bar in edit mode.


Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 18:12:39 +0900, Pat Willener
wrote:

I have an Excel sheet where I need to do lots of updates -
entering/updating data mostly. If I navigate to a cell, the easiest way
to update is from the 'Formula Bar' near the top of Excel. In order to
go there I have to click the mouse in the Formula Bar. After several
hundred clicks my wrist usually gets very tired.

The question: is there a keyboard shortcut that moves the cursor into
the Formula Bar, rather than removing my hand from the keyboard, seeking
the mouse, moving to the Formula Bar, and clicking in it?

P.S. Excel 2003, b.t.w.

Keyboard shortcut to 'Formula Bar' ?
 

Thanks; F2 is exactly what I was looking for. Funny that I was unable to
find that information in Excel Help. I guess if I had typed "F2" I would
have found it...

Gord Dibben wrote:
I should have said "F2 will put you into edit mode in the cell"


Gord

On Thu, 12 Jul 2007 07:42:08 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

F2 will put you into the formula bar in edit mode.


Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 18:12:39 +0900, Pat Willener
wrote:

I have an Excel sheet where I need to do lots of updates -
entering/updating data mostly. If I navigate to a cell, the easiest way
to update is from the 'Formula Bar' near the top of Excel. In order to
go there I have to click the mouse in the Formula Bar. After several
hundred clicks my wrist usually gets very tired.

The question: is there a keyboard shortcut that moves the cursor into
the Formula Bar, rather than removing my hand from the keyboard, seeking
the mouse, moving to the Formula Bar, and clicking in it?

P.S. Excel 2003, b.t.w.

Keyboard shortcut to 'Formula Bar' ?
 

Did you try looking up "Shortcut Keys", It's listed under Edit Data.

Pat Willener wrote:

Thanks; F2 is exactly what I was looking for. Funny that I was unable to
find that information in Excel Help. I guess if I had typed "F2" I would
have found it...

Gord Dibben wrote:

I should have said "F2 will put you into edit mode in the cell"


Gord

On Thu, 12 Jul 2007 07:42:08 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

F2 will put you into the formula bar in edit mode.


Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 18:12:39 +0900, Pat Willener

wrote:

I have an Excel sheet where I need to do lots of updates -
entering/updating data mostly. If I navigate to a cell, the easiest
way to update is from the 'Formula Bar' near the top of Excel. In
order to go there I have to click the mouse in the Formula Bar.
After several hundred clicks my wrist usually gets very tired.

The question: is there a keyboard shortcut that moves the cursor
into the Formula Bar, rather than removing my hand from the
keyboard, seeking the mouse, moving to the Formula Bar, and clicking
in it?

P.S. Excel 2003, b.t.w.