Results 1 to 2 of 2
2002-08-25, 00:44 #1
- Join Date
- Jun 2002
- Thanked 0 Times in 0 Posts
Remove Autocomplete Entries (Excel XP)
Does anybody know how to remove the autocomplete entries in Excel.
The problem is this. I have a workbook which I want to save as a template. The workbook was full of data which I cleared before saving as a template. When I open a workbook based on the template as soon as I begin typing autocomplete springs into action offering me text from the deleted entries in the original workbook. I want to leave the autocomplete feature turned on but clear out any existing entries before saving a workbook as a template. I cannot find any way of doing this. Anybody got any ideas.
2002-08-25, 23:06 #2
- Join Date
- Apr 2001
- Auckland, Auckland, New Zealand
- Thanked 2 Times in 2 Posts
Re: Remove Autocomplete Entries (Excel XP)
I am presuming that the number of rows in your template is not humongous. Format double the number of rows required in your test template. Delete the top half of the rows you used for testing, thereby leaving blank columns to be looked up until new data is inserted.
<img src=/S/2cents.gif border=0 alt=2cents width=15 height=15> <img src=/S/flags/NewZealand.gif border=0 alt=NewZealand width=30 height=18>Paul Coyle
Approach love and cooking with reckless abandon