Microsoft Office Tutorials and References
In Depth Information
• Click the OK button in the
Advanced Filter dialog box to hide
all records that do not meet the
comparison criteria (Figure 5–59).
What is the main difference
between the AutoFilter query
technique and using the Advanced
Filter dialog box?
Like the AutoFilter query technique,
the Advanced Filter command
displays a subset of
the table. The primary
the two is that the
Advanced Filter com-
mand allows you to
create more complex comparison
criteria, because the criteria range
can be as many rows long as neces-
sary, allowing for many sets of
is ﬁ ltered
gender = F
age > 25
grade > C
(D or F)
To Show All Records in a Table
The following step illustrates how to show all records in the table.
1 Click the Filter button on the Data tab on the Ribbon.
Why was AutoFilter turned off?
When the Advanced Filter command is invoked, Excel disables the AutoFilter command,
thus hiding the column heading arrows in the active table as shown in Figure 5–59.
1. Press ALT + A , T
If you select the ‘Copy to another location’ option button in the Action area of the
Advanced Filter dialog box (Figure 5–58), Excel copies the records that meet the com-
parison criteria in the criteria range to another part of the worksheet, rather than display-
ing them as a subset of the table. The location where the records are copied is called the
extract range . Creating an extract range requires steps similar to those used to create a
criteria range earlier in the chapter. Once the records that meet the comparison criteria in
the criteria range are extracted (copied to the extract range), you can create a new table or
manipulate the extracted records.