Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 110
Default show pages on a pivot in 2007

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!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,766
Default show pages on a pivot in 2007

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"terri" wrote in message
...
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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show Pages for Excel 2007 Pivot Tables Jim Georgia Excel Discussion (Misc queries) 5 November 11th 09 03:25 AM
XL2000 Pivot Table - Show Pages LPS Excel Discussion (Misc queries) 2 October 29th 08 02:55 PM
Pivot Table Show Pages On Same WorkSheet [email protected] Excel Worksheet Functions 6 April 22nd 07 05:10 PM
Show pages without using pivot table PA_Mom Excel Discussion (Misc queries) 1 March 9th 07 04:10 PM
How do I find the "Show Pages..." Pivot table feature in 2007? Jonathan Excel Discussion (Misc queries) 1 February 9th 07 08:08 PM


All times are GMT +1. The time now is 10:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"