How To Insert Page Break In Google Sheets

In this tutorial, you will learn how to insert page break in google sheets.

If you’ve ever tried to print from Google Sheets, you’ve likely run into trouble getting the printed document to look right. Unlike word processors, spreadsheets can be any width as well as any length, so often printed data comes out broken up between pages arbitrarily and becomes difficult to read. What’s more, Google Sheets has no menu option for adding page breaks, so it’s hard to see how to get that document printing correctly. Fortunately though, there is a hidden way to insert page breaks in Google Sheets. Just follow the steps below.

Step 1

Open the File menu and choose Print to access the Print Settings screen

Step 2

In the Print Settings sidebar, beneath the Margins section, click the blue text that says SET CUSTOM PAGE BREAKS

Step 3

The spreadsheet will display fullscreen, with blue dotted lines showing the default location of page breaks

Step 4

Hover over a page break to turn it into a handle you can drag and drop to adjust the page breaks as needed. You can edit both vertical and horizontal page breaks.

Step 5

Manually set page breaks will appear as solid blue lines instead of dotted. If you need to delete one, simply hover over it and click on the X that appears in the margin beside it

Step 6

To add more page breaks, drag the dotted lines from the edges of the document and new page breaks will be created

Step 7

Once you’re happy with the page breaks, click the Confirm Breaks button in the upper-right

Step 8

Back in the Print Settings screen, make any other desired changes, then click the Next button in the upper-right to proceed with printing the spreadsheet

Step 9

Your browser’s print dialog will open. Proceed with printing the spreadsheet and the printed document will have the manually set page breaks

Step 10

After setting the page breaks, they’ll remain set for that document so you only have to go through this process once unless the desired page breaks change

Summary

Quick Navigation

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to insert page break in google sheets. Want more? Check out all the Google Sheets Tutorials.