Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com'>https://kevinstratvert.thinkific.com
In this stepbystep 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!AmxrofZZlZwhMg2w...
Excel on the web: https://www.office.com
Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com'>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: • ❎ How to use Excel
Connect with me on social
LinkedIn: / kevinstratvert
Twitter: / kevstrat
Facebook: / kevinstratvert101912218227818
TikTok: / kevinstratvert
Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?...
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