Avoid automatic page break when printing

[fboehlandt]

Hi everyone,
I have a spreadsheet with 36 columns, which I would like to print. However, the used range contains very few rows. Due to the automatic page breaks, many pages are required to print the entire spreadsheet (leaving a lot of each page blank). Rather than enforcing a page break, I would like a line break (much like in word). To clarify, rather than printing the following:

(page 1)
col1 col2 col3 .. col 12

(page 2)
col13 col14 col 15...col24

(page 3)
col 25 col 26 col27...col36

I would like to have the following:

(page 1)
col1 col2 col3 .. col 12


col13 col14 col 15...col24


col 25 col 26 col27...col36

Is that possible? Many thanks in advance

 

[pgc01]

Hi Florian

You cannot do it directly.

The option is to use a new worksheet, or an empty range that you are not using, and compose the pages you want to print, either copying the data, using formulas to get the values you need or using pictures of the data.

 

[fboehlandt]

okay thanks, I thought so. Will get back to you when running into problems. cheers