Editing Tables

Unless you've taken the time to create a custom TableLook, pivot tables are created with standard formatting. You can change the formatting of any text within a table. Formats that you can change include font name, font size, font style (bold or italic), and color.

  1. Double-click the Level of education table.
  2. If the Formatting toolbar is not visible, from the menus choose:

    View > Toolbar

  3. Click the title text, Level of education.
  4. From the drop-down list of font sizes on the toolbar, choose 12.
  5. To change the color of the title text, click the text color tool and choose a new color.
    Figure 1. Reformatted title text in the pivot table
    The font size control on the toolbar is set to 12 and the font color has been changed to red.

    You can also edit the contents of tables and labels. For example, you can change the title of this table.

  6. Double-click the title.
  7. Type Education Level for the new label.

Note: If you change the values in a table, totals and other statistics are not recalculated.

Next