Page Break in Microsoft Excel

In this post, you’ll get to know about what are page breaks and how to insert them in a worksheet.

Page breaks are breaks that indicate the division of a worksheet into pages. Page break by default depends upon the Print settings you have set or the Page layout of your worksheet. However, you can also manually set your Page breaks in Excel.

How to insert a Page break in a worksheet?

Firstly there are two types of page breaks i.e, vertical and horizontal.

  • To insert a vertical page break, select the row beside i.e, to the left of which you want to insert it.
Page Break in Excel
  • Similarly to insert a horizontal page break select the row above which you want to insert the page break.
Page Break in Excel
  • After selecting either a row or a column. Go to the Page Layout tab under the Page setup group select the Breaks option and click on Insert Page Breaks
Page Break in Excel
Page Break in Excel

Now you can see that the page break has been inserted.

    1 Comment

  1. User Avatar
    April 14, 2023
    Reply

    Well, the content was very informative.

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021