Microsoft Office Tutorials and References
In Depth Information
Creating an advanced filter
Creating an advanced filter
When you create a filter using AutoFilter, you can create
complex rules to filter the contents of the worksheet. The
limitation is that the rules used to filter the worksheet aren’t readily
discernible. If you want the rules used to filter a column’s values
to be displayed in the body of the worksheet, you can write
each rule in a cell and identify those cells so that Excel knows
how to filter the worksheet. If you ever want to change the rules
used to filter your data, all you need to do is change a rule and
reapply the filter.
Build an advanced filter
1 Copy the column titles of the list that you want to filter.
2 Paste the titles into another spot on your workbook.
3 Under their respective titles, type the criteria that you want the
filter to meet.
4 Select a cell in the list that you want to filter.
5 Click the Data tab.
6 In the Sort & Filter group on the ribbon, click Advanced.
7 Click the List Range box.
8 If necessary, select the entire list that you want to filter, including
the column headers.
9 Click the Criteria Range box.
10 Select the cells on which you want to base the filter, including the
column headers.
11 Click OK.
4
1
6
5 2
3
10
8
11
9
7
TIP If you want to copy the results of the filter to another cell
range, select the Copy To Another Location option and then
specify the range of cells into which you want Excel to copy the filtered
list.
Search JabSto ::




Custom Search