Show or hide expand indicators next to items

Office PivotTable

Show or hide expand indicators next to items

  1. In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
  2. Click the title bar of the PivotTable list.
  3. On the toolbar in the PivotTable list, click Commands and Options Button image, and then click the Behavior tab.
  4. 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 on their left.
  • If you don't want users to be able to change whether expand indicators are displayed, you can restrict access to the Commands and Options dialog box in the browser.