How to Auto Format a Pivot Table in Excel 2007
Use Excel pivot tables to quickly summarize, filter and sort large quantities of data in your Excel workbook. Once the pivot table is created, use the auto-format styles to apply a color scheme to your pivot table.
The formatting styles are available on the Pivot Table tools tab. There are 85 different styles available to use. When you see a style you like, click on it to apply it to your pivot table.
Other People Are Reading
Instructions
-
-
1
Open Excel 2007 and select a workbook that contains data. Click the "Office" button and select "Open." Browse your computer files and select the workbook. Select the "Open" button. The Excel workbook will open.
-
2
Select all the data in your Excel worksheet by pressing "Ctrl" and "A" on your keyboard. Select the "Insert" tab and select "PivotTable." Select "PivotTable" again. The Create PivotTable dialog box will appear. Select the option for "Select a Table or Range." Select the placement option of "New Worksheet." Click "OK." A blank pivot table will appear.
-
-
3
Add fields to the pivot table by checking field names in the right "Pivot Table Field List." By default, the fields populate the "Row Labels." You can drag the fields from the "Row Labels" to the "Column Labels" by pivoting or dragging the fields in the right task pane. Drag your numerical fields in the "Sum Values" section.
-
4
Apply an auto-format style to your pivot table by clicking the "PivotTable Tools" tab. Click the "Design" tab. Locate the "PivotTable Styles" group. Preview the style by pointing to the style in the gallery. Notice that the style appears briefly on your pivot table. Apply the style to your pivot table by clicking on the style. The style will be applied immediately to your pivot table.
-
1
References
- Photo Credit number background image by kuhar from Fotolia.com
