Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Jul 2004
    Location
    San Mateo, California, USA
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    auto complete (Excel XP-SP2)

    I am using Excel as a flat-file database. In most of the columns, if I start to enter the same text as has previously been entered in that column, the entire string is shown (highlighted); just hitting the Tab key to move to the next column/field enters the full text where it belongs. But... I have some columns where this doesn't work. I've gone to Tools/Options/Enable auto complete -- the box is checked. I've tried to uncheck the box, close the dialog box, go back and recheck Enable auto complete (with and without the entire spreadsheet selected) and it still doesn't work in those "resistant" columns. I've checked to see if somehow they've been filled with blanks (space bar entry) but no joy. What now?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: auto complete (Excel XP-SP2)

    Does MSKB article XL: AutoComplete May Not Work throw any light on the problem?

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: auto complete (Excel XP-SP2)

    Another way to get a list of possible entries for the cell is to type the first couple of characters, and then press ALT + the down arrow. This is not quite the "Autocomplete", but it will allow you to complete the entry faster...if the problem persists!
    Regards,
    Rudi

  4. #4
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: auto complete (Excel XP-SP2)

    Joyce:

    Another alternative is to right-click in the cell and choose 'Pick from list', which gives you the list of existing entries to choose from.

    Tony
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: auto complete (Excel XP-SP2)

    Yes, that is true...however, you need to transfer your hands to the mouse to do that... too much effort <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

    Joyce is not on the board currently! I hope this advice will be useful if Hans's link does not solve her problem!
    Regards,
    Rudi

  6. #6
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: auto complete (Excel XP-SP2)

    Hi Joyce

    Go to the cell below and press CTRL + D and see if that works.

    Braddy
    If you are a fool at forty, you will always be a fool

  7. #7
    Star Lounger
    Join Date
    Jul 2004
    Location
    San Mateo, California, USA
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: auto complete (Excel XP-SP2)

    Hans -- many thanks for the reference to the MSKB -- it did indeed help. I may need to insert a blank row so that it doesn't look like I have a header row, and then maybe it will work. I'll check it out.

  8. #8
    Star Lounger
    Join Date
    Jul 2004
    Location
    San Mateo, California, USA
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: auto complete (Excel XP-SP2)

    Rudi and all -- Many thanks for all the suggestions. I LOVE this lounge -- people are really helpful.

Posting Permissions

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