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.