If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot Table
I want to format a pivot table in such that each of the blank cells in a
column can be formatted to be blank instead of the words (blank) in the cell. |
#2
|
|||
|
|||
Pivot Table
On May 12, 11:19*am, dwake wrote:
I want to format a pivot table in such that each of the blank cells in a column can be formatted to be blank instead of the words (blank) in the cell. Instead of blank, what about invisible? Use a conditional formatting that changes values that equal (blank) to a white font, the values will no longer appear in the worksheet, unless highlighted of course. HTH, Reeza |
#3
|
|||
|
|||
Pivot Table
Hi
Click on the field and de-select Blank -- Regards Roger Govier dwake wrote: I want to format a pivot table in such that each of the blank cells in a column can be formatted to be blank instead of the words (blank) in the cell. |
Thread Tools | |
Display Modes | |
|
|