Excel Autocomplete entry - Delete - How?

  • Thread starter Thread starter Joe727
  • Start date Start date
J

Joe727

Hi - I have Excel 2007 which is part of Office 2007 Professional running on
XP Pro SP3. The autocomplete function on a descriptive cell is terrific.
Howerver, I mistyped an entry.

Question: How do I delete an incorrect descriptive cell entry in Excel
2007?

Thanks

Joe
 
Autocomplete or AutoCorrect?

For autocomplete simply delete the incorrect data.

For AutoCorrect you must delete the entry from the AC list

To access the list hit office button>excel options>proofing>AC options.


Gord Dibben MS Excel MVP
 
Use the find and replace utility home>> find.
find the incorrect entery and replace it with the correct one
 
Here's an example of what I am trying to do: Instead of Travel, I want to
type travel.

However, when I type travel, it automatically changes to Travel, because I
originally mistyped it as Travel instead of travel.

How do I delete Travel from the autocomplete dictionary?

Joe
 
Re-read my reply.

Where did you mistype "Travel" originally?

In a cell above where you are attempting to type "travel"?

Or in the AutoCorrect List?


Gord
 
So change it.

And read help on Autocomplete and Autocorrect.

There is a difference.


Gord
 
I have changed it, but it still reverts to the capitalized version when I
make later entries. There must be some place where the capitalized version
is stored so that it can be manually deleted.

This appears to be a function of autocomplete.

Joe
 
Back
Top