Pivot Table

  • Thread starter Thread starter dwake
  • Start date Start date
D

dwake

I want to format a pivot table in such that each of the blank cells in a
column can be formatted to be blank instead of the words (blank) in the cell.
 
I want to format a pivot table in such that each of the blank cells in a
column can be formatted to be blank instead of the words (blank) in the cell.
Click to expand...

Instead of blank, what about invisible?

Use a conditional formatting that changes values that equal (blank) to
a white font, the values will no longer appear in the worksheet,
unless highlighted of course.

HTH,
Reeza
 
Back
Top