Question

How to select multiple values in pivot table filter

Answer 1

To select multiple values in a pivot table filter, use the Ctrl key for non-adjacent items or the Shift key for a range of adjacent items, then click 'OK' to apply the filter.

Step-by-step explanation:

To select multiple values in a pivot table filter, you need to use the filter drop-down menu. Here's how you can do it:

1. Click on the filter drop-down arrow in your pivot table.
2. To select individual items, hold down the Ctrl key on your keyboard and click on the items you want to include in the filter.
3. If you want to select a range of adjacent items, click on the first item, hold down the Shift key, and then click on the last item in the range.
4. Once you have selected all your desired items, release the Ctrl or Shift key and click 'OK' to apply the filter.

The pivot table will now update to only show the data for the items you selected. Remember that you can also use the search function within the filter drop-down to quickly find specific items.