Click any field in the PivotTable report.
Click the Design tab under PivotTable Tools.
Click the More list arrow under PivotTable Styles and then click the PivotTable style.
![Click any field in the PivotTable report. Click the Design tab under PivotTable Tools. Click the More list arrow under PivotTable Styles and then click the PivotTable style.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Format_Pivottable_Report___Click_Any_Field_In_Pivottable_Repor.PNG)
Select or clear the PivotTable format options:
Row Headers, Column Headers, Banded Rows, Banded Columns.
![Select or clear the PivotTable format options: Row Headers, Column Headers, Banded Rows, Banded Columns.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Format_Pivottable_Report___Select_Or_Clear_Pivottable_Format_O.PNG)
Select Subtotals to show or hide subtotals.
![Select Subtotals to show or hide subtotals.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Format_Pivottable_Report___Select_Subtotals_To_Show_Or_Hide_Su.PNG)
Select Grand Totals to turn on or off grand totals for columns or rows.
![Select Grand Totals to turn on or off grand totals for columns or rows.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Format_Pivottable_Report___Select_Grand_Totals_To_Turn_On_Or_O.PNG)
Select Report Layout to set to compact, outline, or tabular form.
![Select Report Layout to set to compact, outline, or tabular form.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Format_Pivottable_Report___Select_Report_Layout_To_Set_To_Comp.PNG)
Select Blank Row to insert or remove a blank line after each item.
![Select Blank Row to insert or remove a blank line after each item.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Format_Pivottable_Report___Select_Blank_Row_To_Insert_Or_Remov.PNG)