Microsoft Office Tutorials and References
In Depth Information
Using Advanced Filtering
Figure 9-17: The Advanced Filter dialog box.
5. To filter the database in place (that is, to hide rows that don’t qualify), select the option
labeled Filter the List, In-Place.
If you select Copy to Another Location, you need to specify a range in the Copy To field.
6. Click OK, and Excel filters the table by the criteria that you specify.
Figure 9-18 shows the worksheet database after applying the advanced filter that displays
threebedroom homes with a pool.
Figure 9-18: The result of applying an advanced filter.
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
desired 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 labels.