Microsoft® Office Excel 2003 Inside Out

Printing PivotTables

Excel includes some special features to assist with the printing of PivotTables. Each of these features assumes that the PivotTable to be printed is the only one on the current worksheet. If you have more than one PivotTable on the current sheet, be sure to set the PivotTable you want to print as a print area before you print.

Cross Reference

For information about setting a print area, see "Defining a Default Print Area".

Using Row and Column Headings as Print Titles

Print titles are cell contents that appear at the top or left edge of each printed page (see "Specifying Rows and Columns to Print on Every Page". You can make a multipage PivotTable printout much easier to read and understand by setting your row and column field ...