Set rows to display

By default, tables with many rows are displayed in sections of 100 rows. To control the number of rows displayed in a table:

1. Activate the table.
2. From the menus choose:

   Table Properties > General

3. Select Display table by rows.
4. Click Set Rows to Display.

   or

5. From the View menu of an activated pivot table, choose Display table by rows and Set Rows to Display.

Rows to display. Controls the maximum number of rows to display at one time. Navigation controls allow you move to different sections of the table. The minimum value is 10. The default is 100.

Widow/orphan tolerance. Controls the maximum number of rows of the inner most row dimension of the table to split across displayed views of the table. For example, if there are six categories in each group of the inner most row dimension, specifying a value of six would prevent any group from splitting across displayed views. This setting can cause the total number of rows in a displayed view to exceed the specified maximum number of rows to display.