Although you can change the formatting of a table after it has been generated, it may be more economical to change the default TableLook so that your tables are created according to your needs, without the overhead of changing formatting every time.

To change the default TableLook style for your pivot tables, from the menus choose:

Edit
Options

Click the Pivot Tables tab of the Options dialog box.

Select the TableLook style you want to use for all new tables.

Use the preview to view a thumbnail of each TableLook.

Click OK to save your settings and close the dialog box.

Any tables you create after changing the default TableLook automatically conform to your new formatting rules.