Edit formula while entering Excel 2000

  • Thread starter Thread starter Kevryl
  • Start date Start date
K

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 :-)
 
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
 
press F2 and you should see edit mode instead of enter mode down in the task
bar.
 
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.
 
Back
Top