Special Edition Using Microsoft® Office XP

Formatting and Printing PivotTables

When you first create a PivotTable, it picks up the generic look of a default worksheet, with plain 10-point Arial formatting for details and headings alike. To make your PivotTable more compelling, use Excel's formatting features to add emphasis to text and backgrounds or shading to cells, rows, and columns. You can also adjust the number format of data items.

→ For an overview of Excel's many formatting options, see Chapter 22, "Advanced Worksheet Formatting".

You can format numbers and text in the data area of a PivotTable by selecting cells individually and choosing formatting options as you would in a normal worksheet. However, if you redefine your PivotTable later, you will lose this formatting. That ...