How do I find the "Show Pages..." Pivot table feature in 2007?

G

Guest

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
 
D

Debra Dalgleish

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show Pages for Excel 2007 Pivot Tables 5
Pivot Table Show Pages missing from Excel XP 1
Question on the occupied field of the pivot table in excel spreadsheet 0
how do I get a top 25 on a pivot table in excel 2007 1
Pivot Table - Changes 5
Show Pivot Table Dates in a Month/Year Linear Fashion 2
How do I save Pivot Table Data 4
Excel 2007 pivot table source table 1

Top