Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting an unwanted AutoComplete entry
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting an unwanted AutoComplete entry
How do I remove the values from the surrounding cells?
"Dave Peterson" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting an unwanted AutoComplete entry
Select the cells and hit the delete key?????
Are you sure you want to do this? Arlene wrote: How do I remove the values from the surrounding cells? "Dave Peterson" wrote: 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 -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting an unwanted AutoComplete entry
I just realized what you meant by cell values--sorry. I discovered a
workaround. If I type a space before the cell value that is causing the autocomplete entry to appear, it stops it from appearing automatically while still retaining it in the drop down list. "Dave Peterson" wrote: Select the cells and hit the delete key????? Are you sure you want to do this? Arlene wrote: How do I remove the values from the surrounding cells? "Dave Peterson" wrote: 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 -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting an unwanted AutoComplete entry
Careful with this Arlene.
An extra space in the cell will cause problems down the road when sorting, filtering and other functions. The cells prefaced with a space will sort before those without. Gord Dibben MS Excel MVP On Mon, 6 Nov 2006 10:50:01 -0800, Arlene wrote: I just realized what you meant by cell values--sorry. I discovered a workaround. If I type a space before the cell value that is causing the autocomplete entry to appear, it stops it from appearing automatically while still retaining it in the drop down list. "Dave Peterson" wrote: Select the cells and hit the delete key????? Are you sure you want to do this? Arlene wrote: How do I remove the values from the surrounding cells? "Dave Peterson" wrote: 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 -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting an unwanted AutoComplete entry
Thanks for the heads up.
"Gord Dibben" wrote: Careful with this Arlene. An extra space in the cell will cause problems down the road when sorting, filtering and other functions. The cells prefaced with a space will sort before those without. Gord Dibben MS Excel MVP On Mon, 6 Nov 2006 10:50:01 -0800, Arlene wrote: I just realized what you meant by cell values--sorry. I discovered a workaround. If I type a space before the cell value that is causing the autocomplete entry to appear, it stops it from appearing automatically while still retaining it in the drop down list. "Dave Peterson" wrote: Select the cells and hit the delete key????? Are you sure you want to do this? Arlene wrote: How do I remove the values from the surrounding cells? "Dave Peterson" wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting unwanted data | Excel Discussion (Misc queries) | |||
Deleting unwanted colums on a worksheet | Excel Worksheet Functions | |||
Deleting unwanted and empty rows.... | New Users to Excel | |||
Deleting unwanted and empty rows... | Excel Discussion (Misc queries) | |||
Deleting unwanted Cells | Excel Discussion (Misc queries) |