Home

Moving Page breaks

%3CLINGO-SUB%20id%3D%22lingo-sub-170262%22%20slang%3D%22en-US%22%3EMoving%20Page%20breaks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-170262%22%20slang%3D%22en-US%22%3E%3CP%3EI%20cannot%20move%20page%20breaks%20with%20my%20mouse%20in%20this%20Office%20365%20version%20of%20Excel.%20Why%3F%3C%2FP%3E%0A%3CP%3EI%20am%20using%20MS%20Excel%20for%20Mac%2C%20ver%2016.9.%3C%2FP%3E%0A%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-170262%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-388974%22%20slang%3D%22en-US%22%3ERe%3A%20Moving%20Page%20breaks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388974%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127053%22%20target%3D%22_blank%22%3E%40William%20Matschke%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20Googled%20it%20and%20came%20onto%20Microsoft%20support%20-%20see%20here%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-ie%2Farticle%2Finsert-move-or-delete-page-breaks-in-a-sheet-2b1b9307-8a2f-4618-a2ec-852f61a123df%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-ie%2Farticle%2Finsert-move-or-delete-page-breaks-in-a-sheet-2b1b9307-8a2f-4618-a2ec-852f61a123df%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20a%20bit%20hidden%20now%20but%20it's%20still%20there.%20%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20luck!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-388964%22%20slang%3D%22en-US%22%3ERe%3A%20Moving%20Page%20breaks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388964%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20also%20come%20up%20against%20this%20problem.%20%26nbsp%3BIt's%20changed%20since%20the%20old%20version%20where%20you%20could%20just%20drag%20them%20as%20required.%3C%2FP%3E%3CP%3EDefining%20the%20print%20area%20isn't%20really%20a%20great%20solution%20as%20the%20area%20to%20print%20might%20need%20to%20run%20to%203%20pages%20whereas%20the%20automatic%20page%20breaks%20give%20you%2016%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-170331%22%20slang%3D%22en-US%22%3ERe%3A%20Moving%20Page%20breaks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-170331%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ESorry%20about%20that!%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAnyway%3CSPAN%3E%2C%20I%20advise%20you%20to%20ask%20this%20%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fmsoffice_excel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ecommunity%3C%2FA%3E%20because%20it's%20the%20best%20place%20to%20get%20support.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-170282%22%20slang%3D%22en-US%22%3ERe%3A%20Moving%20Page%20breaks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-170282%22%20slang%3D%22en-US%22%3E%3CP%3EI%20cleared%20my%20print%20area%20and%20also%20unfroze%20my%20panes.%20It%20is%20frustrating%20because%20I%20can%20see%20the%20horizontal%20and%20vertical%20dashed%20page%20breaks%20but%20cannot%20%22grab%22%20them%20with%20my%20mouse%20and%20move%20them.%3C%2FP%3E%0A%3CP%3EDoes%20anyone%20have%20other%20ideas%3F%3C%2FP%3E%0A%3CP%3EThanks%20much%2C%3C%2FP%3E%0A%3CP%3EBill%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-170267%22%20slang%3D%22en-US%22%3ERe%3A%20Moving%20Page%20breaks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-170267%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20William%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20have%20a%20manual%20defined%20print%20area%20in%20the%20worksheet!%3C%2FP%3E%0A%3CP%3EIf%20so%2C%20you%20cannot%20adjust%20%3CSPAN%3Epage%20breaks.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ETo%20remove%20this%20print%20area%20go%20to%20%3CSTRONG%20class%3D%22ocpUI%22%3EFile%3C%2FSTRONG%3E%20menu%20%26gt%3B%26gt%3B%20%3CSTRONG%20class%3D%22ocpUI%22%3EPrint%20Area%20%3C%2FSTRONG%3E%26gt%3B%26gt%3B%20%3CSTRONG%20class%3D%22ocpUI%22%3EClear%20Print%20Area%3C%2FSTRONG%3E.%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ESame%20problem%20%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fmsoffice_excel-mso_mac-mso_mac2016%2Fpage-breaks-in-excel-2016-for-mac%2Fee73dcb0-fa75-4faa-8074-cad700919830%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehere%3C%2FA%3E.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EHope%20that%20helps!%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EHaytham%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
William Matschke
New 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!

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies