Pivot Table
in [General]
|
Prev: Pivot Table/Conditional Formatting Guru Help
Next: VLOOKUP formula displays in cell, will not return data
From: dwake on 12 May 2010 14:19 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.
From: Reeza on 12 May 2010 17:40 On May 12, 11:19 am, dwake <dw...(a)discussions.microsoft.com> wrote: > 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. 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
From: Roger Govier on 12 May 2010 18:05
Hi Click on the field and de-select Blank -- Regards Roger Govier dwake wrote: > 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. |