Microsoft Office Tutorials and References
In Depth Information
Limiting data that appears on your screen
Click OK to hide all rows that contain a date from the month of March.
Click the Center column filter arrow and then, from the menu that appears, clear the
Select All check box to clear all the check boxes in the list.
Select the Midwest check box, and then click OK to display 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 to
clear all active filters but leave the filter arrows in place.
Click the Route column header’s filter arrow, and then enter RT9 in the Search box to
narrow the filter list so it displays only those routes with an identifier that includes the
characters RT9 .
Click OK to apply the filter and display exceptions that occurred on routes with
identifiers that contain the string RT9 .
Click the MarchDailyCount sheet tab to display its worksheet.
Click any cell in the Excel table.
Click the Exceptions column filter arrow, point to Number Filters , and then click Top
10 to open the Top 10 AutoFilter dialog box.