The autocomplete list is comprised of the data in contiguous cells above or
below the point at which you are typing.

To remove any from the list, delete from the cell(s) above or below.

If you have made a mistake when you are choosing from the list just hit CTRL
+ z to undo.


Gord Dibben MS Excel MVP

On Mon, 6 Oct 2008 14:34:31 -0700, mikelmendit
wrote:

Thanks for replying, but the point is repetition.......for instance Lambeth
is just one of very many instances, I might enter lambeth as place of birth
50 times out of 400 entries in each piece of transcription, by typing L
lambeth would occur in cell, so with lamberhurst, I have to overtype
practically the whole word 50 times............all I want to know is if I
happen to make a mistake by entering this sort of word, how can I edit it
from the cell drop-down list
I have a 720 page manual on 2007 here,but cannot find reference to editting
this list :-(
Still need your help ............Thanks
"Spiky" wrote:

On Oct 6, 8:01 am, mikelmendit
wrote:
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

How does the autocomplete slow you down? Even if you have to type more
characters than for some words, like "Lamber", isn't that still less
than "Lamberhurst"?