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 ...
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.
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
