Export (0) Print
Expand All
ABS
AND
ASC
COS
DAY
DDB
EXP
FV
IF
INT
LEN
LN
LOG
MAX
Me
MID
MIN
MOD
NOT
IS
NPV
ODD
OR
PI
PMT
PV
SIN
SLN
SUM
SYD
T
TAN
VAR
Expand Minimize
This topic has not yet been rated - Rate this topic

Filter items

Archived content. No warranty is made as to technical accuracy. Content may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

You can add and remove filters for items in alist,document library, ordiscussion board. You can also add, edit, or remove custom filters with multiple criteria for each column by editing the list in datasheet view.

Note: You can edit a list in datasheet view only if a datasheet program compatible with Microsoft , such as , is installed on your computer.

Add and remove filters

  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.

Add, edit, and remove custom filters by editing the datasheet

  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.

Related Topics

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.