To Filter Information in a Table:
- Choose the dropdown arrow in the column you would like to Filter. A list of possible Filters will be displayed.
- Choose the appropriate Filter(s) you would like to use.
- Choose OK when you have chosen your filter(s). Excel will display only the information in the table that meets the Filter criteria you have established.