What is Page Break in Excel?

How to Insert a Page Break in Excel? (with Examples)

Example #1 – Create a Vertical Page break in Excel

Let us consider the below data set, as shown in the table below, to apply the page break to break the page vertically.

We must select any cell from row 1 where we want to place the page break. Here, we have chosen the C1 cell. But, first, go to the “Page Layout” menu and select the “Insert Page Break” option.

We can see a vertical line on your worksheet, as shown in the figure below, which indicates the page break we created.

Example #2 – Create a Horizontal Page break

Let us consider the same sales data to apply the page break.

Select any cell in column A or right below the row where we want to insert the page break.

We selected the A9 cell and applied the breaks in this example. Next, go to the “Page Layout” menu and select “Insert Page Break.”

The horizontal page break is inserted in the selected sales table. So, for example, we can check the horizontal page break in the below figure:

Example #3 – Move a Page Break

We can move the page break by using the below steps:

  • First, we must open the worksheet where we need to modify or move the page break. Next, click on “View” and “Page Break Preview.”

The “Page Break Preview” looks like as given below:

  • We can move it from the simple dragging options shown below.

Example #4 – Delete a Page Break

We can also remove the page break from the worksheet. The steps are as follows:

  • Select the row or column of the page break to delete. Select the “Page Layout” tab and click on “Breaks.” Select “Remove Page Break.”

  • It will delete the page break selected page break.

  • We can delete all page breaks by selecting the “Reset All Page Breaks” option, as shown in the below figure.

Things to Remember

  • It is a separator that breaks/divides an Excel worksheet into a separate page for printing.It is used to insert a page break in an Excel worksheet to specify where a new page will begin in the printed copy.

This article is a guide to Page Break in Excel. We discuss inserting, moving, or deleting a page break in Excel, practical examples, and a downloadable Excel template. You may learn more about Excel from the following articles: –

  • Break in VBABreak In VBABreak is used in VBA to stop executing a code after meeting the given criteria. Also, when the code encounters an error showing the incorrect value, we need our statement or code to break; VBA has an inbuilt statement for it, known as the EXIT statement.read morePage Setup in ExcelPage Setup In ExcelTo set up a page in MS excel, in the page layout tab, click on the small arrow mark under the page setup group> A dialogue box will open, click on “fit to 1 page” option>go to print preview option and choose landscape mode>save changes, it’s done.
  • read moreLine Breaks in ExcelLine Breaks In ExcelLine break in excel means inserting a new line in any cell value. To insert a line break, press ALT + Enter. As we insert a line break, the cell’s height also increases as it represents the data.read moreWeek Number in ExcelWeek Number In ExcelWeek Number (WEEKNUM) is an excel date function that returns the week number for a given date. It contains two arguments, one of which accepts a date as an argument, which can be any date, and the other is the day on which the week begins as an optional argument.read more