Formatting colulmn headers and subtotal

Hello,

When using Pivot tables how do I style the SubTotal rows and Column filter selectors (the cells with the down arrows in them).

Thanks,
Justin

Hi Justin,

Please set the property PivotTable.AutoFormatType.

If it does not support your need, please create a file to show your need with Excel.

Hi Warren,

The Autoformat is very helpful, thank you. Howerver, is it possible to create our own custom formats using spcific colors or font sizes? For example, Report7 is very close to what our company is looking for but we would like to have the sub total rows in black background and a white foreground. Is this possible, I tried find ways to customize the styles of the pivottable but was not able to isolate specific areas.

Thanks,
Justin

Hi Justin,

It's not supported. Now we force Excel to refesh the pivot table when the file is loaded with Excel.The pivot cells' styles will be lost.

We are considering the feature of calculating the pivot cell data and style in running time.Only when the feature is supported , the pivot table could be custom formatted.