Hi Mike-hime,

F2 will toggle this behavior on and off (notice that the status bar switches
between "Edit" to "Enter" when you hit F2 while editing a cell). So if
you're editing a formula and want to use the arrow keys to move in the
formula bar, you should hit F2 first. I don't think there is a global
option to turn that feature off.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Mike-hime wrote:
Thanks for the help. Your suggestion was excellent :)

Now maybe you can help me something else.

While I am editing formulas in Excel if I use any navigation keys on
the keyboard, Excel inserts relative cell references automatically.
(For instance, pressing left adds a relative cell reference to the
cell just left of the active cell.) If I can't find where to turn
this feature off in Excel's options, I *WILL* kill myself. I prefer
to type cell references (Relative or Absolute,) manually and use the
arrow keys to navigate while I edit.

I'm sure I'm just over looking the check box somewhere, so I figured
one of the experienced users could probably tell me right off the top
of their head.

Thx again,

-Mike-hime