Show or hide expand indicators next to items

Office PivotTable

Show or hide expand indicators next to items

  1. Click the title bar of the PivotTable list.
  2. On the toolbar in the PivotTable list, click Commands and Options , and then click the Behavior tab.
  3. Select or clear the Expand indicator check box.

Notes

  • This setting does not affect the Plus box and Minus box boxes that appear to the right of the items at the lowest level.
  • Items at the lowest level in a row or column area don't have expand indicators to their left.