🔎 How to Create Searchable Drop Down List in Excel
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
⌚ 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
Видео 🔎 How to Create Searchable Drop Down List in Excel канала Kevin Stratvert
👋 Additional resources
- Sample spreadsheet to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whMg2wN93Q4gx5gycCw?e=JX6W3Z
- Excel on the web: https://www.office.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
Видео 🔎 How to Create Searchable Drop Down List in Excel канала Kevin Stratvert
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Many SEARCHABLE Drop-Down Lists in Excel (No VBA)Searchable Drop Down List in Excel (Very Easy with FILTER Function)Create a searchable drop down list in Excel📊 How to Build Excel Interactive DashboardsHow to Create Drop Down Lists in Cells - The Complete Excel GuideHow to Create Dependent Drop-Down List in ExcelSUPER EASY Excel Data Entry Form (NO VBA)How to Build Search Box in ExcelCreate a Searchable Drop Down List Just Like Google - Excel TrickExcel Drop Down List Tips and TricksHow to create & use Drop Down lists like a PRO - Advanced Excel TricksCreate Multiple Dependent Drop-Down Lists in Excel (on Every Row)Drop Down Lists in Excel - Masterclass (incl. Dynamic, Dependent & Searchable Drop Down Lists)How to Use XLOOKUP in Microsoft ExcelSmart Dependent Drop-Down Lists in Excel: Expandable & Exclude Blank CellsCreate a Searchable Drop Down List in ExcelINDEX MATCH Excel TutorialHow to use Microsoft Power QueryExcel - How to create searchable dropdown list