| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Show Page Fields
In Excel 2000 in the Pivot function you could "Show Pages" in a Pivot Table
that would automatically put each unique page field on a separate tab in the existing worksheet. I cannot find that function in Excel 2003. Does anyone know if this still exists? Thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - Show Page Fields
On the Pivot table toolbar, choose PivotTableShow Pages
If you use the command frequently, you can add it as a button on the PivotTable toolbar. SFrost wrote: In Excel 2000 in the Pivot function you could "Show Pages" in a Pivot Table that would automatically put each unique page field on a separate tab in the existing worksheet. I cannot find that function in Excel 2003. Does anyone know if this still exists? Thank you! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table | Excel Discussion (Misc queries) | |||
| Pivot table page filter not accepting multiple values. Workaround? | Excel Worksheet Functions | |||
| How do I set up filter for page fields in pivot table? | Excel Discussion (Misc queries) | |||
| How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
| Is there an autofill for all row fields in a pivot table? | Excel Worksheet Functions | |||
Linear Mode
