Excel displays the table rows that contain the five highest values in the column.
- Click the Exceptions column filter arrow, and then click Clear Filter from “Exceptions”.
Excel removes the filter.
- Click the Date column filter arrow, click Date Filters, and then click Custom Filter.
The Custom AutoFilter dialog box opens.
- In the upper-left list, click is after or equal to. In the upper-right list, click
3/8/2010. In the lower-left list, click is before or equal to. In the lower-right list,
click 3/14/2010. - Click OK.
Excel filters the table.
Because you left the AND option selected, Excel displays all table rows that contain a date
from 3/8/2010 to 3/14/2010, inclusive.
- On the Quick Access Toolbar, click the Undo button to remove your filter.
CLEAN UP Save the PackageExceptions workbook, and then close it.
Limiting Data That Appears on Your Screen 353