Replace (blank) entry in a pivot report with clear cell

G

Guest

I want to control the appearance of a pivot table report by replacing the
"(blank)" entry in some cells of the pivot table with a truely blank
appearance. I can do this by entering a zero in the data area that the pivot
table refers to and setting the sheet to return an empty cell for the
reported zero, but I cannot guarantee that other users of the sheet and it's
pivot reports will always enter zeros in cells that do not need an entry in
the data area. Peter Gilbert, New Zealand.
 
D

Debra Dalgleish

You can make the cells appear blank:

Select one of the (blank) cells in the pivot table, and type a space
character, then press the Enter key to complete the change.

Other (blank) items in the same field will also change.
 

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

how can i fill data in blank cells after copying a pivot report? 1
Totaling blank cells in Pivot Tables 8
Refreshing Pivot Table on a protected spreadsheet tab 1
Pivot Table blank rows 1
Surpressing rows and columns with zero values in a pivot table 1
PIVOT - Reference a cell outside the table for report filtering 2
How to clear the word '(blank)' from a cell in a Pivot Table 2
Formula fields in Pivot Tables? 1

Top