Pivot table - how to collapse entire table?

%3CLINGO-SUB%20id%3D%22lingo-sub-2943630%22%20slang%3D%22en-US%22%3EPivot%20table%20-%20how%20to%20collapse%20entire%20table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2943630%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%20I%20have%20Microsoft%20365%20for%20Excel%20and%20would%20like%20to%20know%20if%20there%20is%20a%20way%20to%20collapse%20all%20the%20rows%20in%20a%20pivot%20table%20at%20once%20instead%20of%20clicking%20the%20collapse%20symbol%20for%20each%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2943630%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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.