Microsoft Office Tutorials and References
In Depth Information
Limiting data that appears on your screen
When you point to Text Filters (or Date Filters for date values or Number Filters for number
values) and then click Custom Filter, you can define a rule that Excel uses to decide which
rows to show after the filter is applied. For instance, you can create a rule that determines
that only days with package volumes of less than 100,000 should be shown in your
worksheet. With those results in front of you, you might be able to determine whether the
weather or another factor resulted in slower business on those days.
Excel indicates that a column has a filter applied by changing the appearance of the
column’s filter arrow to include an icon that looks like a funnel. After you finish examining
your data by using a filter, you can remove the filter by clicking the column’s filter arrow
and then clicking Clear Filter. To turn off filtering entirely and remove the filter arrows,
display the Home tab and then, in the Editing group, click Sort & Filter and then click Filter.