Forum Discussion
Moving Page breaks
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
- Sturgis2256Mar 26, 2019Copper Contributor
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 !
- William MatschkeMar 11, 2018Copper Contributor
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
- Sturgis2256Mar 26, 2019Copper Contributor
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!
- Haytham AmairahMar 12, 2018Silver Contributor
Hi.
Sorry about that!
Anyway, I advise you to ask this https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel because it's the best place to get support.