Perhaps one of the "Alfa Romeo" entries contains two space characters.
That could cause the problem that you described.

Instead of typing the entries, you could use a data validation list.
There are instructions in Excel's help, and he

http://www.contextures.com/xlDataVal01.html

Colin Foster wrote:
Hi Group,
Currently I have an issue with Autocomplete not working in a spreadsheet. in
a new record
The spreadsheet contains a filtered list (with no filters applied). In the
first column of this list are vehicle manufacturers (e.g. Ford, BMW, Nissan,
etc).
Sometimes the autocomplete works when I add in a new record, but most of the
time, it doesn't.
I've checked the obvious issue of blank rows & there aren't any. I've also
checked for any hidden rows.
The total number of unique vehicle manufacturers is 35, so I can't see that
being an issue.
Interestingly, Pick from List does work.
Also interestingly (or should this be frustratingly!) I have the
manufacturer "Alfa Romeo". This only autocompletes when I've hit the
spacebar before the letter R. The implication of this, is that I have a
manufacturer called "Alfa" - oh if it was only that simple!! Needless to
say, I don't.
This is beginning to really frustrate me, so any pointers would be of
interest - if you want a copy of the spreadsheet to play with, let me know.
Regards
Colin Foster




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html