good afternoon, everyone!
I have been trying to solve a slight problem that has been bothering me for a while.
The problem is as follows: I usually use the white color for all cells on my worksheets (adds a bit of professional look) but when it comes to placing pivot tables on a worksheet I want the pivot table to fit the entire worksheet by being with the same stylistic look (I want all of the cells to be in white color). It looks okay if I preliminary paint all the cells into white and then start to add rows/columns. But the problem starts when I begin to collapse rows or columns. The area by which the pivot table was decreased gets regular formatting and the cell borders appear but I don't want that. So the entire worksheet is white with no borders but the area of the row/column that was just collapsed has a different formatting. I already tried conditional formatting and have set rules that stipulate painting all the cells that are (and are not) empty in white but anyway the problems remains.
Anyone knows what should be done to solve this?
PS I also tried formatting cells in pivot table options but the same result
many thanks in advance
Bookmarks