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

New Contributor

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?

1 Reply

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.




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?