Apr 28 2020 11:01 AM
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.
Apr 28 2020 11:26 AM
May 13 2020 01:25 AM
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.
Jun 24 2020 12:55 PM
@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.
Jun 24 2020 01:29 PM
SolutionJust 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.
Jun 25 2020 01:02 AM
@Sergei Baklan
Thanks for you answer.
Correct it's working, a little bit improvised but its working.
Jun 25 2020 01:06 AM
Ok, good. Do you think there is possible to have an Add-in to do this?
That would be awesome!
Thanks for your answer.
Jun 24 2020 01:29 PM
SolutionJust 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.