Results 1 to 4 of 4

Thread: Auto complete not working for a specific word

  1. #1

    Auto complete not working for a specific word



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have to type in a long place name with 10 letters repeatedly and whereas before Excel completed it after I typed the first two letters it has now stopped doing so. Is there a way to reactivate this facility? Other names do get auto-completed when typed in the same column.

    I tried re-ticking the auto-complete option and it worked once or twice then back to not working. So it might be that the word is present so many times that the program can't cope with auto-completing it. Is there some special trick to solve this problem?

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,477
    Articles
    0
    Excel Version
    Excel 2016
    If there are other words that have same starting characters, then Excel won't suggest, since there can be various possibilities. It only suggests once it knows there is a uniqueness in the text you are typing... ie. maybe after a certain amount of characters, then the word is unique, so it will populate....


  3. #3
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    One way around is to set up an AutoCorrect option (as distinct from the AutoComplete functionality). For instance, instead of me typing my name, I could set it up so that any time I type my initails it autocorrects it to my full name. You can do the same for your long word strings...just give them distinct two or three letter shortcuts, and they'll be automatically corrected.

    In Excel 2010 you find this under File>Options>Proofing>Autocorrect Options. If you've got a different version, then give Google a prod.

  4. #4
    Thanks for taking the time to reply and your advice will be useful in the future but this time it seems to be a bug causing the problem.

Posting Permissions

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