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. |
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 |
All times are GMT +1. The time now is 11:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com