Learn the first steps to optimize any spreadsheet: https://www.excelpowerup.com/training
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:   / rebekahoster  
LinkedIn:   / 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