Hiding rows and columns in a table

  1. Activate the pivot table.
  2. Click the category label for the row or column you want to hide, then click the label again to select the entire row or column.

    Note: For legacy tables, you select an entire row or column by right-clicking the associated category label and choosing Select > Data and Label Cells from the menu.

  3. Right-click the category label and from the menu, choose Hide Category.

    or

  4. From the View menu, choose Hide.