Hi,
How do I clear the pivot table formatting? I want just the content of the pivottable, but can't figure out how to get rid of the formatting?
Thanks in advance
Timo
Hi,
How do I clear the pivot table formatting? I want just the content of the pivottable, but can't figure out how to get rid of the formatting?
Thanks in advance
Timo
Click the PivotTable report.
On the Options tab, in the Actions group, click Select, and then click Entire PivotTable.
Press DELETE.
NOTE: Deleting the associated PivotTable report for a PivotChart report creates a standard chart that you can no longer change.
But this deletes the data. I want the content without the pivottable. I can of course do a copy-paste (paste values), but I was hoping for a nicer way to do it..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks