+ Reply to Thread
Results 1 to 3 of 3

pivottable - how to clear pivotformatting and be left with the content

  1. #1
    Forum Contributor timtim89's Avatar
    Join Date
    01-05-2012
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    141

    pivottable - how to clear pivotformatting and be left with the content

    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

  2. #2
    Registered User
    Join Date
    04-08-2014
    Location
    FRANCE
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: pivottable - how to clear pivotformatting and be left with the content

    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.

  3. #3
    Forum Contributor timtim89's Avatar
    Join Date
    01-05-2012
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    141

    Re: pivottable - how to clear pivotformatting and be left with the content

    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..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to clear content up to row 2?
    By simplyfocus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2012, 02:17 PM
  2. Clear some content of a row
    By Nina07 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-01-2010, 08:37 AM
  3. Clear content
    By spoko in forum Excel General
    Replies: 2
    Last Post: 08-29-2007, 10:51 PM
  4. Clear an XML Map of all content
    By DangerMouse in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2006, 09:45 AM
  5. PivotTable: how to align row data to the left?
    By blackpuppy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2006, 10:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1