Comments on: How to insert and remove page breaks in Excel

The Excel page break option helps you see where page breaks will appear when your worksheet is printed. In this article I'll show you several ways to insert them manually or by condition. You'll also learn how to remove page breaks in Excel 2016 - 2010, where to find the Page Break Preview, hide and show the marking lines. Continue reading →

Comments page 2. Total comments: 35

  1. i trying to insert page break and not working

    i right clicked liner where i wanted tab and then went to page layout and hit insert page break and did not work

    what am i doing wrong?

  2. how to make same page break as one of above page in excel 2013 ?

    1. Hello, Sohail,

      Could you please give more details about your task. I will do my best to help.

  3. I know how to remove/add page breaks, however, for some reason I cannot move mine on one of my spread sheets. It is usually as easy as drag and drop, but does not seem to work on one particular sheet. Any ideas?

  4. yeah, these instructions are pretty much what I tried before searching for help. but no "remove page break" option offered when I right click

    1. Go to Page layout tab then

      Scale to fit Option

      Width 1 Page

      Height 1 Page
      (It Choose all in page one)

      Thank You

      1. This is what I was looking for. Thanks!

        1. The Option worked! Thanks!

    2. Hello, Marisa,

      Please try the following:
      Select the worksheet that you want to modify.
      On the View tab, in the Workbook Views group, click Page Break Preview. ...
      Do one of the following: ...
      On the Page Layout tab, in the Page Setup group, click Breaks.
      Click Remove Page Break.

  5. Hi am sorry I followed everything in your instruction. But I cant removed the page break in my work book.
    There is anyway that I can removed the page break?

    Thank,

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)