Excel Autocomplete entry - Delete - How?

[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

 

[Gord Dibben]

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

 

[DreamKid]

Use the find and replace utility home>> find.
find the incorrect entery and replace it with the correct one

 

[Joe727]

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

 

[Gord Dibben]

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

 

[Joe727]

I typed it in a cell that describes what the expense is for.

Joe

 

[Gord Dibben]

So change it.

And read help on Autocomplete and Autocorrect.

There is a difference.


Gord

 

[Joe727]

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