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. 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 post, you’ll learn how to Find Blank cells in excel so that you can remove or delete the blank cells form...
In this article, you’ll learn what is a Gauge Chart in Microsoft Excel. Also, you will learn how to add...
Microsoft Excel provides a shortcut for the users to move columns in excel using two different ways – using Shift...