How to Format a Pivot Table

Format your PivotTable by using the PivotTable Tools tab on the ribbon.

PivotTables let you summarize large quantities of data in Microsoft Excel. Once the PivotTable is created, you can format it using the PivotTable Tools tab on the ribbon in Excel. Formatting consists of modifying the layout and style options in the PivotTable. Using these tools, you can customize the PivotTable to your style preference.

Instructions

1. Open Excel 2007 and open a workbook that contains a PivotTable. Select the "Office" button and select "Open." Search your computer and locate the workbook. Click on the workbook and select the "Open" button.

2. Select the worksheet that contains the PivotTable. Click on the summary value section of the PivotTable. Notice the PivotTable Field List appears on the right side of the Excel workbook and the PivotTable Tools tab appears on the ribbon. Click on the Options tab in the PivotTable Tools tab. Select the "Field Setting" button. Click the "Number Format" button and select a format from the category. Click "OK." Click "OK" again.

3. Click on the "Design" tab in the PivotTable Tools tab of the ribbon. Use the "Layout" group to modify the format of the subtotals, report layout and grand totals. The "PivotTable Styles" group modifies the column scheme of your PivotTables. You can emphasize or de-emphasize the column and row labels.

4. Add a color and style to the PivotTable using the "PivotTable Styles" group. Save the changes once you have completed the format modifications by clicking on the "Save" icon on the Quick Access Toolbar.

References

• Microsoft: Design the Layout and Format of a PivotTable Report