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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table 2
Pivot tables - 'blank' label 2
Totaling blank cells in Pivot Tables 8
Using merge cells in worksheet for Pivot Table 1
Pivot Table "Field Name is not valid" error 4
Pivot Table blank rows 1
Pivot Tables 1
Adding to an existing Pivot Table 7

Back
Top