Excel 2016 Tips and Tricks

Excel 2016

Lesson 2 – Working with Tables

Using number filters

NOTE 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. Although the Custom AutoFilter dialog box indicates that you can use wildcard characters, wildcards can only be used with text filters, not number filters.



P ROCEDURES

1. Select the desired Filter arrow

.

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

OFFICEPRO, Inc.

Page 51