Thread: How do I find the "Show Pages..." Pivot table feature in 2007?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default How do I find the "Show Pages..." Pivot table feature in 2007?
Select a cell in the pivot table
On the Ribbon, under the PivotTable Tools tab, click Options
In the PivotTable group, click the dropdown arrow for Options
Choose Show Report Filter Pages
Select a filter, and click OK

Jonathan wrote:
Excel 2003 has the feature "Show Pages..." in the Pivot Table tool bar. I
haven't yet found it in Excel 2007. If you know where it is, please holler


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

Reply With QuoteReply With Quote