| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create multiple worksheets from Page Pivots
I have created a pivot table, and I have a Year as the "page" pivot. I would
like to have all the years show up as separate worksheets rather than having to change the Page pivot. I know that this is possible, I have seen it done, but I can't seem to remember hoiw this is done... Help! Vinay |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create multiple worksheets from Page Pivots
Select a cell in the pivot table
From the pivot toolbar, choose PivotTable Show Pages Select a page field in the list, and click OK Vinay wrote: I have created a pivot table, and I have a Year as the "page" pivot. I would like to have all the years show up as separate worksheets rather than having to change the Page pivot. I know that this is possible, I have seen it done, but I can't seem to remember hoiw this is done... Help! Vinay -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create multiple worksheets from Page Pivots
Thanks, Debra...
Vinay "Debra Dalgleish" wrote: Select a cell in the pivot table From the pivot toolbar, choose PivotTable Show Pages Select a page field in the list, and click OK Vinay wrote: I have created a pivot table, and I have a Year as the "page" pivot. I would like to have all the years show up as separate worksheets rather than having to change the Page pivot. I know that this is possible, I have seen it done, but I can't seem to remember hoiw this is done... Help! Vinay -- 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 | |||
| Page Setup for multiple worksheets macro problem | Excel Discussion (Misc queries) | |||
| How do I print multiple worksheets on one page? | Excel Discussion (Misc queries) | |||
| How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
| create multiple worksheets in workbook from one csv file | Excel Discussion (Misc queries) | |||
| Auto page numbering for several worksheets | Excel Worksheet Functions | |||
Linear Mode
