Edit formula while entering Excel 2000

[Kevryl]

Is there a way, such as a key combination of enabling the cursor to navigate
a formula or line of data while composing it, before its actually entered,
and without going to the formula bar to do it?
Yeah....I know its niggly, but its niggled me for a long time

 

[FSt1]

hi
basicly 2 ways to do it. in the formula bar or directly in cell.
you seems to know about the formual bar so to edit directly in cell....
on the menu bar>tools>options>edit tab>check edit directly in cell.

regards
FSt1

 

[Gary Keramidas]

press F2 and you should see edit mode instead of enter mode down in the task
bar.

 

[Kevryl]

Wow... thanks for responding so quickly.

Unfortunately that works only once the data or fornmula has been entered.
While you are actually typing the data for a new entry, moving the arrow keys
only results in entering the mistyped entry and moving to the adjacent cell.

 

[Gary Keramidas]

sorry, meant status bar. too much windows beta testing.<g>

 

[Kevryl]

Gary! How beautifully simple! Thanks!

sorry, meant status bar. too much windows beta testing.<g>

--


Gary Keramidas
Excel 2003




.