Microsoft Office Tutorials and References
In Depth Information
Appendix: AutoFilter in Excel 2003
FIGURE 22.5 Filter by Color
In the data of the sheet called Color in the Chapter 22 file, select a cell in the
column containing cells formatted by color, as shown in Figure 22.5. On the Data
ribbon, click on the AutoFilter, and then click on the arrow in the column header and
select Filter by Color. You can now apply Filter by Cell Color. (You can also Filter by
Font Color or Filter by Cell Icon.)
Remember: To reapply a filter after you change the data, click a cell in the
range or table, and then click Reapply in the Data ribbon, under the Sort & Filter
APPENDIX: AUTOFILTER IN EXCEL 2003
Filtering in previous versions of Excel is done through the Data menu. To activate
ltering, click on the Data menu and select AutoFilter.
When you use Data
AutoFilter, arrows will appear to the right of
the headers in the
(see Figure 22.6).
When you choose to apply one of the
lters, Excel indicates the
with blue highlighting. Try to
lter the Job column for Electrician; and in the Gender
column for M (male). See Figure 22.7.
Look at the results in Figure 22.8; the table is
ltered: all the male electricians.
You can also use Custom AutoFilter. For example,
lter all the records for Age
older than 40. See Figure 22.9.
Filtering is a fast way to
nd and work with subsets of data in a table/database.
ltered table displays only the rows that meet the conditions you itemize or specify
for a column.