ExcelBanter - Pivot Table- force rows with no data to be hidden

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table- force rows with no data to be hidden (https://www.excelbanter.com/excel-discussion-misc-queries/165205-pivot-table-force-rows-no-data-hidden.html)

SaeOngJeeMa

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

SaeOngJeeMa

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

All times are GMT +1. The time now is 11:45 AM.