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