Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou...

Finally we get SEARCHABLE drop down lists in Microsoft Excel WITHOUT writing complex formulas. There's no VBA, no filter function. The autocomplete functionality is there by default.

The ability to search for values in data validation was released on the web (online) version of Excel last year but now it's available in the Excel desktop version as well. To search the drop-down list you just have to start typing in the cell. A list of search results will appear and filtered down as you type. It also automatically suppresses empty cells.

🔍 Key Takeaways:
▪️ Learn how to create searchable drop-down lists without any complex coding.
▪️ Understand how to use Data Validation for creating dynamic, user-friendly drop-down menus.
▪️ Discover two major improvements: Auto-Complete in drop-down lists and automatic exclusion of blank cells.
▪️ Explore the new Search Box option for cells, enhancing navigation and functionality in Excel sheets.

You can use this to create multiple searchable drop-down lists or data validations in a single sheet.

This update is for Office/Microsoft 365 subscribers for Windows and Mac.

00:00 Searchable Drop Down Lists in Excel
00:29 Create Searchable Drop Down Lists Without Formulas
03:33 New Search Box Option
05:27 Wrap Up

🎬 LINKS to related videos:
Searchable Drop Down List in Excel:    • Searchable Drop Down List in Excel (V...  
Many SEARCHABLE Drop-Down Lists in Excel:    • Many SEARCHABLE Drop-Down Lists in Ex...  

📖 Complete blog post: https://www.xelplus.com/default-searc...

➡️ Join this channel to get access to perks:    / @leilagharani  

👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

🎥 RESOURCES I recommend: https://www.xelplus.com/resources/

🚩Let’s connect on social:
Instagram:   / lgharani  
LinkedIn:   / xelplus  

This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel