Pivot Table Filter

[wilest]

Hi, is it possible if you have a pivot table and you want to filter the data, to say select a value in the middle and hold down shift and select the bottom item and the all items in between are selected?

 

[Yard]

Not that I'm aware of. You can use the keyboard to make selections more quickly. Use the spacebar to toggle the selection and the up/down keys to move through the list of items.

The alternative is to have some VBA to make the selection for you.

 

[wilest]

Thank you for the reply, will try that!