In Google Sheets, page breaks serve as dividers that dictate the start of a new page in printed documents. Users can insert, move, or delete these breaks to organize their spreadsheets effectively for printing. This feature ensures that related data remains together which facilitates the creation of professional-looking reports and invoices.
Follow the steps below to insert a page break in Google Sheets.
Click on the row number or column letter directly after where you want the page break. This action selects the entire row or column.
Navigate to "File" in the top menu, then select "Print" from the drop-down menu to open the print settings.
In the print settings sidebar, find and click on "Set custom page breaks." This puts you in a mode where you can adjust page breaks manually.
You'll see blue dotted lines that represent the current page breaks. Click and drag these lines to create a new page break where you need it, either above the selected row or to the left of the selected column.
After setting the page breaks as needed, click "Confirm Breaks" to save the changes and exit the print settings.
We hope that you now have a better understanding of how to insert a page break in Google Sheets. If you enjoyed this article, you might also like our article on how to use the quartile formula in Google Sheets.
If you want to get a copy of our Google Sheets inventory template, we also suggest checking out our detailed guide.
