Forum Discussion
Moving Page breaks
I cannot move page breaks with my mouse in this Office 365 version of Excel. Why?
I am using MS Excel for Mac, ver 16.9.
Thank you
5 Replies
Hello William,
You may have a manual defined print area in the worksheet!
If so, you cannot adjust page breaks.
To remove this print area go to File menu >> Print Area >> Clear Print Area.
Same problem https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_mac2016/page-breaks-in-excel-2016-for-mac/ee73dcb0-fa75-4faa-8074-cad700919830.
Hope that helps!
Haytham
I've also come up against this problem. It's changed since the old version where you could just drag them as required.
Defining the print area isn't really a great solution as the area to print might need to run to 3 pages whereas the automatic page breaks give you 16 !
I cleared my print area and also unfroze my panes. It is frustrating because I can see the horizontal and vertical dashed page breaks but cannot "grab" them with my mouse and move them.
Does anyone have other ideas?
Thanks much,
Bill
I just Googled it and came onto Microsoft support - see here:
https://support.office.com/en-ie/article/insert-move-or-delete-page-breaks-in-a-sheet-2b1b9307-8a2f-4618-a2ec-852f61a123df
It's a bit hidden now but it's still there.
Good luck!
