O'Reilly logo

Excel Pivot Tables Recipe Book: A Problem-Solution Approach by Debra Dalgleish

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required