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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Replace Excel Formatting with Another Formatting Imagine this, you have a table full of bold text.  The bold text could also be all over your worksheet in random cells.Then you decide that the bold text does not suit your expected design and prefer red colored text instead.What would you do?Changing all of the forma...
Excel Hyperlinks: Buttons Excel´s hyperlink capability is amazing but many people don't use it as they don't know its full capabilities.With a hyperlink you can link an object/text to open an existing file on your desktop, go to a website, open up an email to a specific contact or go to a cell within ...
Go To Blanks The Go To Special tool within Excel is a must for any serious Excel user as it has an array of useful spreadsheet formatting and clean up tools.One that I use all the time is the Go To Special > Blanks.  This allows you to delete multiple blank rows/column within seconds. ...
Show The Percent of Grand Total With Excel Pivot T...  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 GRAND TOTAL calculation.This option will immediately calculate the percentages for you from a table filled with numbers such as sal...