Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to overcome inconsistancy in auto cell function ?
Dear Sir,
Lets consider the following worksheet: A 1 Penang 1 2 Penang 1 3 Penang 1 4 Penang 2 5 Penang 2 <-- Auto cell entry not functioning 6 Penang 2 <-- Auto cell entry not functioning 7 Tokyo 12 8 Tokyo 12 9 Tokyo 12 10 Tokyo 16 11 Tokyo 16 <-- Auto cell entry not functioning 12 Tokyo 16 <-- Auto cell entry not functioning I find that the Auto Cell Entry function very well from A2 to A3. However after I key in Penang 2 at A4, and when I input P at A5, the word Penang 2 does not come out automatically. I face similar problem at Cell A11 and A12 after I change the entry to Tokyo 16 at cell A10. Logically the same words should appear in the folowing cell if there is no alteration in the preceeding cell. May I know how to overcome the inconsistency of this function? Thanks Low -- A36B58K641 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 : Can auto cell entry function more than once ? | Excel Discussion (Misc queries) | |||
Excel 2002: Auto Sum function not working in large Excel file | Excel Discussion (Misc queries) | |||
Excel date input inconsistancy | Excel Discussion (Misc queries) | |||
How to overcome LOOKUP function problems? | Excel Worksheet Functions | |||
how to overcome excel file limitaions (65,000) records only? | Excel Discussion (Misc queries) |