Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding blank cells within a Pivot Table
I have a Pivot Table that has G/L Text under Row, Years under Column and the
$$ under Data. Now, for some of the G/Ls..there is zero or blank data. Is there a way I can hide these cells within a Pivot..i know that under Table Options there is a check box for Empty cells but it looks like you have to type something in...i want to hide empty or zero cells Is there a way I can do that from a Pivot Table? Any help will be appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding blank cells within a Pivot Table
http://www.techonthenet.com/excel/pi...hide_empty.php
Regards, Ryan--- -- RyGuy "Shams" wrote: I have a Pivot Table that has G/L Text under Row, Years under Column and the $$ under Data. Now, for some of the G/Ls..there is zero or blank data. Is there a way I can hide these cells within a Pivot..i know that under Table Options there is a check box for Empty cells but it looks like you have to type something in...i want to hide empty or zero cells Is there a way I can do that from a Pivot Table? Any help will be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PIVOT TABLE WITH BLANK CELLS | Excel Worksheet Functions | |||
counting blank cells in a pivot table | Excel Discussion (Misc queries) | |||
Pivot Table with Blank Cells | Excel Discussion (Misc queries) | |||
Pivot Table -- Suppress blank cells | Excel Discussion (Misc queries) | |||
Pivot table blank/empty cells | Excel Discussion (Misc queries) |