How do I delete some words in autocomplete shortcut menu?

[Paulette]

Autocomplete is not functioning as I want (in Excel) because some entries
appear twice. I don't know how I did it, but how do I remove the unwanted
entries in the shortcut menu so that it will autocomplete my entries again?

 

[Gord Dibben]

Autocomplete or "pick from list" is based on what you have entered in
contiguous cells above where you are not entering data.

There is no list saved anywhere that you can edit.

If words are repeated, there must be something different about them.

Perhaps a space in one and not the other?


Gord Dibben Excel MVP

 

[Gord Dibben]

Make that "above where you ARE entering data"


Gord