Pinterest Pixel

Filter & Search

Filter & Search The Search box within the Filter button is powerful if you know how to... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

Filter & Search | MyExcelOnline Filter & Search | MyExcelOnline

Filter & Search

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 workbookFilter-Search.xlsx

STEP 1: We will do some basic filtering to set our table up

Click on the CUSTOMER column header and select 2-3 values to display only
Filter & Search

Now we have these 2 values only being displayed:

Filter & Search

STEP 2: Now click on the CUSTOMER column header and type “the” in the search box

Once you tick Add current selection to filter, this will include the Customers with the word “the” in the text

This will be included to your filter. Click OK

Filter & Search

You have 3 additional customers added now:

Filter & Search

STEP 3: Now click on the CUSTOMER column header and type “w*” in the search box

The asterisk (*) is a wildcard character, this means this will search for all text starting with w only

Once you tick Add current selection to filter, this will include the Customers with the letter “w” in the beginning

This will be included to your filter. Click OK

Filter & Search

You have the additional customers added now:

Filter & Search

If you like this Excel tip, please share it
Filter & Search | MyExcelOnline Filter & Search | MyExcelOnline
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Text to Columns - Emails

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...