10

I want to force a page break after a certain row of a sheet. Is there some analogue of Google Docs’ (and Excel’s) “insert page break” for Spreadsheets?

If there is no “native” way to do this, maybe there is some hack (using functions / add ons / whatever)?

4
  1. Open a spreadsheet at sheets.google.com.
  2. At the top, click File > Print.
  3. Click Set custom page breaks.
  4. Drag the lines to where the page should break (each rectangle will print on its own page).

    enter image description here

  5. When you’re done, click Confirm breaks.

Source: https://support.google.com/docs/answer/7663148

3

Sorry, but such appears not to exist in 'native' sheets. There are, understandably, complaints about this (example). I have had a look through Add-ons and see nothing promising there that might help.

1

You could also split your data up into different sheets (tabs on the bottom) then print all sheets. Not ideal, but it works for simple spreadsheets.

0

Grunt method -

Add rows to bottom of first page (make row height larger if you need a lot of fill space)

Fill empty rows with white background and remove any lines and/or boxes

Click print - jiggle around until you get what you want

  • In the print dialog there's a setting to remove grid lines, so you don't need to worry about manually hiding them all. – LoganGoesPlaces Jul 7 '16 at 18:00
0

I have found the best way to print "each sheet" is to freeze the header. Select the rows you want to print. Print. under the print options make sure to select the print selected frames and print the first row. It is just about the same amount of work for a page break.

0

Just drag from the top of the sheet.

There are thick grey lines in the blank square on the top left of the sheet. You can drag these lines and create a page break. If you are making boxes bigger when you are dragging, you are dragging the wrong grey line. Find the thickest line in the header of the sheet.

  • For me at least that is changing the rows that are frozen at the top of the sheet, not creating page breaks – harmic Sep 7 '17 at 5:44
0

There are no page breaks, but..

  1. Select the bit you want to print
  2. Copy
  3. File -> New -> Document
  4. Paste in the document
  5. Squiggle around until it's pretty
0

Ctrl + p (for print page), then you'll see a button for "Custom Page Breaks". Slide it to green. Then slide the page break lines to where you want them to be when you print.

0

I found the first answer correct but easier to understand when adding the following details. On a desktop, add the google drive app, then log into “google drive” - still on a desktop, open your sheets project ( it will be here even if you had been working on a tablet since “drive” manages all the google docs, sheets, & slides suite of apps ) then select print ....make sure to select the google print feature ( not air print ) If you don’t have a printer set up on google print, it’s easy. A printer just needs to be on your WiFi network. It will walk you thru the printer setup after you select print. ( again, don’t select air print ) so having completed all these steps the print feature offered me page breaks as a option. I was not able to add page breaks using just the sheets app on my iPad Pro and hitting print. ( but the instructions didn’t say stay in the sheets app ) I hope this helps someone else as I was very frustrated trying to accomplish this without trashing most of a project.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.