I have a list of words in a column and all of a sudden, some of those words will autocomplete and some will not. There aren't any blanks in the column, and two of the four words work.
Any ideas?
I have a list of words in a column and all of a sudden, some of those words will autocomplete and some will not. There aren't any blanks in the column, and two of the four words work.
Any ideas?
What are the words? Do two of the words have the same initial characters? For example, STREET and STREAM have the same leading characters, so Autocomplete won't work until after the first E
The words are:
Light Sea Blue
Butter
True Navy
French Blue
No matter how far into each one I type, they won't automplete.
That's odd. I did enter those fields into an excel workbook and had no trouble auto completing. Is it possible for you to copy your info into a new workbook?
I copied them to a new file and it worked for 3 of the 4, but "butter" won't autocomplete.
Also, it's not my computer that is the issue - I am trying to figure this out for someone else. It won't work on her computer either.
weirdly enough, I added another word to the end of "butter" and it works then, but only once I get past "butter" in my typing.
It works on other one word entries, so I don't get why it won't work on this one.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks