How to Build Search Box in Excel
In this step-by-step overview, learn how to add an advanced search box to your Excel workbook. You can insert a search box with no knowledge of VBA or coding. Imagine you have a cookie customer list, and you want to find the chocolate chip cookies, you can insert a search box to find that. We'll run through how to make the search box return exact matches and more advanced scenarios like partial match search, multiple column match and highlighting the search term using conditional formatting in the results. This is a fully fledged search box. To follow along, you can access the spreadsheet in the description below.
👋 Additional resources
- Sample spreadsheet to follow along: https://www.kevincookiecompany.com/excel-search-box
- How to create an Excel interactive dashboard: https://youtu.be/MTlQvyNQ3PM
⌚ Timestamps
0:00 Introduction
0:47 Enable developer tab
1:36 Add basic exact match search box
4:23 Add partial match search box
8:11 Add multiple column search box
9:32 Use conditional formatting to highlight partial matches
10:25 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
- Instagram: https://www.instagram.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 Build Search Box in Excel канала Kevin Stratvert
👋 Additional resources
- Sample spreadsheet to follow along: https://www.kevincookiecompany.com/excel-search-box
- How to create an Excel interactive dashboard: https://youtu.be/MTlQvyNQ3PM
⌚ Timestamps
0:00 Introduction
0:47 Enable developer tab
1:36 Add basic exact match search box
4:23 Add partial match search box
8:11 Add multiple column search box
9:32 Use conditional formatting to highlight partial matches
10:25 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
- Instagram: https://www.instagram.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 Build Search Box in Excel канала Kevin Stratvert
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![📊 How to Build Excel Interactive Dashboards](https://i.ytimg.com/vi/MTlQvyNQ3PM/default.jpg)
![Don't Use Excel Filters! Use This Incredible Excel Formula Instead ...](https://i.ytimg.com/vi/Qi1nfN5F8F4/default.jpg)
![Searchable Drop Down List in Excel (Very Easy with FILTER Function)](https://i.ytimg.com/vi/Z-h2UER3b_0/default.jpg)
![](https://i.ytimg.com/vi/RLcQSoou-_g/default.jpg)
![SUPER EASY Excel Data Entry Form (NO VBA)](https://i.ytimg.com/vi/cNpFB8M1-dI/default.jpg)
![How to build your own search box in Excel](https://i.ytimg.com/vi/Gp3b8y_pO8I/default.jpg)
![How to Add a Search Box to a Slicer in Excel](https://i.ytimg.com/vi/95_dIb8PMpc/default.jpg)
![Real-Time Data Search Box in Excel with FILTER function [Part 1]](https://i.ytimg.com/vi/gHXalY5rngI/default.jpg)
![Dynamic Filter in Excel - Filter As You Type (with & without VBA)](https://i.ytimg.com/vi/xBRkCv6RWcE/default.jpg)
![Top 20 Microsoft Excel Tips & Tricks](https://i.ytimg.com/vi/AOPa7ORJj4Y/default.jpg)
![How to Create a Data Entry Form in Excel With Add, Modify, Delete and Reset (Step-by-step Guide)](https://i.ytimg.com/vi/I-Ze6bX7ous/default.jpg)
![INDEX MATCH Excel Tutorial](https://i.ytimg.com/vi/6JhbY8Mku1A/default.jpg)
![🧙♂️ Pivot Table Excel Tips & Tricks](https://i.ytimg.com/vi/3g1CSG5zvQ0/default.jpg)
![🔎 How to Create Searchable Drop Down List in Excel](https://i.ytimg.com/vi/fsL57bvd7Pk/default.jpg)
![How to use Power Pivot in Excel](https://i.ytimg.com/vi/rB_IiYbOo7w/default.jpg)
![Excel Lookup to Return Multiple Values with FILTER Function](https://i.ytimg.com/vi/Eehk6PC0oGs/default.jpg)
![Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)](https://i.ytimg.com/vi/7mo4COng7Sg/default.jpg)
![Creating Easy Data Entry Forms in Excel](https://i.ytimg.com/vi/5soiJ5rsqKc/default.jpg)
![MS Excel: Easily Make Custom Search Box (Easy to Find)](https://i.ytimg.com/vi/eqeoVzbAtVE/default.jpg)
![FIND() vs SEARCH() Function in Excel](https://i.ytimg.com/vi/tep4wSgygVE/default.jpg)