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

%3CLINGO-SUB%20id%3D%22lingo-sub-1433942%22%20slang%3D%22en-US%22%3EIn%20Excel%2C%20automatically%20have%20a%20list%20start%20on%20another%20column%20on%20the%20same%20page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433942%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20print%20a%26nbsp%3B4%20column%26nbsp%3Blist%20so%20it%20will%20snake%20over%20and%20continue%20to%20the%20right%20on%20the%20same%20page%20once%20the%20first%20four%20columns%26nbsp%3Bhave%20reached%20the%20bottom%20of%20the%20page.%26nbsp%3B%20How%20can%20I%20accomplish%20this%20in%20Excel%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1433942%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
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
Highlighted

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?