Microsoft Office Tutorials and References
In Depth Information
l Down arrows appear
next to your field
headers.
4
Click a down arrow.
The Sort and Filter
dialog box appears.
4
5
Click to deselect the
items you do not want
to appear (
changes
5
to ).
6
Click OK.
6
l Excel filters your list.
In this example, CA and
MA do not appear.
Did You Know?
When you click the down arrow Excel creates when
you click Filter, Excel provides options for filtering
your data. It also provides options for sorting your
data. You can perform simple sorts, complex sorts,
or you can sort by cell color, font color, or icon.
See Task #s 39 and 40 to learn more about
sorting.
Did You Know?
When you perform a filter, Excel places down
arrows next to your field headers. Fields you have
filtered have a filter button ( ) on the down
arrow. Fields you have sorted in ascending order
have an up-arrow button on the down arrow ( ).
Fields you have sorted in descending order have a
down-arrow button on the down arrow (
).
Chapter 4: Manipulate Records
87
 
Search JabSto ::




Custom Search