Moving Page breaks

Copper Contributor

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 here.

 

Hope that helps!

Haytham

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

Hi.

 

Sorry about that!

Anyway, I advise you to ask this community because it's the best place to get support.

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 Matschke 

 

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-...

 

It's a bit hidden now but it's still there.  

Good luck!