Forum Discussion
Excel auto complete text
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
