| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 | Publish Date not found |  0 Views |
Take your Excel spreadsheets to the next level: https://www.excelpowerup.com/course
Get personalized professional support: https://www.excelpowerup.com/support
If your data is large and unmanageable, a search box may be just the thing you need to make your spreadsheet more user-friendly! I call these kinds of fun and useful upgrades, “Power Ups”! In this video, I’ll show you step-by-step how to create a magic search box in Excel using the FILTER, ISNUMBER, and SEARCH functions. You’ll also learn about a few key tweaks that can take this feature to the next level.
Website: https://www.excelpowerup.com
Instagram: https://www.instagram.com/rebekahoster
LinkedIn: https://www.linkedin.com/in/rebekah-oster
00:00 Introduction
00:54 Design Search Box
03:46 Insert ActiveX Text Box
06:00 Create Search Results View
06:50 The Formula
09:19 Power Up 1: Gridlines
10:46 Power Up 2: Multi-Column Search
12:01 Note: Partial Matches
12:26 Power Up 3: Exclude Some Columns
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
