Forum Discussion
Excel auto complete text
it's supposed to work as per below, so because Apple is already in my list when I type A it comes up
However if I have 2 existing items beginning with A then I need to type the 2nd letter for autocomplete to work
Is this sort of thing not working for you?
I am having a similar issue. The autocomplete feature was working but now, I begin to type in a cell it no longer is filling it in. This is happening sporadically but most of the time it doesn't work anymore. I am able to use the auto-complete feature right under a cell that is already filled out. However, if I go a cell down where there isn't a filled cell above it, when I type the text it does not auto-complete. I have a feeling it has to do with the blank cell but I can't figure out why it works sometimes and doesn't others. I've ensured the feature is turned on, turned it off, closed the spreadsheet, re-opened and then turned it back on...same issue. Hopefully this makes sense.
Example: In multiple cells I have "abc" and that's the only thing written in these cells. For this example, cell 1A, 1B and 1C has abc written in it. If I go to 1D and start typing it will start the abc auto-complete/fill. However, if I leave cell 1D blank and move to 1E (so now there is a blank cell above the one I'm typing in) and start typing, no fill options appear.1A abc
2B abc
1C abc
1D blank
1E doesn't fill when typing abc
- Hi, strange one, works for me sorry when I quickly tested it, but I do know from experience there are confusing times it doesn't work
