Microsoft Office Tutorials and References
In Depth Information
Querying a Table Using AutoFilter
2
Click M in the Gender list to
remove the check mark and cause
Excel to hide all records represent-
ing males, so that only records
representing females appear.
fi lter icon
indicates Gender
fi eld is being used
to fi lter records
Click the OK button.
Sales
Area
arrow
Click the Sales Area
arrow in row 8 to
display the Sales Area
AutoFilter menu
(Figure 5–51).
row headings of
selected records
that passed level
test are blue
Sort by Color
command
Sales Area
AutoFilter
menu
Filter by Color
command
Excel displays only
records representing
female sales reps; records
representing male sales
reps are hidden
Figure 5–51
3
Click Outside in the
Sales Area list to
remove the check
mark and hide all
records that repre-
sent females who
are not inside sales
reps (Figure 5–52).
fi lter icons
indicate fi elds
being used to
fi lter records
Click the OK button.
Why are the row
headings of some
rows displayed
in blue?
Excel displays row
headings in blue to
indicate that these
rows are the result
of a fi ltering process.
Excel displays
only records
representing inside
female sales reps
Figure 5–52
Are both fi lters now applied to the table?
Yes. When you select a second fi lter criterion, Excel adds it to the fi rst. Hence, in the previous steps, each record must
pass two tests to appear as part of the fi nal subset of the table.
 
Search JabSto ::




Custom Search