How to activate the cursor in the Formula Bar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

erichofley@yahoo.com - 27 Jan 2006 23:30 GMT

I navigate from cell to cell with the keyboard arrow keys. What
keyboard shortcut/command can I use to activate/place the cursor in the
formula bar, so I can then navigate through text in the formula bar
using the arrow keys? (i.e. It is a hassle to take my hand off the
keyboard and grab the mouse to place the cursor in the formula bar).
Thanks.

Reply to this Message

CyberTaz - 28 Jan 2006 00:06 GMT

The only way I know of without adding code is to go to
Excel>Preferences>Edit, remove the check for 'Edit directly in cell', which
will cause Control+U to put you where you want to be.

Down side is that you will _only_ be able to _edit_ in the Formula Bar,
although you will still be able to enter new/replacement content directly
into a cell without having to go to the Formula Bar.

HTH |:>)

On 1/27/06 6:30 PM, in article
1138404625.947943.37940@z14g2000cwz.googlegroups.com, "erichofley@yahoo.com"

> I navigate from cell to cell with the keyboard arrow keys. What
> keyboard shortcut/command can I use to activate/place the cursor in the
> formula bar, so I can then navigate through text in the formula bar
> using the arrow keys? (i.e. It is a hassle to take my hand off the
> keyboard and grab the mouse to place the cursor in the formula bar).
> Thanks.

Reply to this Message

JE McGimpsey - 28 Jan 2006 06:01 GMT

Take a look here:

http://www.mcgimpsey.com/macoffice/excel/f2.html

Reply to this Message

Mac Forum / Applications / Excel / January 2006

How to activate the cursor in the Formula Bar