Microsoft Office Tutorials and References
In Depth Information
Figure 18-13: The pivot table is filtered by date.
Copying a pivot table's content
A pivot table is very flexible, but it does have some limitations. For example, you can't insert new rows or
columns, change any of the calculated values, or enter formulas within the pivot table. If you want to manipulate a
pivot table in ways not normally permitted, make a copy of it so it's no longer linked to its source data.
To copy a pivot table, select the entire table and choose Home⇒Clipboard⇒Copy (or press Ctrl+C). Then select a
new worksheet and choose Home Clipboard⇒Paste⇒Paste Values. The contents of the pivot table are copied to
the new location so that you can do whatever you like to them. You also may want to copy the formats from the
pivot table. Select the entire pivot table and then choose Home⇒Clipboard⇒Format Painter. Then click the upper-
left corner of the copied range.
Note that the copied information is not a pivot table, and it is no longer linked to the source data. If the source
data changes, your copied pivot table does not reflect these changes.
More Pivot Table Examples