Print multiple Calc pages in one printer page

Have LibreOffice 25.8.3.2 on Windows 10
Have a Calc spreadsheet with 6-columns.
The columns are wide enough that all 6 will not print in one sheet.
Spreadsheet is set to print landscape and all margins are set to 0.4.
My issue is:
1) When I print the spreadsheet, the last column, #6, prints on a separate, second, page
2) When I set “File”, “Print”, “Page Layout”, “Pages per sheet” to “2”, the spreadsheet prints the first 5 columns on the top of the page and the 6th columns on the bottom half of the page.
3) Changing the “Order”, in #2 above, has no effect on the printing of the 6th column. It still, always, prints on the bottom half of the page
What I would like to accomplish is:
Print columns 1-5 and then, on the same page, adjacent to column #5, print column #6.
Even if it means that the overall font size is reduced.
In MS Excel I can accomplish this by going to: “Page Layout”, “Page Setup”, “Page”, “Fit to:”
I would prefer to NOT have to change the font in order to accomplish this.
It will work (which is how I was able to print all 6 columns on the same page) in this case.
However, in cases where there is more that one column to account for (e.g. 2 full pages) this can become very tedious.