How can I get two separate ranges printed on the same page?

I have defined a print range:


When I print these ranges show up on different pages. I want to fit them on one page and line them up so that I can read along the lines of the table from the first range to the second. How can I do this?

I want to fit them on one page

You want to fit 9999 rows on one page? I guess this is not what you want, but you want column A and column C on same page.

May be you want:

  • Print range: A1:C9999 and
  • Hide column B, so it doesn’t get printed

Choose menu Format - Page… - Sheet tab, for Scaling mode: (below Scale) select Fit print range(s) to width/height, unmark Height in pages:, and OK.

image description

Tested with LibreOffice (x86); OS: Windows 6.1.

Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.

Check the mark (Answer markCorrect answer mark) to the left of the answer that solves your question.