Format a PivotTable report

1. Click the report.
2. On the PivotTable toolbar, click Format Report .
3. Do one of the following:

   To apply an indented format, click one of options Report 1 through Report 10. These options both apply formatting and move any column fields in your report to the row area.

   To apply a nonindented (crosstabulated) format, click one of options Table 1 through Table 10 or PivotTable Classic, the default format for new reports. Options Table 1 through Table 10 also move the leftmost row field to the column area.

Note  To restore the report to its previous layout, click Undo immediately after applying a new format.

1. Double-click the outer row field for which you want to reposition the subtotals.
2. If subtotals aren't turned on, click Automatic or Custom.
3. Click Layout, and then click Show items in outline form.
4. To display subtotals above the subtotaled items, select the Display subtotals at top of group check box.

   To display subtotals below the items, clear the check box.

1. Double-click the outer row field for which you want to add or remove blank rows between items.
2. Click Layout.
3. To add or remove the blank rows, select or clear the Insert blank line after each item check box.

Note  You can apply character and cell formatting to the blank rows, but you can't enter data in them.

1. Click the report.
2. On the PivotTable toolbar, click PivotTable, and then click Table Options.
3. To use merged cells for outer row and column items, select the Merge labels check box.

   To use regular cells, clear the check box.

1. Click a cell in the data area.
2. On the PivotTable toolbar, click Field Settings .
3. Click Number.
4. In the Category list, click the format category you want.
5. Select the options you want for the format, and then click OK twice.
6. If the report has more than one data field, repeat these steps for each one.

1. Click the report.
2. On the PivotTable toolbar, click PivotTable, and then click Table Options.
3. Do one or more of the following:

   Change error display    Select the For error values, show check box under Format options. In the box, type the value you want to display instead of errors. To display errors as blank cells, delete any characters in the box.

   Change empty cell display    Select the For empty cells, show check box. In the box, type the value you want to display in empty cells. To display blank cells, delete any characters in the box. To display zeros, clear the check box.

1. Make sure formatting will be preserved if you refresh the report or change its layout: click the report, click PivotTable on the PivotTable toolbar, click Table Options, and then select the Preserve formatting check box.
2. Select the part of the PivotTable report you want to format.

   If you want formatting applied to all such parts, so that when layout changes display parts not currently onscreen, those parts also have the formatting, click the (All) item in the dropdown lists for any page fields, and then make sure the mouse pointer changes to or before you click the part you're selecting.

3. To apply the formatting changes you want, use the buttons on the Formatting toolbar and the commands on the Format menu.

Note  Conditional formatting and cell borders aren't preserved when you refresh or change the layout.

1. Click PivotTable on the PivotTable toolbar.
2. Click Table Options.
3. Clear the AutoFormat table check box, and then click OK.
4. Click Format Report on the PivotTable toolbar.
5. Click the PivotTable Classic format.

1. Click PivotTable on the PivotTable toolbar.

2. Click Table Options.

3. Clear the AutoFormat table check box, and then click OK.

4. Click Format Report on the PivotTable toolbar.

5. Click the None format.