Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
|
|||
|
|||
Quote:
try conditional formating =AND(B11="(blank)") take foreground and background as white, you can see them as blank cells suppose B11 contains (blank), then the conditional formatting shows you as real blank cell (empty) all the best
__________________
Thanks Bala |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions |