In practice, there are situations when tables are longer than the sheet.
Scaling the table might be a solution to fit the table on the sheet. However, the result might contain text that is difficult to read, due to the small size of the characters. Breaking the table could be a more suitable solution.
Use the triangular grip point or the Properties palette to break a table into main and secondary table parts.
Further options in the Properties palette let you:
To break a table using grip points:
The table rows appear on the right. The distance defined by moving the grip point is the new size of the table. As you add new rows to the table, once the table reaches the defined height, overflows on the next table.
Alternatively, you can break the table using the Properties palette: in Table Breaks, select Yes.
To display column labels on secondary tables:
Note: If column labels are on the last line of the table, select Yes for Repeat bottom labels.