Pivot Table- force rows with no data to be hidden

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to force rows in a Pivot Table to be hidden? Thanks.

Best Regards,
Dean
 
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.
 
Back
Top