• 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: Reply #1205885 in 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:




    Cancel