Microsoft Office Tutorials and References
In Depth Information
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
• Click the Filter button on the Data
tab on the Ribbon to display the
AutoFilter arrows in the table.
• With the table active, click the
Age arrow in cell C8 to display the
Age AutoFilter menu.
• 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).
• 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.
than or equal
age must be
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
is less than
or equal to