Forum Discussion

Thomas1020's avatar
Thomas1020
Copper Contributor
Feb 10, 2020
Solved

Remove page break in Excel for Mac 365

A page break has become inserted at on page 6 of a 12 page file, without my intending it.  I want to remove it but have failed to do that.  I've gone online and tried the simple remedy described at https://support.office.com/en-us/article/insert-move-or-delete-page-breaks-in-a-sheet-2b1b9307-8a2f-4618-a2ec-852f61a123df.  That does not accord exactly with what I see in my installation of Excel.  My Page Setup "group" contains nothing about Break.

Rather, as shown in the two attached screenshots, there's a logo displayed with the word Break.  The drop-down menu gives the same three choices shown in the online illustration.  But when I click on "Remove Page Break" the break is not removed.  I suppose I need to select the break somehow, but I don't see how.  I expect the solution is simple and at hand, but I can't find it.  Thanks for guidance. 

  • Thomas1020 

    Select cell A173. From the top menu "Insert", select "Remove pagebreak"

    Alternatively, on the Page Layout ribbon, select Breaks and then Remove Page Brake as demonstrated in the picture below.

3 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    Thomas1020 

    Select cell A173. From the top menu "Insert", select "Remove pagebreak"

    Alternatively, on the Page Layout ribbon, select Breaks and then Remove Page Brake as demonstrated in the picture below.

  • Thomas1020's avatar
    Thomas1020
    Copper Contributor

    Thomas1020  I found the solution, which was directly in front of me, as shown in the attached file. I clicked on "Remove all Breaks" and it disappeared.  

Resources