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

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

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

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

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


.