User Guide

295
Pivot Tables
E
From the menus choose:
Format
Table Properties...
E
On the Printing tab, select Print all layers.
You can also print each layer of a pivot table on a separate page.
Controlling Table Breaks for Wide and Long Tables
Pivot tables that are either too wide or too long to print within the defined page size
are automatically split and printed in multiple sections. (For wide tables, multiple
sections wi
ll print on the same page if there is room.) You can:
 Control th
e row and column locations where large tables are split.
 Specify ro
ws and columns that should be kept together when tables are split.
 Rescale la
rge tables to fit the defined page size.
To Specify Row and Column Bre aks for Printed Pivot Tables
E Activate the pivot table.
E Click the column label to the left of where you want to insert the break or click the
row label a
bove where you want to insert the break.
E From the m
enus choose:
Format
Break Here
To Specify
Rows or Columns to Keep Together
E Activate
the pivot table.
E Select th
e labels of the rows or columns you want to keep together. (Click and drag
or Shift-click to select multiple row or column labels.)