word (blank)

[Admin Assist]

Anyone know why the word (blank) is showing in empty
cells in a Pivot Table? I want the cells to be empty
where they should be but the word (blank) shows up in.
If I click on the the column heading and uncheck blank,
the column shrinks which is not what I want. I want the
column to show values where is is supposed to and empty
cells where it is supposed to. Thankx.

 

[Debra Dalgleish]

You could hide the (blank) entries with conditional formatting:

1. Select the cells in the pivot table
2. Choose Format>Condtional Formatting
3. Leave the first dropdown as Cell Value Is
4. From the centre dropdown, choose Equal to
5. In the text box, type (Blank)
6. Click the Format button
7. On the Font tab, choose white (or appropriate colour)
to match the cell background
8. Click OK, click OK