Ask Your Question

Printing CALC with multiple page breaks

asked 2017-11-08 14:36:39 +0100

RahulLibOFF gravatar image

updated 2017-11-08 14:37:39 +0100

Hi All .. I have a school result sheet for all the students with multiple page break.

Can someone help me in figuring our How to print this full markshet in one go ?

Sample copy I am attaching. Please ignore the data in it.

edit retag flag offensive close merge delete


I can't find your mentioned sample copy, 8 mins. after you had updated.

Grantler gravatar imageGrantler ( 2017-11-08 14:47:18 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-06-01 15:28:49 +0100

hjek gravatar image

Click on a cell below (if it's a row break) or to the right (if it's a column break) of the page break, then click Sheet -> Delete page break. Do that to all the page breaks.

To make the entire spread sheet fit on one piece of paper (if that is what you're trying to do), it may also be necessary to change the Scale in Page Style.

edit flag offensive delete link more


Please see the file at this link - link text I want to print all the pages without giving page breaks manually.

RahulLibOFF gravatar imageRahulLibOFF ( 2018-06-04 13:54:47 +0100 )edit

@RahuiLibOFF In the spreadsheet you have linked to, there are a lot of manual page breaks. So, if you want to print the whole sheet without any manual page breaks, you will have to remove those manual page breaks.

The first page break in the file you linked to is at row 59. Try selecting row 59 and delete the page break as I explained in my previous answer.

If this is not what you meant, I'd encourage you to be more specific in what you are trying to do.

hjek gravatar imagehjek ( 2018-06-04 14:36:29 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-11-08 14:36:39 +0100

Seen: 52 times

Last updated: Jun 01 '18