Excel Insert Page Break (Table of Contents)
Excel Insert Page Break
Page Breaks in Excel is used to limit the length of the page to avoid misalignment of data while printing it. It happens when we are printing any Excel sheet; due to different size of Rows, data of any row may get split into 2 different pages. By this, we can get the complete data into one sheet and also, we can be selective in choosing which and how many columns a page can accommodate. Page Breaks is available in the View menu tab under Workbook View with the name of Page Break Preview. To insert a page break, select a row or column, then click on Insert Page Break from the Right-click menu list.
- There is an option in the page layout tab; under the page setup section, there is an option for breaks. Have a look at the screenshot below.
There are two options in Breaks:
- Insert Page Break
- Remove Page Break
Insert page break is to insert a new page break in any data while remove page breaks remove the break we gave already.
How to Insert Page Break in Excel?
To use page breaks, we need to perform the following steps:
- Select the first Row
- Click on Breaks in the page layout tab under the page setup section
- Check for print preview
Let us learn how to Insert a page break in excel with a few examples by following the above steps.
- Suppose we have the following data in our worksheet.
- We want both the set of tables printed separately. If we currently print the sheet, we can see that it prints the whole table together. Press the CTRL + P and check.
- To insert a page break, Select a row from where we want to begin a new page.
- Under the page layout section, in the page layout tab, click on Breaks; we have three options that popped up. Click on Insert Page Break.
- Here’s how our data looks like now.
4. Now check for print preview.
5. This is for the first page.
6. Click on the Second page to see the print preview.
7. The second data set is in the print preview.
- We have a second set of data to be printed, which is as below. We want the first set to be printed on the first page while the second set on another.
- First, we select the row from where we want to insert a page break.
- Now in the Page Layout Tab, under the page setup section, click on Breaks and click on Insert Page Break.
- Let us look at the Data First.
- Now we will check for the print preview and click the CTRL + P.
5. This is the first page, as we can see below.
6. Now click on the second page to view the second set of data.
7. We can see that in the print preview, our second set of data is printed.
- Now let us try with three sets of data. Have a look at the data below.
- Select the first row for the page break.
- In the Page Layout Tab, under the page setup section, click on Breaks.
- Now click on Insert Page Break.
- In the print preview, we can see that the first set is printed independently while the rest two are together.
- To Confirm, we can see below that it is page 1 of the print preview.
- Now, if we click on 2, we can see the second page of the print preview.
- The second preview looks like this.
- We want to break the rest two tables on different pages also. So we again select the first row for page break between the second and third tables.
- Now in the Page Layout Tab, under the page setup section, click on Breaks.
- Now click on Insert Page Break.
- Now, if we check for print preview, we can see that there are now three different pages.
- If we directly go on the third page, we can see that the third table is also being printed independently.
- Below is the screenshot for the print preview of the third data set.
Things to Remember about Excel Insert Page Break
- Always remember to select the first row before inserting any page break.
- Also, do not forget to check for a print preview to see if the page breaks are correct or not.
- We have already discussed why do we use page breaks in excel. It is because we want the data to be printed separately from one another.
- There is an option in the page layout tab; under the page setup section, there is an option for breaks.
This has been a guide to Excel Insert Page Break. Here we discussed how to use Excel Insert Page Break along with practical examples. You can also go through our other suggested articles to learn more –