User Guide

284
Chapter 11
To Display Hi
dden Borders in a Pivot Table
For tables w
ithout many visible borders, you can display the hidden borders. This can
make tasks like changing column widths easier. The hidden borders (gridlines) are
displayed in the Viewer but are not printed.
E Activate the pivot table (double-click anywhere in the table).
E From the menus choose:
View
Gridlines
Table P roperties: Printing
You can control the following properties for printed pivot tables:
 Print all layers or only the top layer of the table, and print each layer on a separate
page. (This affects only printing, not the display of layers in the Viewer.)
 Shrink a table horizontally or vertically to fit the page for printing.
 Control widow/orphan lines—the minimum number of rows and columns that
will be con
tained in any printed section of a table if the table is too wide and/or
too long for the defined page size. (Note: If a table is too long to fit on the
remainder of the current page because there is other output above it on the page
but fits w
ithin the defined page length, it is automatically printed on a new page,
regardless of the widow/orphan setting.)
 Include continuation text for tables that don’t fit on a single page. You can display
continuation text at the bottom of each page and at the top of each page. If neither
option is
selected, the continuation text will not be displayed.
To Control Pivot Table Printing
E Click the Printing tab.
E Select the printing options you want.
E Click OK or Apply.