In this article:

How to Insert a Page Break in Google Sheets (2024 Update)

May 8, 2024

Google Sheet Page Break

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.

How to Insert a Page Break in Google Sheets

Follow the steps below to insert a page break in Google Sheets. 

1. Click on the Row or Column Where You Want the Page Break

Click on the row number or column letter directly after where you want the page break. This action selects the entire row or column.

google sheets page break

2. Navigate to 'File' > 'Print' to Open Print Settings

Navigate to "File" in the top menu, then select "Print" from the drop-down menu to open the print settings.

page break in google sheets

3. Activate 'Set Custom Page Breaks' Mode in 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.

insert page break in google sheets

4. Create or Adjust Page Breaks by Dragging Blue Dotted Lines

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.

how to insert page break in google sheets

5. Save Changes by Clicking 'OK' or 'Done' in Print Settings

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. 

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->