Deleting an unwanted AutoComplete entry
Autocomplete works by inspecting the values in the cells surrounding the
activecell.
The only way I know to remove any value from those autocomplete suggestions is
to remove those values from the surrounding cells.
Arlene wrote:
I have enabled AutoComplete for cell values so that Excel 2003 completes text
entries I start to type in a column of data. If the first few letters you
type match an existing entry in that column, Excel fills in the remaining
text for you. However, how do I delete an AutoComplete entry that I no longer
want and keep the rest?
--
Dave Peterson
|