View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Replace (blank) entry in a pivot report with clear cell

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.

PeterGilbert wrote:
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
Contextures
http://www.contextures.com/tiptech.html