Table properties: general

Several properties apply to the table as a whole. You can:

  • Show or hide empty rows and columns. (An empty row or column has nothing in any of the data cells.)
  • Control the default number of rows to display in long tables. To display all the rows in a table, regardless of how long it is, clear Display table by rows. Note: This feature applies only to legacy tables.
  • Control the placement of row labels, which can be in the upper left corner or nested.
  • Control maximum and minimum column width (expressed in points).

To change general table properties:

  1. From the menus, choose:

    Format > Table Properties...

  2. Click the General tab.
  3. Select the options that you want.
  4. Click OK or Apply.

The new properties are applied to the selected pivot table.