Changing the PivotTable layout


show more Changing the PivotTable layout provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Changing the PivotTable layout

Excel PivotTables enable you to summarize your data in formats that are easy to read, and very helpfully, easy to modify. You can also change your PivotTable's layout, choosing whether to display blank rows below each item and selecting from three report layouts with subtle but important differences that are useful for you to know about. By default, Excel PivotTables have no blank rows after an item ends. In this PivotTable, there is a subtotal here for yearly sales in 2010, but there is no gap between the Summary of 2010, and the last month, December of 2009.

If you want to add a blank row there, you can click any cell in the PivotTable and then on the Design contextual tab click the Blank Rows button and then click Insert Blank Line after Each Item. When you do, Excel inserts the blank line. If you want to get rid of it, again on the Design tab click Blank Rows, and click the Remove Blank Line after Each Item button. As I mentioned before there are three report layout options that ...

Changing the PivotTable layout
Video duration: 3m 20s 3h 43m Intermediate

Viewers:

Changing the PivotTable layout provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...