The problem is that there isn't a unique value beginning with P (or
even Penang) after you put Penang 2 in cell A4, and autofill uses
unique values to suggest what the cell entry should be. If you entered
Pnang 2 instead, then autofill would be able to complete after you
type "Pn" (for Pnang 2) or "Pe" (for Penang 1). You could then use
Edit/Replace to change Pnang to Penang after you have typed them all
in. Similarly, you could enter Tkyo 16 in A10 and still retain the
autofill capability after two letters of input.

Hope this helps.

Pete

On Aug 1, 2:16 pm, Mr. Low wrote:
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