Microsoft Office Tutorials and References
In Depth Information
Whereas sorting rearranges all records in ascending
or descending order, filtering enables you to see only
the records that match your criteria, hiding the rest.
Criteria look like this: Age is greater than 65 and State
equals Missouri, where Age and State are the names
of column heads. When you filter a list, down arrows
appear to the right of every column head.
Click a column’s arrow to select values, such as
Missouri or Age greater than 65. By applying a filter,
you display only those records that contain certain
values in the column — for example, all customers in
Missouri or all men over 65. You can also create a
filter that displays the records for a column’s top ten
values. With Excel, you can combine filters, applying
different criteria to different columns.
By applying several filters, you can quickly narrow
down a long list to the few records of interest to you.
Criteria that apply to too narrow a range of values,
however, might not return any records. To filter a list
by multiple criteria, start with a worksheet formatted
as a list.
Click in a cell in your list.
Click the Data tab.
Click Filter in the Sort & Filter
l Down arrows appear next to all
of your column heads.
Click the down arrow next to the
field you want to filter.
Click Number Filters if you chose
a number field.
Alternatively, click Text Filters
if you chose a text field or Date
Filters if you chose a date field in
Click Custom Filter.