Show or hide expand indicators next to items
- In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
- Click the title bar of the PivotTable list.
- On the toolbar in the PivotTable list, click Commands and Options , and then click the Behavior tab.
- Select or clear the Expand indicator check box.
Notes
- This setting does not affect the and 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.