Hi,

I've encountered a weird problem with Excel 2010. I have one column of
pure text cells and some of them will autocomplete and others will not
while typing duplicate entries.

Any ideas?

Thank you.