Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Autocomplete entry - Delete - How?
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Autocomplete entry - Delete - How?
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 buttonexcel optionsproofingAC options. Gord Dibben MS Excel MVP On Wed, 9 Dec 2009 10:39:15 -0500, "Joe727" wrote: 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Autocomplete entry - Delete - How?
Use the find and replace utility home find.
find the incorrect entery and replace it with the correct one "Joe727" wrote: 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 . |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Autocomplete entry - Delete - How?
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" <gorddibbATshawDOTca wrote in message ... 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 buttonexcel optionsproofingAC options. Gord Dibben MS Excel MVP On Wed, 9 Dec 2009 10:39:15 -0500, "Joe727" wrote: 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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Autocomplete entry - Delete - How?
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 On Sun, 13 Dec 2009 12:54:52 -0500, "Joe727" wrote: 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" <gorddibbATshawDOTca wrote in message .. . 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 buttonexcel optionsproofingAC options. Gord Dibben MS Excel MVP On Wed, 9 Dec 2009 10:39:15 -0500, "Joe727" wrote: 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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Autocomplete entry - Delete - How?
I typed it in a cell that describes what the expense is for.
Joe "Gord Dibben" <gorddibbATshawDOTca wrote in message ... 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 On Sun, 13 Dec 2009 12:54:52 -0500, "Joe727" wrote: 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" <gorddibbATshawDOTca wrote in message . .. 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 buttonexcel optionsproofingAC options. Gord Dibben MS Excel MVP On Wed, 9 Dec 2009 10:39:15 -0500, "Joe727" wrote: 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 |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Autocomplete entry - Delete - How?
So change it.
And read help on Autocomplete and Autocorrect. There is a difference. Gord On Sun, 13 Dec 2009 14:20:29 -0500, "Joe727" wrote: I typed it in a cell that describes what the expense is for. Joe "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . 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 On Sun, 13 Dec 2009 12:54:52 -0500, "Joe727" wrote: 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" <gorddibbATshawDOTca wrote in message ... 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 buttonexcel optionsproofingAC options. Gord Dibben MS Excel MVP On Wed, 9 Dec 2009 10:39:15 -0500, "Joe727" wrote: 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 |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Autocomplete entry - Delete - How?
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 "Gord Dibben" <gorddibbATshawDOTca wrote in message ... So change it. And read help on Autocomplete and Autocorrect. There is a difference. Gord On Sun, 13 Dec 2009 14:20:29 -0500, "Joe727" wrote: I typed it in a cell that describes what the expense is for. Joe "Gord Dibben" <gorddibbATshawDOTca wrote in message . .. 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 On Sun, 13 Dec 2009 12:54:52 -0500, "Joe727" wrote: 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" <gorddibbATshawDOTca wrote in message m... 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 buttonexcel optionsproofingAC options. Gord Dibben MS Excel MVP On Wed, 9 Dec 2009 10:39:15 -0500, "Joe727" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete an repeatitive entry from a worksheet | Excel Worksheet Functions | |||
Deleting an unwanted AutoComplete entry | Excel Discussion (Misc queries) | |||
Delete Entry Based on Selection | Excel Discussion (Misc queries) | |||
how can I delete both parts of a duplicate entry in excel | Excel Discussion (Misc queries) | |||
How do I delete some words in autocomplete shortcut menu? | Excel Worksheet Functions |