Deleting the (blank) cell out of a Pivot Table

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

I'm trying to delete the cell that reads "(blank)" on a Pivot Table, I have
tried every possible setting(except for your advice)and I cant achieve this
setting. I'm trying to print the pivot table as a table and I don't want to
see the "(blank)" cell written.

Thank you for your help!

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

1. Select the cells in the pivot table
2. Choose Format>Conditional 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
 
Back
Top