Is there a way to force rows in a Pivot Table to be hidden? Thanks. Best Regards, Dean
S SaeOngJeeMa Nov 8, 2007 #1 Is there a way to force rows in a Pivot Table to be hidden? Thanks. Best Regards, Dean
D Debra Dalgleish Nov 8, 2007 #2 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.
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.
