pivottable

[Guest]

Dear all,

Is there anybody how knows what the shortcut is to deselect fields in a
pivottable? (I have a pivottable with 1000 possiblities for a field, but I
only need some of them)

Best regards,
Jan

 

[Debra Dalgleish]

Excel 2002 has a Show All checkbox to show or hide items in a field. For
earlier versions, you can use code. There are examples here:

http://www.contextures.com/xlPivot03.html