| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hide (blank) in pivot table
Dear All,
I created a pivot table where the empty cells are represented by (blanks). By clicking on table options and selecting 'for empty cells show' I tried to get rid of this (blank) description in my cells. However it will not go away. Has anyone a suggestion for this problem? Thanks a lot in advance. Kind regards, Nynke |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hide (blank) in pivot table
In your pivot table click on a cell with a (blank) and put a space there.
All the (blank) items in that column should vanish. "Nynke" wrote: Dear All, I created a pivot table where the empty cells are represented by (blanks). By clicking on table options and selecting 'for empty cells show' I tried to get rid of this (blank) description in my cells. However it will not go away. Has anyone a suggestion for this problem? Thanks a lot in advance. Kind regards, Nynke |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i hide the field list in a pivot table? | Excel Discussion (Misc queries) | |||
| How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
| Help!!! Pivot table from mac goes totally blank on pc. | Excel Discussion (Misc queries) | |||
| Hide part of Pivot Table | Excel Worksheet Functions | |||
| Counting blank cells in Pivot Table | Excel Worksheet Functions | |||
Linear Mode
