Formatting a PivotTable
After you create a PivotTable, you can use formatting tools on the Design tab under PivotTable Tools to modify the look and feel of a PivotTable. Formatting a PivotTable can be quick and easy with PivotTable Quick Styles. When you create a PivotTable, Excel displays a standard set of elements, including headings, columns, and rows. You can select or clear options on the Design tab to quickly format a PivotTable the way you want. Layout buttons, such as Subtotals, Grand Totals, Report Layout, and Blank Row, give you additional options to show or hide PivotTable elements.
Format a PivotTable Report
Click any field in the ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
