Pivot table - how to collapse entire table?

New Contributor

Hi - I have Microsoft 365 for Excel and would like to know if there is a way to collapse all the rows in a pivot table at once instead of clicking the collapse symbol for each row.

 

Thanks for any help!

2 Replies

@Jane_Scheidel You should be able to right-click on such a field and then choose Collapse, Collapse entire field.

Thank you so much for responding! I was not able to do get the collapse options when I right clicked on the field. But I did find a way on the Data Tab on the Ribbon, in the Outline group, is "Show detail" and "Hide detail" and this collapse it for all the rows at once.