Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Posts
    3
    Thanks
    0
    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.

  2. #2
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •