You can double-click on the page field button.
Then, in the Hide Items list, select the items you want to hide
Or, drag the page field to the Row area, and select items from the
field's dropdown list of items
Then, move the field back to the page area.
Michael wrote:
Is there a way to change the way the drop down menus on the Page area of a
pivot table work? The default is to be able to choose one item or all items.
I would like to be able to choose multiple items from the drop down menu as
you can with items in the row area.
Thanks in advance for any help!
Mike...
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html