Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: Auto Sum function not working in large Excel file | Excel Discussion (Misc queries) | |||
Auto entry clock into a cell on tabbing into it | Excel Worksheet Functions | |||
Excel 2002 : Is there any active row bar to aid data entry ? | Excel Discussion (Misc queries) | |||
Auto Entry in a Cell | Excel Discussion (Misc queries) | |||
Auto fill cell entry | Excel Discussion (Misc queries) |