The Search box within the Filter button is powerful if you know how to use it to your advantage.

For example, if you had a list of customers the Search box allows you to find specific customers by typing in a few letters only, allows you to add a selection to your filtered list and even use wildcard symbols – like the asterisk * to drill down to specific customers.

I show you all these in the gif below.

DOWNLOAD WORKBOOK

Filter & Search

Helpful Resource:

MOTH-excel_expert470x63

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Turn Text To Values With Paste Special Values Many times you would have received data from your IT system which is formatted wrong!  Well a gazillion times if you work in a mid sized firm 🙂 When you try and sum the values you get a count rather than a sum, that is because Excel reads the data as text rather than a value....
Turn Text Dates To Excel Dates With Text To Column... Whenever you import data from your company's server, ERP system or any other source for that matter, the Dates usually come in a TEXT format. I will show you a cool trick where you can turn the TEXT Date to a values Date that Excel can read and work with. DOWNLOAD EXCEL WOR...
Create a Named Range in Excel Whenever I work with spreadsheets, there's no escaping the fact that I have to work with a lot of ranges. Some of these ranges I have to reuse time and time again to create different calculations! Good thing there are Named Ranges in Excel! By using a Named Range, you ca...
What Microsoft Excel Version Do I Have? We know that Microsoft Excel has different features across different versions and there are several Excel version, like Excel 2003, 2007, 2010, 2013 and 2016! So whenever I use Microsoft Excel I want to know right away which Excel Version I am using.  And boy, do I get confuse...