Printing pivot tables

Several factors can affect the way that printed pivot tables look, and these factors can be controlled by changing pivot table attributes.

  • For multidimensional pivot tables (tables with layers), you can either print all layers or print only the top (visible) layer. See the topic Table properties: printing for more information.
  • For long or wide pivot tables, you can automatically resize the table to fit the page or control the location of table breaks and page breaks. See the topic Table properties: printing for more information.
  • For tables that are too wide or too long for a single page, you can control the location of table breaks between pages.

Use Print Preview on the File menu to see how printed pivot tables will look.