How to Insert Page Break in Google Sheets [Complete Guide]

How to Insert Page Break in Google Sheets 21

The fastest way to insert page break in Google Sheets: Click “File” in the menu > Select “Print” > In the print settings, choose “Set custom Page breaks” > Adjust the blue lines to set your page breaks > Click “Confirm breaks” to confirm your settings > Choose your page breaks when printing by selecting “Fit to page breaks” in the scaling options > Click “Next” to print.

Another way to remove page break in Google Sheets: Click “File” and choose “Print” > Click the “Edit” button in the print settings > Reset the blue guidelines by clicking the “Reset” button > Confirm your changes by clicking “Confirm” > Your page breaks are removed.

Today we will learn how to insert page break in Google Sheets. Page break is a function that indicates where the page ends. It is essential when you send your document for printing. It tells the printer where to end the current page and push the remaining part to the next page. Without adding a page break, the printer will not know the beginning and end of your pages. Thus, it allows your spreadsheet to maintain its formatting when you take it for printing.

So, we brought you up with this helpful guide which will help you to learn how to insert a page break in Google Sheets. There is no hard and fast rule to apply page breaks in Google Sheets. In this article, we have explained through a step-by-step procedure by which it becomes easy to understand and you will be able to add page breaks in your Google Sheets too. So, continue to read this article to acquire this useful skill by learning how to insert page break in Google Sheets.

Importance of using Page Break in Google Sheets

When we print spreadsheet documents, it often happens that our printed data comes out broken up between pages randomly which is difficult or impossible to read. So, this article is for those who are getting troubled to have a correctly printed document. As Google Sheets doesn’t show the page lines by default but we can edit page break settings to print your document as you want. Once you learn and adapt this skill, you will not need to worry anymore about formatting issues for your future spreadsheets while sending them for printing. If you want, you can edit to reset and modify your page break settings anytime.

You will be surprised to know that Google Sheets lacked this feature for a long time, and it was much more difficult to deal with without it. Thankfully, they have now included page breaks in Google Sheets which makes our work very easy and interesting. This article contains a complete procedure that tells you how to insert page break in Google Sheets most easily. I hope this article will meet your expectations. So, what you are waiting for, let’s dive in to learn how to insert page break in Google Sheets.

See also  How to Stop Rounding Numbers in Google Sheets (2 Methods)

How to Insert Page Break in Google Sheets

Insert page breaks in Google are different as compared to other document applications. As other applications have individual buttons to insert page breaks but in google sheets, there is a short procedure of a few clicks to insert a page break. But the advantage of this functionality of the page break feature of Google sheets is customs break. You can break a page with your desire wherever you want to break. The procedure for page breaks in Google sheets is quite simple but this option of page breaks is found in the Print setup of Google sheets. So, to insert a page break you will have to go into the print settings of Google sheets. Study the following steps which lead you to how to insert a page break in Google sheets.

Step 1

Let’s suppose you are working with your spreadsheet on a big data set as shown in the following picture.

How to Insert Page Break in Google Sheets 1

Step 2

To insert a page break in Google sheets, go into the “File” tab in the menu bar of Google sheets.

How to Insert Page Break in Google Sheets 2

Step 3

A drop-down menu will open where you will find the “Print” button at the bottom of the menu.

How to Insert Page Break in Google Sheets 3

Step 4

A print setting pane menu will open and appear on the right side of the screen of google sheets.

How to Insert Page Break in Google Sheets 4

Note: You can also open the print settings pane menu with the help of a shortcut key Ctrl + P.

Step 5

In this pane menu, you will find an option of “Sets custom Page breaks“. Click on it to insert a page break in Google sheets.

How to Insert Page Break in Google Sheets 5

Step 6

When you click on the option “Sets custom Page breaks” a preview will open with blue guidelines around the data set as you can see in the following picture.
How to Insert Page Break in Google Sheets 6

Step 7

Now to break the page there is a blue guideline horizontally and vertically which can be moved by cursor up and down where you want to insert the page break.

How to Insert Page Break in Google Sheets 7

Step 8

As we did horizontally, similarly you can break the page vertically as there is a vertical blue guideline also present. Just place the cursor on the blue guide and then move it by pressing.

How to Insert Page Break in Google Sheets 8

Step 9

Once you have set the blue guidelines and are done with page breaks then click on the “Confirm breaks” button at the right top of the window to confirm page breaks.

How to Insert Page Break in Google Sheets 9

Step 10

You are almost done as you click on the confirm breaks button. The page will break instantly in the edges you selected. As you can see the results are below.

How to Insert Page Break in Google Sheets 10

Step 11

One thing you need to know after breaking the page is that if you are printing the broken page, first you will have to select it from the following menu. In the print pane menu, there is a scale option as you can see in the following picture.

