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

rama · February 13, 2021, 5:52pm

I have defined a print range:

A1:A9999;C1:C9999

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?

anon73440385 · February 13, 2021, 11:44pm

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

LeroyG · February 14, 2021, 2:49pm

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 6.4.7.2 (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 ( → ) to the left of the answer that solves your question.