Show or hide items that have no data

Office PivotTable

previous page next page

Show or hide items that have no data

  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 Report tab.
  3. Select or clear the Empty rows and Empty columns check boxes.
previous page start next page