SOLVED

Validate Cell Data Search

Copper Contributor

Hi all,

 

I created a "Validate Cell Data" list and the problem is that in the WPS Office software I can do a search on the elements of the list. In Excel, it is not possible (see attachment). What do I have to do to get the same functionality in Excel?

 

Thanks for help.

 

WPS vs Excel SearchWPS vs Excel Search

 

7 Replies
There is no native way of doing this in Excel. However, there are workarounds.

Jon Acampora has an add-in to help with this. It's pretty handy. Here is a link to his post about it:
https://www.excelcampus.com/vba/search-data-validation-drop-down-lists/

Some other creative solutions:
https://www.xelplus.com/searchable-drop-down-list/
https://trumpexcel.com/excel-drop-down-list-with-search-suggestions/
And the most clever IMO: https://www.myonlinetraininghub.com/searchable-drop-down-list-in-excel

@Zack Barresse 

 

Hi Mr. Zack,

 

Thanks for your quick response.
The only option that works for me is from Excel Campus, but take me to another problem... I need that function on Windows and Android devices! The Excel Campus solution only works at windows!

 

Do you have any sugestions to solve this problem?

 

Thanks for your help.

@MrPinto I apologize for the delayed response. As far as I know there is no solution for Android Excel at the moment. This might be a good idea for an Office Add-In (javascript) though.

best response confirmed by MrPinto (Copper Contributor)
Solution

@MrPinto 

Just in case, searchable drop-down list is available out of the box for Excel Online if you consider it as an option - it is platform independent.

@Sergei Baklan 
Thanks for you answer.
Correct it's working, a little bit improvised but its working.

@Zack Barresse 

Ok, good. Do you think there is possible to have an Add-in to do this?
That would be awesome!

 

Thanks for your answer.

@MrPinto , you are welcome

1 best response

Accepted Solutions
best response confirmed by MrPinto (Copper Contributor)
Solution

@MrPinto 

Just in case, searchable drop-down list is available out of the box for Excel Online if you consider it as an option - it is platform independent.

View solution in original post