Microsoft Office Tutorials and References
In Depth Information
Limiting data that appears on your screen
13 In the middle field, enter 5 and then click OK to display the table rows that contain
the five highest values in the Exceptions column.
Click the Exceptions column filter arrow, and then click Clear Filter from
“Exceptions” to remove the filter.
Click the Date column filter arrow, point to Date Filters , and then click Custom Filter
to open the Custom AutoFilter dialog box.
In the upper-left list, click is after or equal to .
In the upper-right list, click 3/8/2013 .
In the lower-left list, click is before or equal to .
In the lower-right list, click 3/14/2013 .
Click OK . Because you left the And option selected, Excel displays all table rows that
contain a date from 3/8/2013 to 3/14/2013, inclusive.