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 ...
As an alternative, on desktop version, you can have the autocomplete functionality by using a free Excel add-in "Search deList". You can find it here:
https://www.mrexcel.com/board/threads/i-created-an-excel-add-in-called-search-delist-to-create-searchable-data-validation.1189466/
It gives you a unique, sorted & non-empty list, and you can search by multiple keywords.
