Excel - default to edit mode?

[Danny@Kendal]

When entering or editing formulas in Excel2000 I find myself by habit using
cursor keys when editing formulas. Instead of moving the cursor this inserts
cell references which I find annoying.

A quick Googling reveals that pressing F2 switches to edit mode where the
cursor keys work as I want them to.

Are there any settings in Excel2000 so that by default it uses edit mode,
not only on cell formulas but also in data validation or conditional
formatting formula boxes?

 

[David McRitchie]

A quick Googling reveals that pressing F2 switches to edit mode where the

cursor keys work as I want them to.

Tools, Options, Edit, [x] edit directly in cell
click on the [?] and drag to the option to find out what that means

Select the edit directly in cell check box to edit inside
a cell by double-clicking the cell, rather than editing
the cell contents only in the formula bar.

You can't just be in edit mode all the time, it would interfere with
your use.

 

[Danny@Kendal]

A quick Googling reveals that pressing F2 switches to edit mode where the
cursor keys work as I want them to.

Tools, Options, Edit, [x] edit directly in cell
click on the [?] and drag to the option to find out what that means

Select the edit directly in cell check box to edit inside
a cell by double-clicking the cell, rather than editing
the cell contents only in the formula bar.

You can't just be in edit mode all the time, it would interfere with
your use.

I meant use edit mode by default only when entering data or formulas so that
I can use the cursor keys in the same way that I do in almost every other
piece of software.

I'd like to keep the "edit directly in cells" feature but change something
so that pressing cursor keys doesn't automatically insert cell references
into formulas.

Ah well, I guess I'll just have to remember to keep pressing F2. Thanks for
the help.