Show or hide the Commands and Options dialog box

Office PivotTable

Show or hide the Commands and Options dialog box

Do one of the following:

  • If the PivotTable list toolbar is displayed, click Commands and Options on the toolbar.
  • If the toolbar is hidden, right-click the PivotTable list, and then click Commands and Options.

Note   If you leave the Commands and Options dialog box displayed while you select different parts of the PivotTable list or other Microsoft Office Web Components, the available sections and their contents change to reflect your current selection. If you select a part of the Web page other than an Office Web Component, the dialog box will be hidden.