How to filter by form :
- In the Sort & Filter group on the Home tab, click Advanced and then click Filter By Form.
- In the Filter by Form window , on the Look for tab, enter the value in the field or fields you want to use as the filter.
- Click the Or tab to set up OR conditions.
- In the Sort & Filter group, click Toggle Filter to apply the filter. Click Toggle Filter again to remove the filter.
- On the Home tab, in the Sort & Filter group, click Advanced,and then click Advanced Filter/Sort.
- In the Advanced Filter/Sort window , in the Field row in the grid, select the fields you want to use in the filter.
- In the Criteria row , specify the expression to use in the filter.
- In the Sort & Filter group, click Toggle Filter to apply the filter. Click Toggle Filter again to remove the filter.
No comments:
Post a Comment