Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keyboard Shortcut | New Users to Excel | |||
keyboard shortcut for sum | Excel Discussion (Misc queries) | |||
Keyboard shortcut for Best Fit | Excel Discussion (Misc queries) | |||
Keyboard shortcut | New Users to Excel | |||
mag-keyboard shortcut | Excel Worksheet Functions |