Forum Discussion
In Excel, automatically have a list start on another column on the same page
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 Ex...
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?