Controlling table breaks for wide and long tables

Pivot tables that are either too wide or too long to print within the defined page size are automatically split and printed in multiple sections. You can:

  • Control the row and column locations where large tables are split.
  • Specify rows and columns that should be kept together when tables are split.
  • Rescale large tables to fit the defined page size.

To specify row and column breaks for printed pivot tables:

  1. Activate the pivot table.
  2. Click any cell in the column to the left of where you want to insert the break, or click any cell in the row before the row where you want to insert the break.

    Note: For legacy tables, you must click a column label or row label cell.

  3. From the menus, choose:

    Format > Breakpoints > Vertical Breakpoint

    or

    Format > Breakpoints > Horizontal Breakpoint

    Note: For legacy tables, choose Format > Break Here for both vertical and horizontal breakpoints.

To specify rows or columns to keep together:

  1. Select the labels of the rows or columns that you want to keep together. Click and drag or Shift+click to select multiple row or column labels.
  2. From the menus, choose:

    Format > Breakpoints > Keep Together

    Note: For legacy tables, choose Format > Keep Together.

To view breakpoints and keep together groups:

  1. From the menus, choose:

Format > Breakpoints > Display Breakpoints

Breakpoints are shown as vertical or horizontal lines. Keep together groups appear as grayed out rectangular regions that are enclosed by a darker border.

Note: Displaying breakpoints and keep together groups is not supported for legacy tables.

To clear breakpoints and keep together groups

To clear a breakpoint:

  1. Click any cell in the column to the left of a vertical breakpoint, or click any cell in the row above a horizontal breakpoint.

    Note: For legacy tables, you must click a column label or row label cell.

  2. From the menus, choose:

    Format > Breakpoints > Clear Breakpoint or Group

    Note: For legacy tables, choose Format > Remove Break Here.

    To clear a keep together group:

  3. Select the column or row labels that specify the group.
  4. From the menus, choose:

    Format > Breakpoints > Clear Breakpoint or Group

    Note: For legacy tables, choose Format > Remove Keep Together.

All breakpoints and keep together groups are automatically cleared when you pivot or reorder any row or column. This behavior does not apply to legacy tables.