| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot to Create New TAB / Worksheet
Hello,
Pivot tables used to be able to create a new page for selected data. what / where is that functionality? How do I get "Show Pages" to work? Thanks Tracey |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot to Create New TAB / Worksheet
Select a cell in the pivot table
On the Ribbon, click the Options tab In the PivotTable group, click the dropdown arrow for Options Choose Show Report Filter Pages Select a filter, and click OK Tracey wrote: Hello, Pivot tables used to be able to create a new page for selected data. what / where is that functionality? How do I get "Show Pages" to work? Thanks Tracey -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a multi-worksheet pivot table? | Excel Worksheet Functions | |||
| HOw to create a pivot of pivot tables | Excel Worksheet Functions | |||
| Can I create a worksheet menu to select each other worksheet | Excel Discussion (Misc queries) | |||
| How do I create multiple pivot charts from one pivot table? | Charts and Charting in Excel | |||
| external import of multiple worksheet data & create pivot table | Excel Worksheet Functions | |||
Linear Mode
