Excel 2007 - Is it possible to purge Autocomplete?

[Andrew_alreadytaken]

Is it possible to purge all the Autocomplete entries, please?
I'd like to start afresh because many of my old entries start with identical text and the feature is not very useful like that.
Thank you.

 

[Ralston18]

Here is a "how to" link for Excel 2007 (covers other versions as well...)

http/spreadsheets.about.com/od/exceltips/qt/090622_autocomplete.htm

 

[Andrew_alreadytaken]

Hello,
Thanks for your kindness in responding.
However, it's not switching on/off that I need, it's purging the existing entries.
Unfortunately, switching on/off the feature does not clear the entries.

 

[Ralston18]

excel: File>options>proofing>AC options.

Do you see a box "AutoCorrect Options"?

Click and check.

May be in a custom dictionary - check also.

 

[rgd1101]

Hello,
Thanks for your kindness in responding.
However, it's not switching on/off that I need, it's purging the existing entries.
Unfortunately, switching on/off the feature does not clear the entries.

You can't purge existing entries, to excel, it doesn't know the different between you type it in or it was autocomplete.