Forum Discussion
William Matschke
Mar 11, 2018Copper Contributor
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
Haytham Amairah
Mar 11, 2018Silver Contributor
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
Sturgis2256
Mar 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 !