Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
pivot tables reports - altering display of (blank) cells | Excel Worksheet Functions | |||
blank cell turns to 0 | New Users to Excel | |||
Pivot Table Row Cell (Blank) | Excel Worksheet Functions |