Hi. I have an Excel document at work containing some drop down menus. I like
the Auto Complete feature that Excel uses and it has been working beautifully
except for this one column in my worksheet. For some reason it has stopped
auto completing and I am forced to either use the drop down menu or type the
whole thing in. :S

I have no spaces between rows, and I have made sure the Auto Complete
feature is switched on in the Options menu. It is working on my other columns
(regardless of whether they contain drop down menus or not). Any ideas?
Thanks so much.