Channel: Leila Gharani

Category: Education

Tags: data validation listexcel tips and tricksdropdown listsexcel searchable listmicrosoft excel tutorialssearchable dropdownexcel for analystsmicrosoft excelxelplusvisleila gharaniadvanced excel tricksexcel 2016excel data validationexcel 2019xelplusmicrosoft 365excel 2013excel online courseexcel 365searchable drop down excel listsdrop-down listsexcel searchable drop down list multiple cellsoffice 365autocomplete drop down

Description: 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. You can use this to create multiple searchable drop-down lists or data validations in a single sheet. This update is currently available on the Beta Channel for Office 365 Insiders 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 🌍 My Online Excel Courses ► xelplus.com/courses 🎬 LINKS to related videos: Searchable Drop Down List in Excel: youtu.be/Z-h2UER3b_0 Many SEARCHABLE Drop-Down Lists in Excel: youtu.be/waqzwMCYD9I 📖 Complete blog post: xelplus.com/default-searchable-drop-down-lists-in-excel 🎒 Get the Official XelPlus MERCH: xelplus.creator-spring.com 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz 📚 Excel RESOURCES I Recommend: xelplus.com/resources 🎥 GEAR I use: xelplus.com/resources/#gear More resources on my Amazon page: amazon.com/shop/leilagharani 🚩Let’s connect on social: Instagram: instagram.com/lgharani Twitter: twitter.com/leilagharani LinkedIn: at.linkedin.com/in/leilagharani 👉 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! #MsExcel