352 Chapter 12 Focus on Specific Data by Using Filters
Excel displays only those exceptions that occurred in the Midwest distribution center during
the month of April.- On the Home tab, in the Editing group, click Sort & Filter, and then click Clear.
Excel clears all active filters but leaves the filter arrows in place.- Click the Route column header’s filter arrow, and then type RT9 in the Search box.
The filter list displays only routes with identifiers that include the characters RT9.- Click OK.
Excel applies the filter, displaying exceptions that occurred on routes with identifiers
that contain the string RT9.- Click the MarchDailyCount sheet tab.
The MarchDailyCount worksheet appears.- Click any cell in the Excel table.
- Click the Exceptions filter arrow, click Number Filters, and then click Top 10.
The Top 10 AutoFilter dialog box opens.You can specify the rank, number, and type of items displayed by the Top 10 AutoFilter.- In the middle field, type 5.
- Click OK.
Excel filters the table.