We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

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

asked 2021-02-13 18:52:40 +0200

rama gravatar image

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?

edit retag flag offensive close merge delete


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:C9999and
  • Hide column B, so it doesn't get printed
Opaque gravatar imageOpaque ( 2021-02-14 00:44:25 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2021-02-14 15:49:51 +0200

LeroyG gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-02-13 18:52:40 +0200

Seen: 53 times

Last updated: Feb 14