Thread: Pivot Table- force rows with no data to be hidden
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
SaeOngJeeMa SaeOngJeeMa is offline
external usenet poster
  
Posts: 21
Default 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 With QuoteReply With Quote