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



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.



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