Forum Discussion
Pivot table - how to collapse entire table?
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...
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.