Forum Discussion
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.
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_EekelenPlatinum Contributor
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.
- Thomas1020Copper Contributor
Thank you. The example shown in your post will be useful for future cases.
- Thomas1020Copper 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.