Changing the Default Table Formats

Figure 1. Viewer
Marital status table in Viewer

Although you can change the format of a table after it has been created, it may be more efficient to change the default TableLook so that you do not have to change the format every time you create a table.

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

Edit > Options...

  1. Click the Pivot Tables tab in the Options dialog box.
    Figure 2. Options dialog box
    Options dialog box with Pivot Tables tab selected
  2. Select the TableLook style that you want to use for all new tables.

    The Sample window on the right shows a preview of each TableLook.

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

All tables that you create after changing the default TableLook automatically conform to the new formatting rules.

Next