Keyboard Shortcut needed...

**lovinggood** · 08-23-2007, 02:32 PM

Is there a keyboard shortcut that allows me to edit a particular cell (once the cell is highlighted) without using the mouse to move to the formula bar?

I guess I'm just too lazy to move my hand from the keyboard to the mouse.

Thanks in advance...

**Ron Coderre** · 08-23-2007, 02:35 PM

Perhaps my favorite Excel setting.....

<tools><options><edit tab>
UNcheck: Edit directly in cell

After that, when you press [F2] the cursor will be in the formula bar.

Does that help?

**lovinggood** · 08-23-2007, 02:54 PM

Ron,
I've been trying to figure that out for years!
I couldn't even find it in the book that I purchased (Execel for dummies).
You have given me new life.
I thank you tremendously!