How to Insert a Page Break in Google Sheets (Step-by-Step)

Page breaks are essential for any document that you would like to get printed. If it was not for page breaks, your printer would not know where one page ends and the next begins – yes, technology is not that smart… yet!.

In this tutorial, I will show you how to add a page break in Google Sheets.

This can be done using the Custom Page Breaks option in your Google sheets document.

Page breaks will allow your Spreadsheet to maintain its formatting when you send it for printing. It is actually surprising that Google Sheets was missing this crucial feature for a long time!

However, Google finally remedied that misstep some time back. So, now, you can print out your Google Spreadsheet without worrying about any formatting issues.

So, without further ado, let us give you a step-by-step guide on how to add page breaks in your Google Sheets document.

This feature to insert page breaks was recently added in Google Sheets along with other interesting features – the grouping of rows and columns, Macros, and Tick Boxes – for its cloud-based spreadsheet app.

What is a Page Break and why is it Important in Google Sheets?

A page break is something that tells Google Sheets to break the page and print and the remaining part in the next sheet.

For example, suppose I have a dataset as shown below and I want to print this data.

Dataset that I want to Print

Since there are 13 columns in this dataset that occupies some space when I try and print this data, Google Sheets will print only the first 11 columns in a page and the rest two will be pushed to the next page.

I can edit the page breaks setting so that all the columns are printed as one single page.

Or, I can decide to only print half the columns on one page and the rest half are printed on the second page.

With the page breaks settings, you can easily do this.

Now, let us take you through how Google Sheets users would insert page breaks in their sheets before the addition of this feature.

Inserting Page Breaks in Google Sheets

Here are the steps that will allow you to insert a custom page break in your Google Sheets document:

  1. Go to the File option in the menuClick the File option in the menu
  2. Click on the Print option, or simply use the print shortcut (Ctrl+P). This will open the ‘Print Setting’ options.Click the Print option
  3. Once you have the print settings open in front of you, look for the blue text on the right side of your screen that says “SET CUSTOM PAGE BREAKS.”Click on Set Custom Page Breaks
  4. Once you click on that option, Google Sheets will show you a preview of what it thinks your page breaks should look like – it will do so in the form of blue, spotted lines on the entire page.
  5. Next, hover your mouse cursor over the default breaks. The spotted line you choose will jump alive and take the shape of a thick and dark line.Page break can be set using the blue line
  6. Click on that line and drag it to where you want your page break. After deciding on the place, simply release the line. You can place it anywhere on your page!
  7. Finally, Google Sheets will show you the option, “CONFIRM BREAKS”. Once you are done placing your page breaks, simply click on that blue button.Confirm Breaks blue button

That is it!

Your new, custom page break has been set.

This feature allows you to set multiple page breaks in your document on Google Sheets by dragging and dropping the default breaks.

Now that you have learned how to add a page break in your document on Google Sheets, it is time for you to learn how to edit or reset the added page break.

How to Reset Page Breaks in Your Document on Google Sheets

In case you’ve modified the page breaks and then not happy with the current setup, you can easily edit or reset the page breaks.

To reset the page breaks you added in your document on Google Sheets, follow the below steps:

  1. Go to the File menu option
  2. Click on the Print option, or simply use the print shortcut (Ctrl+P). This will open the ‘Print Setting’ options.
  3. In the pane on the right, click on the Edit option (which is to the right of ‘Custom page breaks’ option).Click on Custom Page Breaks Edits
  4. In the screen that opens, click on the RESET option to reset all of the Page Breaks you had previously added to your file.Click on the Reset Button to reset the page breaks

Another way to reset the line breaks is to go to hover the cursor over the blue line

Have you ever wondered about the significance of adding page breaks to your Google Sheet? Well, let us tell you why they are so crucial.

How Users Added Page Breaks in Google Sheets Back in the Old Days

Let’s say you had a fixed point in your sheet where you wanted a page break. There was only one way for you to have achieved that in the old days. You would have to insert a few empty rows to move the data that was typed in below that mark to the subsequent page.

It would work alright in terms of printing; however, it had a lot of risks when it came to data structuring and resultant formula errors.

However, now, you do not need to take this route anymore. Google has provided you with the option to add custom page breaks to your document on Google Sheets.

That is it! We hope this simple guide has taught you how to insert a page break in your Google Sheets.

You may also like the following Google Sheets Tutorials:

Leave a Comment