Forum Discussion
Autocomplete not working for data validation
At work we have a shared excel sheet (we open it on the web) and we use it to store data.
We had it set up with data validation list's and when we typed into the boxes, it would autocomplete one of the options. Now, you have to click the down box then start typing because autocomplete has stopped working.
Autocomplete is still checked in options, and everything is still the same setting that it was previously as far as anyone can tell.
Please help!
73 Replies
- This is driving me crazy as well! Microsoft better have a quick solution for this. Hoping its just an update glitch, that they'll resolve soon.
Same issue here; following for resolution.
- I am have the same issue today.
- I was struggling with this as well.
I have found a work around that help my team.
Try to click into the cell select the dropdown chevron then start to type. The auto complete should start to work.We do this too, but found we save so much time when we can just click tab to the next box, type, then tab to the next; rather than clicking and typing! Thanks for the heads up but hopefully there is a resolution to the issue Josh_71288
- I was struggling with this as well.
I have found a work around that help my team.
Try to click into the cell select the dropdown chevron then start to type. The auto complete should start to work. - same problem....
- Same problem, following for resolution.
Mollierosemac I have the same problem and it's driving me crazy! I'd love any solutions to allow me to return to autocomplete.
