Is there a way to clear auto complete data?

I have a cell that is Validated as Add or Remove; however, when I
forst put the data list in I put "Add/Remove", instead of "Add,
Remove". I fixed it but it still rembers that i had used it in that
cell once. Now with auto complete on, When I enter "A" it wants to
complete to Add/Remove, instead of Add. ( This only happens the first
time, but it is still bother some. Is there a way to clear auto
complete?

Does the column heading say Add/Remove?
If so, that's what's causing the AutoComplete, not the removed data
validation item.

As a workaround, you could add a space at the beginning of the heading text.


Dean Goodmen wrote:
Is there a way to clear auto complete data?

I have a cell that is Validated as Add or Remove; however, when I
forst put the data list in I put "Add/Remove", instead of "Add,
Remove". I fixed it but it still rembers that i had used it in that
cell once. Now with auto complete on, When I enter "A" it wants to
complete to Add/Remove, instead of Add. ( This only happens the first
time, but it is still bother some. Is there a way to clear auto
complete?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

That was it :-) Thanks!

On Wed, 24 Nov 2004 07:21:54 -0500, Debra Dalgleish
wrote:

Does the column heading say Add/Remove?
If so, that's what's causing the AutoComplete, not the removed data
validation item.

As a workaround, you could add a space at the beginning of the heading text.


Dean Goodmen wrote:
Is there a way to clear auto complete data?

I have a cell that is Validated as Add or Remove; however, when I
forst put the data list in I put "Add/Remove", instead of "Add,
Remove". I fixed it but it still rembers that i had used it in that
cell once. Now with auto complete on, When I enter "A" it wants to
complete to Add/Remove, instead of Add. ( This only happens the first
time, but it is still bother some. Is there a way to clear auto
complete?