Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching 🔎 How to Create Searchable Drop Down List in Excel. and this video is uploaded by Kevin Stratvert at 2021-07-19T00:00:16-07:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [fsL57bvd7Pk]
| Name | 🔎 How to Create Searchable Drop Down List in Excel |
| Video Uploader | Video From Kevin Stratvert |
| Upload Date | This Video Uploaded At 19-07-2021 07:00:16 |
| Video Discription | 🔥 Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com In this step-by-step tutorial, learn how to build a searchable drop down list in Microsoft Excel. First, we look at how to create a searchable drop down list on Excel for the web, which is very easy. All you need to do is to create a drop down list and it's searchable by default. Desktop Excel is a little more involved and requires three functions, including search, isnumber, and filter. First, we start by creating a drop down list that works on one cell. Then we progress and build a drop down list that works across multiple cells. By the end, you'll master creating searchable drop down lists on both Excel on the web and Excel desktop. 👋 Additional resources - Sample spreadsheet to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whMg2wN93Q4gx5gycCw?e=JX6W3Z - Excel on the web: https://www.office.com - Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com ⌚ Timestamps 0:00 Introduction 0:45 Create searchable drop down list in Excel on the web 2:53 Create basic drop down list in Excel desktop - no search 4:27 Create searchable drop down list in Excel desktop - one cell 11:28 Create searchable drop down list in Excel desktop - multiple cells 17:30 Best practices 18:09 Wrap up 📃 Watch related playlists - Playlist with all my videos on Excel: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 🚩 Connect with me on social - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 - TikTok: https://www.tiktok.com/@kevinstratvert 🔔 Subscribe to my YouTube channel https://www.youtube.com/user/kevlers?sub_confirmation=1 🎬 Want to watch again? Navigate back to my YouTube channel quickly http://www.kevinstratvert.com 🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz ⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same. #stratvert [fsL57bvd7Pk] |
| Category | Science & Technology |
| Tags | kevin stratvert | excel | drop down | drop down list | drop down lists | searchable | searchable drop down list | excel drop down list | excel drop down list tutorial | drop down list in excel | how to create | dropdown | dropdown in excel | how to add | add dro down list | in excel | drop down list excel | how to make | drop down menu | creating | data validation | insert | create | box | add | drop list | adding | drop down in excel | menu | excel data validation | excel list | dropdown list excel | tutorial |
