Apply a filter in Datasheet view

Microsoft Datasheet View

Apply a filter in Datasheet view

  1. Click the drop-down arrow in the column header.

    Note  If a column does not support filtering, the filtering commands will be disabled for that column.

  2. In the list, do one of the following:
    • Click an entry to filter for records that have the matching entry. For multi-choice columns, records that contain the selected entry will be selected.
    • Click (Blanks) to filter for records that don't have a value.
    • Click (Non-Blanks) to filter for records that have a value.
    • Click Custom Filter to define custom filter criteria. In the Custom Filter dialog box, specify the comparison operators and values. For example, to search for names beginning with "A" or "B", select begins with in the top left list and type A in the top right list. Select begins with in the middle left list and B in the middle right list. Select the top Or operator to link the two criteria, and click OK.

Note  You can filter and sort multiple columns in a view.