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
5 Replies
Sort By
- Haytham AmairahSilver 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 here.
Hope that helps!
Haytham
- Sturgis2256Copper 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 MatschkeCopper 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
- Sturgis2256Copper Contributor
I just Googled it and came onto Microsoft support - see here:
It's a bit hidden now but it's still there.
Good luck!