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

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

--
A36B58K641

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

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" wrote:

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

--
A36B58K641

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

Hello bj,

Thanks for the info.

Low
--
A36B58K641


"bj" wrote:

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" wrote:

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

--
A36B58K641