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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Help! 1
Pivot Table Filter values 5
pivot table filters 1
Pivot table report invalid 0
Update Filter List AFTER Filter Applied 3
Adding Report Filters to Excel Pivot Tables via VB. 1
Pivot Table Filter by User Entry 1
Clear all pivot table fields with a Macro 2

Back
Top