In Excel, automatically have a list start on another column on the same page

[Lisa LaCombe]

I am trying to print a 4 column list so it will snake over and continue to the right on the same page once the first four columns have reached the bottom of the page.  How can I accomplish this in Excel?

[#2]

Hi @Lisa LaCombe 

Click on View > Page layout and see what the row number of the last printed row on page 1 is. In my system it is row 50, so I would want the next column to copy row 51.

I can use that number in a formula like this in the next column.

=INDEX(A:A,ROW()+50)

Copy this column to the right three times.

Four columns further to the right, I can then use 100, i.e. add another 50 to the row index.

Does that make sense?