MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot table "uncheck"

Posted by Loren on September 21, 2000 10:04 AM

I use data from 50 states. If I want to see a few
select states, it is annoying to "uncheck" 45 or so.
Is there a setting that starts with all unchecked and
I check the ones to show? Or macro code? thanks

Posted by Celia on September 21, 2000 4:59 PM

Perhaps you can do it by setting some Custom Views?
Have a look at Custom View in on-line Help.