This project has moved and is read-only. For the latest updates, please go here.

How to collapse rows and columns in Pivot table

Feb 22, 2014 at 1:14 PM
HI,

Is there any way to collapse row and column in Pivot table.

It can be easy done by using excel macro

pivotfields("name").ShowDetails = false

I know we can write macro and create xlsm file, I do not want to do it.