Edit formula while entering Excel 2000
 

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 :-)

Edit formula while entering Excel 2000
 

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 bartoolsoptionsedit tabcheck edit directly in cell.

regards
FSt1

"Kevryl" wrote:

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 :-)

Edit formula while entering Excel 2000
 

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

--


Gary Keramidas
Excel 2003


"Kevryl" wrote in message
...
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 :-)

Edit formula while entering Excel 2000
 

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.

"FSt1" wrote:

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 bartoolsoptionsedit tabcheck edit directly in cell.

regards
FSt1

"Kevryl" wrote:

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 :-)

Edit formula while entering Excel 2000
 

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

--


Gary Keramidas
Excel 2003


"Gary Keramidas" wrote in message
...
press F2 and you should see edit mode instead of enter mode down in the
task bar.

--


Gary Keramidas
Excel 2003


"Kevryl" wrote in message
...
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 :-)

Edit formula while entering Excel 2000
 

Gary! How beautifully simple! Thanks!

"Gary Keramidas" wrote:

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

--


Gary Keramidas
Excel 2003


"Gary Keramidas" wrote in message
...
press F2 and you should see edit mode instead of enter mode down in the
task bar.

--


Gary Keramidas
Excel 2003


"Kevryl" wrote in message
...
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 :-)


.