Printing each item on its own page


show more Printing each item on its own page 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 ...

Printing each item on its own page

When you create a PivotTable, it's likely that you'll have data for many categories grouped together into a single display. If that's the case, it might make sense to print your data on a number of worksheets. There are two ways that you can separate your PivotTable data. The first is by using the fields in the Row Labels area and the second is by using fields in the Report Filter area. If your PivotTable has more than one field in the Row Labels area, you can have Excel print each group on a new page. For example, in this worksheet I have data from 2009 and 2010 and let's say that I want it to print 2009 and 2010 on separate worksheets.

To do that, you right-click any cell in the label field by which you want to separate. In other words I want to separate by year so I'll click one of my two year fields, in this case right clicking 2009, and in the shortcut menu that appears click Field Settings. In the Field Settings dialog box the setting that we're interested i...

Printing each item on its own page
Video duration: 3m 30s 3h 43m Intermediate

Viewers:

Printing each item on its own page 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 ...