Excel 2002 : Can auto cell entry function more than once ?

[Mr. Low]

Dear Sir,

Lets consider the following worksheet :

A B
1 Texas 1
2 Texas 2
3 Texas 3
4 Texas 4
5 Texas 5


I find that Excel 2002 could help me in the entry of “Texas†when I key in T
at cell A2 only.

If I key in T in cell A3, this auto cell entry feature is not there, I need
to manually finish the entry.

Similarly it happens to cell A4, A5 and beyond.

Is there a way for me to set the worksheet so that the auto cell entry
feature could function more than once ?


Thanks

Low

 

[bj]

the auto entry will only show unique possibilities once you also have the
texas 2 entry there is not a unique entry for t

what you can do is goto tools-autocorrect
enter t in replace and Texas in the with block
you must remember to remove it later or it will happen always.

 

[Mr. Low]

Hello bj,

Thanks for the info.

Low