Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide or replace (blank) in a Pivot Table Column
I have created a Pivot Table and where there is no data for that column I
would like to replace the (blank) with a comment etc. I know if you sum a column etc you can put something in for empty cells. I do not want to hide the row as there is a Property Name that is required to be seen Thanks Anne |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide or replace (blank) in a Pivot Table Column
I believe if you right mouse click on the pivot table, select Table
Options, check "For empty values, show:" and fill in something, you should be set. Let me know if that's not what you were looking for. cheers, ..o. On Apr 16, 5:08 pm, enna49 wrote: I have created a Pivot Table and where there is no data for that column I would like to replace the (blank) with a comment etc. I know if you sum a column etc you can put something in for empty cells. I do not want to hide the row as there is a Property Name that is required to be seen Thanks Anne |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide or replace (blank) in a Pivot Table Column
Debra Dalgleish has an addin that does lots of things--including this:
http://www.contextures.com/xlPivotAddIn.html But you can just select one of those cells with (blank) in them and type what you want instead. enna49 wrote: I have created a Pivot Table and where there is no data for that column I would like to replace the (blank) with a comment etc. I know if you sum a column etc you can put something in for empty cells. I do not want to hide the row as there is a Property Name that is required to be seen Thanks Anne -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide or replace (blank) in a Pivot Table Column
Thanks Dave
I was trying to delete the information from the cell and would get the message "Cannot change this part of a Pivot Table Report", if I input a Zero it will change all the cells with (blanks) and that is exactly what I wanted. Thanks "Dave Peterson" wrote: Debra Dalgleish has an addin that does lots of things--including this: http://www.contextures.com/xlPivotAddIn.html But you can just select one of those cells with (blank) in them and type what you want instead. enna49 wrote: I have created a Pivot Table and where there is no data for that column I would like to replace the (blank) with a comment etc. I know if you sum a column etc you can put something in for empty cells. I do not want to hide the row as there is a Property Name that is required to be seen Thanks Anne -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace (blank) entry in a pivot report with clear cell | Excel Discussion (Misc queries) | |||
how can i hide zero results row in a pivot table? | Excel Discussion (Misc queries) | |||
hide (blank) in pivot table | Excel Discussion (Misc queries) | |||
Pivot Table - hide blank cells | Excel Discussion (Misc queries) | |||
Pivot table - hide detail for column | Excel Discussion (Misc queries) |