Site icon ExcelNotes

How to Show or Hide "Expand or Collapse" Buttons in Pivot Table

Please follow the steps below to show or hide "Expand or Collapse" Buttons in Pivot Table.

Step 1: Click any cell in the Pivot Table;

Step 2: Click "PivotTable Analyze" Tab from the Ribbon (or the Analyze Tab if you are using an earlier Excel version);

Step 3: Click "+/- Buttons" in the "Show" section;

Step 4: You will find that the "+/- Buttons" disappear.

Exit mobile version