Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shift Rows Down When Expand Pivot Table
Hi,
I have a number of pivot tables on my worksheet (xl2003). There is data in the rows beneath the pivot tables that I do not want to overwrite. Besides inserting a bunch of blank rows and hiding the ones I don't need, is there a way to shift the rows containing data beneath the pivot tables down if the pivot expands? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Expand Collapse not showing for Cube | Excel Discussion (Misc queries) | |||
Expand the fields used in a Datasource for a Pivot Table | Excel Discussion (Misc queries) | |||
pivot table source data expand to new entries when refresh? | Excel Discussion (Misc queries) | |||
Collapse/Expand Buttons in a Pivot Table | Excel Worksheet Functions | |||
How do I expand the column size on a Pivot Table using Excel 97? | Excel Discussion (Misc queries) |