I don’t think so it is Excel 2010 problem. Because when there is an empty cell in between the data and if you are typing after an empty cell then the auto complete wont work in excel. When the data’s are continuous then the sutocomplete will work fine.

---

Sixthsense


On Saturday, July 23, 2011 6:40:11 PM UTC+5:30, Jennifer wrote:
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.