NEW! SEARCHABLE 🔎 Drop Down Lists in Excel with ZERO Effort!
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 ► https://www.xelplus.com/courses/
🎬 LINKS to related videos:
Searchable Drop Down List in Excel: https://youtu.be/Z-h2UER3b_0
Many SEARCHABLE Drop-Down Lists in Excel: https://youtu.be/waqzwMCYD9I
📖 Complete blog post: https://www.xelplus.com/default-searchable-drop-down-lists-in-excel
🎒 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/
📚 Excel RESOURCES I Recommend: https://www.xelplus.com/resources/
🎥 GEAR I use: https://www.xelplus.com/resources/#gear
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://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
Видео NEW! SEARCHABLE 🔎 Drop Down Lists in Excel with ZERO Effort! канала Leila Gharani
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 ► https://www.xelplus.com/courses/
🎬 LINKS to related videos:
Searchable Drop Down List in Excel: https://youtu.be/Z-h2UER3b_0
Many SEARCHABLE Drop-Down Lists in Excel: https://youtu.be/waqzwMCYD9I
📖 Complete blog post: https://www.xelplus.com/default-searchable-drop-down-lists-in-excel
🎒 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/
📚 Excel RESOURCES I Recommend: https://www.xelplus.com/resources/
🎥 GEAR I use: https://www.xelplus.com/resources/#gear
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://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
Видео NEW! SEARCHABLE 🔎 Drop Down Lists in Excel with ZERO Effort! канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Useful Websites to Use Today #shortsCool Excel Trick 💡Use Slicer Buttons With a Hidden Pivot Table #shortsEasiest Ways to Export Power BI to Excel Smoothly and Efficiently (new updates included 🪄)Introducing Python in Excel 😱Amazing Windows Shortcuts You Aren't Using🆕 Best NEW Excel Features EVERYONE NeedsSecret FREE Windows Tools Nobody Is Talking AboutHow to Use Excel's NEW Lookup of Images 👉 Professional Dashboards Just Got Easy ➕ Bonus RevealWhat Top Doctors Can Teach You About Excel Power Query #shortsYou WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯The Secret to Note-taking for Busy PeopleHow to Split Text with Multiple Delimiters with Excel TEXTSPLIT #shortsAnnouncing the LG supporter squad 😎How to Use Excel's New TAKE Function to Impress Your Boss and ColleaguesYou Won't Believe These Crazy PIVOT TABLE Hacks!Resize Multiple Images At Once #shorts3 Ways to Use Forms in Your Business from Polls to Recruiting + AI Features Revealed!How to Use VSTACK HSTACK Function in Excel #shortsPaste Text ONLY - NEW Shortcut in Word #shorts5 Cool Websites When You Are Bored (Watching Free Movies Included 🍿)How to Use TAKE Function in Excel #shorts