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.