Searchable Drop Down Lists in Excel (No VBA) 🔥

Подписаться 375 тыс.

Просмотров 9 тыс.

50% 1

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.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: ru-vid.com...
#Excel #ExcelTips #ExcelTutorial #SumitBansal

Опубликовано:

25 мар 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 27

@trumpexcel 4 месяца назад

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

@JHatLpool 4 месяца назад

Nice demonstration. Thanks !

@jhankhanajani9314 4 месяца назад

Thank you Sumit !!

@fernandesotiso8071 4 месяца назад

Great Video, good job. Thanks alot

@Satwant2463 4 месяца назад

Thank you.

@angyertartor9267 4 месяца назад

excellent work, very useful.

@nadermounir8228 4 месяца назад

Thank you Summit for this nice video 📹 👍

@SurendranNambiath 4 месяца назад

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

@minusthesparkle 4 месяца назад

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

@AIAgritecinsights 4 месяца назад

Great

@renedanos8877 4 месяца назад

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

@trumpexcel 3 месяца назад

👍

@mivomeiza8980 4 месяца назад

Thanks, the search makes the drop down list better.

@surajbhardwaj428 4 месяца назад

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

@trumpexcel 4 месяца назад

Glad you found the video helpful 🙂

@canirmalchoudhary8173 3 месяца назад

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

@PankMehta 4 месяца назад

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

@trumpexcel 4 месяца назад

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

@sugunachandran1263 21 день назад

Hello sir how to use this function in excel 2019

@nathanielaboagye2259 4 месяца назад

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

@trumpexcel 4 месяца назад

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

@asimali5820 4 месяца назад

Which version of excel??

@trumpexcel 4 месяца назад

This is available in Excel with Microsoft 365 subscription

@deepaksalunke1583 4 месяца назад

But how it works other excel like 2013 and 2019

@trumpexcel 4 месяца назад

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

@JoeMeyer8998 4 месяца назад

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 4 месяца назад

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)