Show All

Allow multiple selection in a filter field

You can specify whether a field in the filter area will allow single or multiple selection. In single-selection mode, selecting an item automatically clears the previous selection. In multiple-selection mode, when you select an item, previously selected items remain selected.

1. Open a datasheet or form in PivotTable view or PivotChart view.
2. Select the field in the filter area for which you want to change the setting.
3. On the PivotTable or PivotChart toolbar, click Properties , and then click the Filter and Group tab.
4. Select or clear the Allow selecting multiple items when in filter area check box.

Notes

• By default, multiple selection is enabled.
• This setting applies only when the field is in the filter area. If you move the field to another area in the view, the field will always support multiple selection.