DROP DOWN LIST WITH SEARCHABLE OPTION. SEARCHABLE DOESN'T WORK.

Occasional Visitor

I recently became a beta version user after using merely 365 version for quite a while. I was trying to do DROP DOWN LIST WITH SEARCHABLE OPTION, it didnt work fully. Drop down list is working but it is NOT SEARCHABLE. What could be the problem?

4 Replies
I have same problem , and I'm still didn't found a solution
Hi, I think you'll like this video: NEW! SEARCHABLE Drop Down Lists in Excel with ZERO Effort! - YouTube https://www.youtube.com/watch?v=3Qh5nUmCVd8 Kind regards Hans
And if it isn't available "for you for whatever reason, see :magnifying_glass_tilted_right: How to Create Searchable Drop Down List in Excel - YouTube https://www.youtube.com/watch?v=fsL57bvd7Pk

@surendrapandey427 

 

My dropdown advanced search breaks multiple times a day. Typically, a Quick Repair will restore the functionality. (I had to do a full repair once.) Sometimes, but rarely, rebooting my device is needed as well. You can do a Quick Repair by selecting the Windows icon and then typing programs to display "Add or Remove Programs". Select that application to display a list of programs and then select your application. Select "Modify" and then initiate a Quick Repair. You'll be asked the usual questions for making a change and then you'll also have to either close your Office programs or allow the repair (install) to do it. It takes two or three minutes.