Microsoft Office Tutorials and References
In Depth Information
Managing Information in Lists
list data in
Filtering a list
Filtering means to scour a worksheet list for certain kinds of data. To filter,
you tell Excel what kind of data you’re looking for, and the program
assembles rows with that data to the exclusion of rows that don’t have the data.
You end up with a shorter list with only the rows that match your filter
criteria. Filtering is similar to using the Find command except that you get more
than one row in the results of the filtering operation. For example, in a list of
addresses, you can filter for addresses in California. In a price list, you can
filter for items that fall within a certain price range.
To filter data, your list needs column headers, the descriptive labels in the
first row that describe what is in the columns below. Excel needs column
headers to identify and be able to filter the data in the rows. Each column
header must have a different name.
To filter a list, start by going to the Data tab and clicking the Filter button. As
shown in Figure 5-4, a drop-down list appears beside each column header.
Your next task is to open a drop-down list in the column that holds the
criteria you want to use to filter the list. For example, if you want to filter the list
to items that cost more than $100, open the Cost column drop-down list; if
you want to filter the list so that only the names of employees who make less
than $30,000 annually appears, open the Salary drop-down list.