Auto Complete
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? |
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 |
Auto Complete
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? |
All times are GMT +1. The time now is 10:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com