I'm transcribing a census in Excel2007 and I find that the autocomplete
option is very useful, However my problem occurs when I have a common name
like John, and along comes johanna, or as in place names, Lambeth, which
occurs very often and then I come across Lamberhurst, as I'm transcribing
rows in their many hundreds, I find this a pain in the b...I know that I can
uncheck autocomplete for that single entry, but if only I could find a way of
removing/deleting Johannah, Lamberhurst et al from the autocomplete drop down
list, it would save me hours of unpaid voluntary work
I've searched and searched for the answer.I bet someone out there can help me!

Cheers, Mike