I have selected all cells and made them white. I insert a pivot table with a report filter. When one of the filters is selected the pivot table changes size. When this happens, cells with no formatting appear beneath the pivot table. Is there a way to make sure that every cell not part of the pivot table retains its color formatting regardless of filters?

Thanks in advance.