Filter Items

1. On the toolbar, click Filter. A drop-down list appears above each column containing all of the values for that column.
2. In the drop-down list for the column on which you want to filter, click the value for the items you want to display. Only items matching that value display.
3. You can continue to apply additional filters until only the desired items are displayed.
4. To remove a filter, click All in the drop-down list for the filtered column. Other filters are unaffected.

1. On the toolbar, click Edit in Datasheet.
2. Click the drop-down list for the column on which you want to filter, and then click Custom Filter.
3. On the Custom Filter dialog box, you can enter up to three rules.

   Rules applied to other columns linked by And must both be true for an item to display. Rules linked by Or display if either rule is true.

4. You can edit a custom filter at any time to broaden or narrow the displayed items by clicking Custom Filter in the drop-down list for the column in the grid view.
5. To completely remove a custom filter from a column, click Show All in the drop-down list for a column. Filters on other columns are unaffected.

   Note  You can also use the drop-down lists in the datasheet view to add, edit, or remove simple filters.

Filters added while editing in datasheet view go away if you change to the standard view, and do not return if you later go back to datasheet view.