show pages on a pivot in 2007

  • Thread starter Thread starter terri
  • Start date Start date
T

terri

How do I do a "show pages" on a pivot table in Excel 2007??? I did it in
2003, but can't figure out how to do it in 2007.

Thanks!
 
Hi,

Click on the report filter cell of the pivot and then go to Pivot Table
Tools > Options > Pivot Table > Options > Show Report Filter Pages
 

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

Pivot Tables: Excel 2003 vs Excel 2007 2
PivotTable PageFields c# / api changes from Excel 2003 to Excel 20 2
How can I use a pivot table as source for a second table? 2
Excel 2007 Pivot Tables compatible with 2003 3
grand totals in pivot table rows 5
Lose formatting on pivot tables 3
Pivot Table Fields not showing 2
Pivot table Help Excel 2007 1

Back
Top