Select multipul 'Page' items in a Pivot Table

  • Thread starter Thread starter ArcticWolf
  • Start date Start date
A

ArcticWolf

Hi,

I have a Pivot Table with 9 'Page' items. But I can only choose either
'All' or just one from each of the lists. Is there a way to get the 'check
boxes' in the 'Page' part - ie the same as in the 'Row' data please?
I've put the Page items into the Row but this makes my sheet too wide to fit
all the columns on the page.

Any ideas are greatly appreciated.

Thanks in advance,

AW
 
You can't get check boxes in the page field in Excel 2000. To hide items
you can do the following:

In the pivot table, double-click the page field button.
In the PivotTable Field dialog box, there's a 'Hide items' list
Click on an item in that list to hide it.
To see that item again, click on the item in the list, to unselect it.
Click OK to close the dialog box.
 
Back
Top