Excel 2016 Tips and Tricks

Lesson – Working with Tables

Excel 2016

Using text filters

NOTE You can also use wildcard characters when typing matching text into the right-hand boxes in the Custom AutoFilter dialog box. Use ? (question mark) to match a single unknown character ( b?lls will match b a lls , b e lls , b i lls , b b lls , and so on). Use * (asterisk) to match any number of unknown characters ( r*t will match r a t and r o t but will also match r oden t and r adian t ). Wildcards can be particularly useful for coping with misspellings in your data. When you have used filters on several columns in the table, you can clear all the filters by clicking the Clear button in the Sort & Filter group on the Data tab.



P ROCEDURES

1. Select the desired Filter arrow

.

2. Point to Text Filters . 3. Select the desired text filter option. 4. Enter the desired matching text in the box to the right of the selected text filter. 5. Enter a second filter criteria in the dialog box, if desired. 6. Select .

Page 48

OFFICEPRO, Inc.