Nov 09 2021 09:27 AM
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!
Nov 09 2021 09:38 AM
@Jane_Scheidel You should be able to right-click on such a field and then choose Collapse, Collapse entire field.
Nov 09 2021 09:53 AM