How to limit a pivot table to show only centain number of rows

The main list

The main list:

The Form to Print

The form to print:

21.7k 6 6 gold badges 57 57 silver badges 78 78 bronze badges asked Sep 6, 2016 at 7:09 Solarinoos Solarinoos 365 5 5 silver badges 13 13 bronze badges

1 Answer 1

To your 1st question, no it's not possible to split the result over several PivotTable.

Each page contain only one employee > you can automatically add a page break for each person so:

  1. Right-click the Person label in the PivotTable, and then click Field Settings.
  2. In the Field Settings dialog box, on the Layout & Print tab, add a check mark to Insert Page Break After Each Item.

Since you want to begin on each page at the same place, I would print the column headers on each page:

  1. Right-click on the PivotTable and open the Options dialog box
  2. On the Print tab, add a check mark to Set print titles

If you want to print only 10 rows per page, then I would change the margins under page layout in order to reduce the height available per page. So you force to have a page break all 10 rows.