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

How to Insert an Excel Table Excel Tables are very powerful and have many advantages when using them.  You should start using them asap regardless of the size of your data set, as their benefits are HUUUGE: 1. Structured referencing; 2. Many different built in Table Styles with color formatting; 3. Use ...
Show The Percent Of With Excel Pivot Tables   Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF calculation. It will display the value of one item (the Base Field) as the percentage of another item (the Base Item). This optio...
Convert Values to Dates Using Flash Fill In Excel   Flash Fill in Excel is a new feature that was introduced in Excel 2013. Flash Fill allows you to combine, extract, move & transform data that belongs in one column, into a new column. One of the cool uses of Flash Fill is convert your values into Excel dates a...
Add Hyphens To Serial Numbers Using Excel Flash Fi...   Flash Fill in Excel is a new feature that was introduced in Excel 2013. Flash Fill allows you to combine, extract, move & transform data that belongs in one column, into a new column. One of the cool uses of Flash Fill is formatting numbers.  In our example be...