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 magic
i want to see NA in all cells where data is empty in pivot table. Is possible without vba? thanks in advance -- bill_ball |
#2
|
|||
|
|||
Pivot table magic
EXCEL 2007
Right click somewhere inside the Pivot Table and click on PivotTable Options .. . . PivotTable Options window should launch Layout & Format tab / in here there is a box called:- For empty cells show: Place NA in the above cell. I think that the above should give you what you want. If you agree please hit Yes. Thanks. "bill_ball" wrote: i want to see NA in all cells where data is empty in pivot table. Is possible without vba? thanks in advance -- bill_ball . |
Thread Tools | |
Display Modes | |
|
|