how to insert page breaks printing in google sheets

Let’s say that we have the same data set and want to set similar page breaks after each month subtotal.ġ.

We can also insert custom page breaks in Google Sheets, but it’s a bit different compared to Excel. Now, all the page breaks are cleared and all data will be print on one page. First, go to the Page Layout tab in the Ribbon, then click on Breaks in the Page Setup group, and choose Reset All Page Breaks. We can also remove all page breaks at once. After that, go to the Page Layout tab in the Ribbon, then click on Breaks in the Page Setup group, and choose Remove Page Break.Īs a result, the first page break will be removed and we now have two pages for printing, instead of three.

In our case, we will select Row 11, as we want to delete the page break after Row 10.ģ. Select the row above the page break we want to delete. To remove a page break, first go to the View tab in the Ribbon, and click on Page Break Preview.Ģ. The page break is moved until the end of the table, and all data will be print on one page, as shown in the picture below.ġ. To do this, position the cursor on a page break line (between Rows 10 and 11) until the double arrow appears, and drag the arrow down to Row 27. For example, if we want to have just one page for all rows, we need to drag the first page break to Row 27. We can also adjust the page break by dragging it up or down. Here we can see all page breaks and enumerated pages for printing. To do this, go to the View tab in the Ribbon, and click on Page Break Preview. We can also display all page breaks in the sheet. Finally, we get two more page breaks between Rows 18 and 19, and Rows 25 and 26. Now repeat steps 1 and 2 for Rows 19 and 26. After that, go to the Page Layout tab in the Ribbon, then click on Breaks in the Page Setup group, and choose Insert Page Break.Īs a result, we get the page break line between Rows 10 and 11.ģ. In our case, we will select Row 11, since we want to insert a page break after Row 10.Ģ. First select the row right below where we want to insert a page break. To do this, insert page breaks after Jan-21 Total, Feb-21 Total, and Mar-21 Total.ġ. Let’s say that we want to print data for every month on a separate page. In this table, we have sales data with subtotals, grouped by month. Let’s look at the following example and see how to insert a page break. In Excel, we can choose when to go to the next page when printing by setting page breaks. In this tutorial, you will learn how to insert and remove page breaks in Excel and Google Sheets.

How to insert page breaks printing in google sheets