• Removing pivot table formatting in 2007

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Removing pivot table formatting in 2007

    Author
    Topic
    #466020

    When I do pivot tables in 2007, Excel insists on formatting with grey cell colors and blue headings. I cannot find where to go to deselect the formatting options. THere used to be a fomat screen where one could select a pre-designed format or no format, which is my pref. Thanks.

    Viewing 1 reply thread
    Author
    Replies
    • #1205885

      When you have the table selected, there should be a Design tab in the Pivot Table Tools section on the right hand side of the Ribbon. The styles are all there.

    • #1205892

      Super! Thanks much.

    Viewing 1 reply thread
    Reply To: Removing pivot table formatting in 2007

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: