Microsoft Office Tutorials and References
In Depth Information
To Enter Custom Criteria Using AutoFilter
To Enter Custom Criteria Using AutoFilter
One of the commands available in all AutoFilter menus is Custom Filter. The Custom Filter command option
allows you to enter custom criteria, such as multiple options or ranges of numbers. The following steps show how to
enter custom criteria to show records in the table that represent sales reps whose ages are between 30 and 40,
inclusive; that is, they are greater than or equal to 30 and less than or equal to 40 (30
Age
40).
1
Click the Filter button on the Data
tab on the Ribbon to display the
AutoFilter arrows in the table.
Age
arrow
With the table active, click the
Age arrow in cell C8 to display the
Age AutoFilter menu.
Age list
When Excel displays the AutoFilter
menu, point to the Number
Filters command and then point
to Custom Filter on the shortcut
menu (Figure 5–54).
Numbers Filters
command
Numbers Filters
submenu
Custom Filter
command
Figure 5–54
2
Click Custom Filter.
When Excel displays the Custom
AutoFilter dialog box, click the
top-left box arrow, click ‘is greater
than or equal to‘ in the list, and
then type 30 in the top-right box.
Custom
AutoFilter
dialog box
is greater
than or equal
to selected
from list
age must be
greater than
or equal to 30
Click the bottom-left box arrow,
click ‘is less than or equal to‘ in
the list, and then type 40 in the
bottom-right box (Figure 5–55).
age must be
less than or
equal to 40
And option
button
selected
information
regarding
wildcard
characters
is less than
or equal to
selected from
list
OK button
Figure 5–55
 
 
Search JabSto ::




Custom Search