Use
You can choose to display only those rows that meet certain criteria in one or more columns.
Procedure
Setting Filters
- To set a filter:
- Choose .
Alternatively:
- Right-click a column header.
- Choose Set filter.
- To specify the values or ranges displayed in your list, enter the From/To values for each column selected.
The Set Values for Filter Criteria screen appears.
If you selected a cell using the right mouse button and set a filter, the Set Values for Filter Criteria screen appears with the contents of the cell you selected as the value of the relevant filter criteria. After confirming this screen, the column is filtered according to this value.
Only one filter is active at one time in a list. This filter consists of one or more filter criteria. To filter several columns in a list, set a filter with multiple filter criteria.
- To apply your settings, choose .
No comments:
Post a Comment