Home > Filters > AutoFilter > Get Started Excel 2003 AutoFilter BasicsHow to use Excel 2003 AutoFilter to show or hide specific data in a list, to focus on a product or customer, or print selected data Note: For current Excel AutoFilter instructions, please go to Excel AutoFilter Basics |
a) The first row (A1:D1) has headings.
b) Subsequent rows contain data.
c) There are no blank rows within the database -- you can leave some cells blank, but not an entire row.
d) There is a blank row at the end of the database, and a blank column at the right.
a) Select a cell in the database.
b) From the Data menu, choose Filter, AutoFilter.
A dropdown arrow appears beside each column heading.
To filter the list, for example to view orders for one Product,
choose a criterion from one of the dropdown lists. To further filter
the list, choose from another column's dropdown list, e.g. Customer.
Rows that don't meet the criteria will be hidden. Rows that remain visible have a blue number in the row button. The dropdown arrow for column(s) in which a criterion has been applied will also be blue.
In each column in which a filter has been applied, choose (All),
the first item in the dropdown list
OR
From the Data menu, choose Filter, Show All
From the Data menu, choose Filter, AutoFilter
If there are any blank cells in the column, the drop down list will
contain two additional items -- (Blanks) and (NonBlanks).
To find the highest or lowest numbers in the table, choose (Top 10...) from the number column dropdown.
1. In the first box, choose Top or Bottom.
2. In the middle box, enter a number.
3. In the third box, choose Items or Percent.
Note: The results are the highest or lowest values for the entire list, not the currently filtered list. If other columns are also filtered, you may see fewer than the specified number of items.
When you choose a criterion from a dropdown list, the list is filtered
for rows that are equal to the criterion. If you need more
options while filtering, you can choose (Custom...) from the dropdown
list. This opens the Custom AutoFilter dialog box.
a) From the first dropdown list, select an operator.
b) In the text box, type a value.
c) Click OK.
a) From the first dropdown list, select an operator.
b) In the text box, type a value.
c) Choose And or Or
d) From the second dropdown list, select an operator.
e) In the text box, type a value.
f) Click OK.
Download a zipped workbook with Excel 2003 AutoFilter sample data.
Last updated: March 22, 2023 11:31 AM