Microsoft Office Tutorials and References
In Depth Information
To Create an Extract Range and Extract Records
To Create an Extract Range and Extract Records
To create an extract range, copy the fi eld names of the table and then paste them to an area on the worksheet,
preferably well below the table range. Next, name the pasted range Extract by using the Name box in the formula
bar. Finally, use the Advanced Filter dialog box to extract the records. The following steps show how to create an
extract range below the Silver Photography Accessories Sales Rep table and then extract records that meet the
following criteria, as entered earlier in the Criteria range:
Gender = F AND Age > 25 AND Grade > C
1
Click the Home tab
on the Ribbon.
Data tab
Advanced
button
Select range A7:J8,
click the Copy but-
ton on the Ribbon,
select cell A25, and
then press the ENTER
key to copy the
contents on the
Offi ce Clipboard to
the destination
area A25:J26.
Advanced
Filter
dialog box
instructs Excel to display
records that meet
criteria in current table
location on worksheet
Select cell A25 and
then type Extract
Area as the title.
table
range
criteria
range
Select the range
A26:J26, type the
name Extract in
the Name box in the
formula bar, and
then press the
ENTER key.
extract
range
OK button
2
Select cell A9 to
activate the
table and
then click
the Data
tab on the
Ribbon.
title identifi es
Extract Area
extract
range
Figure 5–60
Click the Advanced
button on the Ribbon to
display the Advanced Filter dialog box.
When Excel displays the Advanced Filter dialog box, click ‘Copy to another location’ in the Action area (Figure 5–60).
 
 
Search JabSto ::




Custom Search