12-12-2019 11:18 AM
12-12-2019 11:18 AM
I did all the below methodology to have Excel auto complete text for me and it doesn't, why not? Is there a block to that process? How does that work, Thanks.
Turn automatic completion of cell entries on or off
Microsoft Office Excel completes text entries that you start to type in a column of data — if the first few letters that you type match an existing entry in that column. If you want to stop automatic completion, you can turn this option off.
Click File > Options.
Click Advanced, and then under Editing options, select or clear the Enable AutoComplete for cell values check box to turn this option on or off.
12-12-2019 11:56 PM - edited 12-12-2019 11:57 PM
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?
06-04-2020 03:05 PM
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.
1E doesn't fill when typing abc
06-04-2020 09:03 PM