Chapter 3
Working with PivotTables
Section 4
PivotTable Design and Layout
Normal 0 false false false EN-IN X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-fareast-language:EN-US;} Your PivotTable is displaying the correct data, but is using the default style and options. We'll customize the table to match our desired look and feel. - Select a cell in your PivotTable, and click on Design, then on Grand Totals, and finally on Off for Rows and Columns to hide the Grand Total row - Right-click on your PivotTable, select PivotTable Options, and uncheck Autofit column widths on update to lock the size of your PivotTable columns - Select Design, then More, and then select New PivotTable Style to customize the exact look and feel of the PivotTable elements