Select multipul 'Page' items in a Pivot Table
 

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

Select multipul 'Page' items in a Pivot Table
 

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.

ArcticWolf wrote:
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.

--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Select multipul 'Page' items in a Pivot Table
 

The practical answer is Put The page file part in starting of columns.

"ArcticWolf" wrote:

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

Select multipul 'Page' items in a Pivot Table
 

sorry in row area actually.
"ArcticWolf" wrote:

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