Excel Formatting Pivot Table

[Dastnai]

Hi Everyone,

I have an excel sheet with a pivot table/slicer that is formatted with a dark border. However, when I use the slicer to drill down the cells that are now empty show no formatting. Is there a way that I can keep the dark border once I drill down?


Regards,

Dastnai

 

[SpillerBD]

It sounds like you are formatting the Cells and not the Pivot Table.
Use the Pivot Table styles to format the Pivot Table. There is a custom option too.

 

[Dastnai]

So I have the pivot table formatted, however when I drill down with the slicer my formatting for the cells change to no formatting. I believe this is because when I drill down there is less data so the cells resort to no format. Not sure how to fix this.

 

[SpillerBD]

Mike Girvin, ExcelIsFun.
He gets into the formatting problems of Pivot Tables in the first 15 minutes of this video.

https://www.youtube.com/watch?v=e-yuYNgsHAk

 

[Dastnai]

Thanks SpillerBD!