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.
Open the File menu and choose Print to access the Print Settings screen
In the Print Settings sidebar, beneath the Margins section, click the blue text that says SET CUSTOM PAGE BREAKS
The spreadsheet will display fullscreen, with blue dotted lines showing the default location of page breaks
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.
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
To add more page breaks, drag the dotted lines from the edges of the document and new page breaks will be created
Once you’re happy with the page breaks, click the Confirm Breaks button in the upper-right
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
Your browser’s print dialog will open. Proceed with printing the spreadsheet and the printed document will have the manually set page breaks
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
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.