Copying two rows from numbers to pages for printing

I have a table 950 rows long that I want to copy two of the columns to pages for printing ( as I cannot seem to be able to just print two columns in numbers).

That seems to be fine except when I paste (using 'paste formula results), I only see these columns on page 1. When the columns move onto page 2 and beyond there is just a blank space. That said the ruler of the two column table is visible, just not the cells.

How do I see the columns on page 2 and beyond?