Select multipul 'Page' items in a Pivot Table ArcticWolf 12/23/2008 3:02:06 PM 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

Re: Select multipul 'Page' items in a Pivot Table Debra Dalgleish <dsd[ at ]contexturesXSPAM.com> 12/26/2008 6:25:54 PM 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: [Quoted Text] > 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

RE: Select multipul 'Page' items in a Pivot Table Satyendra_Haldaur 12/29/2008 2:28:00 PM The practical answer is Put The page file part in starting of columns. "ArcticWolf" wrote: [Quoted Text] > 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

RE: Select multipul 'Page' items in a Pivot Table Satyendra_Haldaur 12/29/2008 2:29:01 PM sorry in row area actually. "ArcticWolf" wrote: [Quoted Text] > 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