Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table- force rows with no data to be hidden
Is there a way to force rows in a Pivot Table to be hidden? Thanks.
Best Regards, Dean |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table- force rows with no data to be hidden
Thanks Debra. Good advice.
-- Best Regards, Dean "Debra Dalgleish" wrote: You can filter the grand total values in Excel 2007. In earlier versions that feature isn't available. You could manually hide the rows, or start an AutoFilter outside of the pivot table. SaeOngJeeMa wrote: Is there a way to force rows in a Pivot Table to be hidden? Thanks. Best Regards, Dean -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does same data value appear twice in rows of a Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table - How to keep data hidden | Excel Worksheet Functions | |||
Sort Pivot Table using hidden data field | Excel Discussion (Misc queries) | |||
Pivot Table On Hidden Rows | Excel Discussion (Misc queries) | |||
How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) |