How to Insert Page Break in Google Sheets 11

Step 12

When you click on it, there are various scaling options in which you will find the “Fit to page breaks” option as well. Click on it to print your break page in Google sheets.

How to Insert Page Break in Google Sheets 12

Step 13

As you can see below, the scale option has been selected to “Fit page breaks“, and now you are ready to print.

How to Insert Page Break in Google Sheets 13

Step 14

Once you are done with this, now just next button to print your break page.

How to Insert Page Break in Google Sheets 14

See also  How to Flip or Reverse Data Order in Google Sheets (Complete Guide)

How to Reset Page Break in Google Sheets

All tasks or functions in Google Sheets can be easily reset. Most of the functions and formulas in Google sheets are toggled. Similarly, you can also rest the changing which you have made while inserting the page break in Google sheets. There are some following steps are described below to remove the page break in Google sheets.

Step 1

Once you have inserted the page break and want to remove it then again you will have to go back into the print setting. To open print settings again go into the “File” tab in the menu bar of Google sheets where you will find the “Print” option click on it.

How to Insert Page Break in Google Sheets 15

Step 2

When you click on the “Print” option, the Print settings pane menu will open on the right side of the window, where you will find the custom page breaks option already open. But there will be an edit button as mentioned below, click on it to edit.

How to Insert Page Break in Google Sheets 16

Step 3

These blue guidelines are showing your previously applied page breaks. If you want to make changes in any of them then simply you can hover the cursor and can move these blue guidelines.

How to Insert Page Break in Google Sheets 17

Step 4

But if you want to remove those page breaks there is a “Reset” at the top of the print preview, which you can see in the following picture. Click on it, this button will reset your page breaks in its original condition.

How to Insert Page Break in Google Sheets 18

Step 5

As you can see the blue guidelines, turns to return to their original position, now just press the “Confirm” button to remove the page breaks.

How to Insert Page Break in Google Sheets 19

Step 6

As you can see from the results below, your document has been turned into its original condition, as it was before the page break.

How to Insert Page Break in Google Sheets 20

See also  How to Use Google Sheets Conditional Formatting Multiple Columns

Frequently Asked Questions

Is the Process of Moving Pages in Google Docs Similar to Inserting Page Breaks in Google Sheets?

The process to move a page in Google Docs is not similar to inserting page breaks in Google Sheets. In Google Docs, you cannot physically move pages like you can in Sheets, but you can change the location of content within the document. However, when it comes to page breaks, both Docs and Sheets provide options to control the flow of content.

Can I Split the Page in Half Horizontally in Google Docs?

Yes, it is possible to achieve dividing pages in half horizontally in Google Docs. By adjusting the page layout and using tables or drawing tools, you can create a horizontal line that divides the page into two equal halves.

When should we use page breaks in google sheets?

Page break often needs when you are working with a big data set in your spreadsheet. As big data or table that is overflowing to the page size. This may cause the misprinting of your documents that’s why we usually use page breaks in that condition so that our document can be printed correctly. You can see in the following picture, how our data is extended with the default A4 paper size, here we need to insert page breaks. Sometimes after a while of working, you start a new set of data, so before starting the new set of data it is better to insert the page breaks so it will not divide into the middle of the page.

How to Insert Page Break in Google Sheets 21

Is a section break the same as a page break?

No! page breaks and section breaks are two different things. A page break simply pushes any information after that page break onto the next page; a section break essentially splits your document into different parts to allow you to apply complex formatting to your document. Section breaks enable you to split a document into several sections, enabling you to apply different formatting and layouts to each section while page breaks lift you to the next page where you insert age breaks.

Conclusion

Today we learned how to insert page break in Google Sheets. Some Google Sheets users put empty rows in their data set while printing as they find it difficult to print their data on one page, so they add empty rows to split the data or page as in old days it used to be done. This way of page breaking is alright, but it may cause errors and risks while structuring the data. Therefore, I have brought to, especially those people who are unaware of this feature option of google sheets “Customs page breaks“.

Hope after reading the above article on how to insert a page break in google sheets, you will not use such type of risky methods follow the above steps to insert page breaks in your spreadsheets. Wish you all the best.

Content Protection by DMCA.com

M. Shaiq Ansari

Hi, I am Shaiq, I am a highly skilled technical writer working full-time for Office Demy. I am specialized in Google Workspace and Microsoft Office applications. With a background in Software Engineering, I possess a deep understanding of the intricate functionalities and features of these productivity tools. Connect me on Linkedin https://www.linkedin.com/in/shaiq-ansari/

OfficeDemy.com - Free Tutorials for Microsoft Office & Google Workspace
Logo
Enable registration in settings - general