Excel Pivot Tables Recipe Book: A Problem-Solution Approach

CHAPTER 11Printing a Pivot Table

One of the strengths of pivot tables is the ability to change the layout and analyze data from different perspectives. Sometimes, though, you want a static picture from the pivot table and need to print the data. For the most part, pivot tables print the same as other data on a worksheet, but there are a few special settings that you can apply to a pivot table.

Some printing issues, such as printing a copy of the pivot table for each item in the page field, can be solved by programming, and examples are given in Chapter 13.

11.1. Repeating Pivot Table Headings

Problem

Your pivot table spans several printed pages, and the page, row and column headings only print on the first page. You want the headings on every ...