print small and long table on the same page

[basb87]

Hi all, I have this spreadsheet with a table of 366 rows. It only has 2 columns. If I print this it takes 8 pages. But I would like to print it in such a way that the table is printed only on 2 pages. So to print it next to each other until the page is full. Please see my screenshots for a visualization. Is this possible via regular settings, or should I manually do this (maybe with a vba script)? thanks in advance, Bas

 

[BSALV]

hello,
the easiest way is (with formulas or VBA) making a copy of your 366*2 into 92 * 11 and printing that.