Table properties: borders

For each border location in a table, you can select a line style and a color. If you select None as the style, there will be no line at the selected location.

To change table borders:

  1. From the menus choose:

    Format > Table Properties...

  2. Click the Borders tab.
  3. Select a border location, either by clicking its name in the list or by clicking a line in the Sample area.
  4. Select a line style or select None.
  5. Select a color.
  6. Click OK or Apply.

The new properties are applied to the selected pivot table. To apply new table properties to a TableLook instead of just the selected table, edit the TableLook (Format menu, TableLooks).

To view hidden borders in a pivot table, from the View menu choose Gridlines.