Microsoft Office Tutorials and References
In Depth Information
To Create an Extract Range and Extract Records
Click the OK button to copy any
records that meet the comparison
criteria in the criteria range from
the table to the extract range
(Figure 5–61).
What happens to the rows in the
extract range if I perform another
advanced fi lter operation?
Each time the Advanced Filter
dialog box is used and the ‘Copy
to another location’ option but-
ton is selected, Excel clears cells
below the fi eld names in the
extract range. Hence, if you
change the comparison criteria in
the criteria range and then use
the Advanced Filter dialog box a
second time, Excel clears the pre-
viously extracted records before
it copies a new set of records that
pass the new test.
Excel copies records that
meet criteria age > 25,
gender = F, and grade >
C to extract range
grade > C
(D or F)
age > 25
gender = F
Figure 5–61
Other Ways
1. Press ALT + A , Q
To Enable AutoFilter
Setting Up the Extract
When setting up the
extract range, all of the
column headings do not
have to be copied in the
list to the proposed extract
range. Instead, copy only
those column headings
you want, in any order.
You also can type the
column headings rather
than copy them, although
this method is not
recommended because it
increases the likelihood
of misspellings or other
typographical errors.
As indicated earlier, when the Advanced Filter dialog box is used, Excel disables
AutoFilter, thus hiding the column heading arrows in an active table. The following steps
show how to enable AutoFilter.
1 Click the Filter button on the Data tab on the Ribbon to display the column heading
arrows in the table.
2 Click the Home tab on the Ribbon.
Search JabSto ::

Custom Search