Filtering a pivot table

  • Thread starter Thread starter adam_sipos
  • Start date Start date
A

adam_sipos

I would like to know how to deselect everything (so that I may then select
just a few items out of hundreds) in the dropdown menu for filtering rows
in a pivot table. If anybody knows how to do this, I would greatly
appreciate some advice.
 
I'm assuming you are using either 97 or 2000, in which case you will love this
routine from Debra Dalgleish, designed to make your life just that little bit
easier :-)

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------




I would like to know how to deselect everything (so that I may then select just
a few items out of hundreds) in the dropdown menu for filtering rows in a pivot
table. If anybody knows how to do this, I would greatly appreciate some advice.
 
Back
Top