Searchable Drop Down Lists in Excel (No VBA) 🔥

In this short video, I will show you how to create a drop-down list that can be searched so that it only shows you the options that match the text we have entered in the drop-down cell.
This is only available in Excel for Microsoft 365 and Excel on the web.
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoff...
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com...
✅ Free Dashboard Course - bit.ly/free-ex...
✅ Free VBA course - bit.ly/excel-v...
✅ Free Power Query Course - bit.ly/power-q...
✅ Best Excel Books: trumpexcel.com...
Subscribe to get awesome Excel Tips every week: www.youtube.co...
#Excel #ExcelTips #ExcelTutorial #SumitBansal

[@trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
Also, I have made all of my Excel courses available for free. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course

[@nadermounir8228]

Thank you Summit for this nice video 📹 👍

[@jhankhanajani9314]

Thank you Sumit !!

[@Satwant2463]

Thank you.

[@angyertartor9267]

excellent work, very useful.

[@PankMehta]

Sumit, What version of Excel is this available in? I am using 2013 and it is not working in there.

[@trumpexcel]

This is available in Excel with Microsoft 365, so won't work in Excel 2013

[@sugunachandran1263]

Hello sir how to use this function in excel 2019

[@JoeMeyer8998]

Make the list of movies a table (Ctrl-T), give column "Movie Name" a name, use the name in the data validation, and your drop down list is even more dynamic

[@trumpexcel]

Yeah, good tip Joe. Tables are great when it comes to expanding columns. Also, I am not sure if this was already there or not, but if I select the entire column A (or say A1:A100), this also makes the drop down dynamic (as it only picks up the filled cells)

[@tale_telling]

Great

[@mivomeiza8980]

Thanks, the search makes the drop down list better.

[@minusthesparkle]

Thank you! These interactive user interfaces are such a big help to end users and creators alike! =D

[@canirmalchoudhary8173]

Not yet received this functionality. BTW I use Alt+D+L to open list validation.

[@fernandesotiso8071]

Great Video, good job. Thanks alot

[@JHatLpool]

Nice demonstration. Thanks !

[@SurendranNambiath]

Yes, this is a GREAT feature! I'm using it already.

[@surajbhardwaj428]

That's great.. With this help i can work more fast
..

[@trumpexcel]

Glad you found the video helpful 🙂

[@nathanielaboagye2259]

Which version of Excel has this feature please?? 2016??

[@trumpexcel]

It's available in Excel with Microsoft 365. Also, I believe it will be there in Excel 2024 when it's released. Unfortunately, it's not there in the earlier versions

[@renedanos8877]

Great video. I been waiting for this for a while now.

[@trumpexcel]

👍

[@asimali5820]

Which version of excel??

[@trumpexcel]

This is available in Excel with Microsoft 365 subscription

[@deepaksalunke1583]

But how it works other excel like 2013 and 2019

[@trumpexcel]

Unfortunately it won't as it's only available in Excel with Microsoft 365