Forum Discussion
Pivot Table Elements
I'm looking for documentation that defines all of the various table elements for creating custom Pivot Table Styles. Some are pretty obvious (Whole Table, Header Row, Grand Total Row, etc.), but there are some that seem to have more complex settings. For instance, I applied a Fill format to "Row Subheading 2" and not only did it change the background color of the row, but it also added that background color to every other column. I do not want the columns colored, so I'm not sure how to fix it.
Is there any documentation anywhere that explains all of the available Table Elements for creating/modifying an Excel PivotTable Style?? I want to know what each and every setting does so that I can get my PivotTable to look the way I want. Below is a snapshot of the first group of Style Settings. There are more, so I'm not just looking for those in this one snapshot.
All help is greatly appreciated!
2 Replies
HelloSings4Fun,
Microsoft documentation confirms that PivotTable styles are made up of individual Table Style Elements that control formatting for specific parts of the table. Common elements include Whole Table, Header Row, Total Row, First Column, Last Column, Row Stripe, Column Stripe, Row Subheading levels, Column Subheading levels, Data Cells, Blank Rows, and Subtotal Elements. Row Subheading 2 colors the entire row across all columns because it formats the full row level. For reference see Microsoft links https://support.microsoft.com/en-gb/office/change-the-style-of-your-pivottable-dc5c31fc-3e85-410a-880d-9f164c3dd92c https://support.microsoft.com/en-au/office/design-the-layout-and-format-of-a-pivottable-a9600265-95bf-4900-868e-641133c05a80 https://learn.microsoft.com/en-us/office/vba/api/excel.tablestyleelements https://learn.microsoft.com/en-us/office/vba/api/excel.xltablestyleelementtype
I appreciate your response, but you didn't answer my question. I would like a list of all of the various elements and what pertains to each one. I can already figure out the more obvious ones, but some of them do things that I didn't intend and I cannot figure out how to get my design to look the way I desire. Any additional information anyone can provide that lists each element and what the format for that element will do would be greatly appreciated!
