Filter by Selection

The Filter by Selection Command filters the current List by selecting a field in the list and automatically building a filter based on that selection. Click in the cell that will be used to construct the filter and then select the Filter By Selection option on the View menu or press the corresponding toolbar button.