Microsoft Office Tutorials and References
In Depth Information
Figure 9-18: The Advanced Filter dialog box.
3. Excel guesses your database range if the active cell is within or adjacent to a block of data, but you can
change it if necessary.
4. Specify the criteria range.
If you happen to have a named range with the name Criteria, Excel will insert that range in the Criteria
Range field — you can also change this range if you like.
5. To filter the database in place (that is, to hide rows that don't qualify), select the option labeled Filter the
If you select Copy to Another Location, you need to specify a range in the Copy To field. Specifying the
upper-left cell of an empty range will do.
6. Click OK, and Excel filters the table by the criteria that you specify.
Figure 9-19 shows the list after applying the advanced filter that displays three-bedroom homes with a pool.
When you select the Copy to Another Location option, you can specify which columns
to include in the copy. Before displaying the Advanced Filter dialog box, copy the de-
sired field labels to the first row of the area where you plan to paste the filtered rows. In
the Advanced Filter dialog box, specify a reference to the copied column labels in the
Copy To field. The copied rows then include only the columns for which you copied the