Home

Continuous page break in Excel on Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-1200241%22%20slang%3D%22en-US%22%3EContinuous%20page%20break%20in%20Excel%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1200241%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20creating%20invoice%20template%20in%20excel%20and%20I%20need%20to%20add%20a%20continuous%20break%20to%20readjust%20information%20columns%20from%20ABCDE%20to%20only%20ABC.%20Unable%20to%20find%20command%2C%20please%20help.%20Latest%20MS%20Excel%20on%20Mac.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1200241%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1200500%22%20slang%3D%22en-US%22%3ERe%3A%20Continuous%20page%20break%20in%20Excel%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1200500%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F570400%22%20target%3D%22_blank%22%3E%40Henri1010%3C%2FA%3E%26nbsp%3BYou%20can%20select%20cell%20D1%20and%20then%20on%20the%20Page%20Layout%20ribbon%2C%20Breaks%2C%20Insert%20Page%20Break.%20But%20then%20you%20still%20have%20to%20restrict%20that%20only%201%20page%20should%20be%20printed.%3C%2FP%3E%3CP%3EAlternatively%2C%20just%20select%20columns%20A%3AC%20and%20define%20these%20as%20your%20Print%20Area.%20Anything%20right%20of%20column%20C%20will%20be%20ignored%20when%20printing.%3C%2FP%3E%3CP%3EIn%20both%20cases%2C%20a%20slightly%20darker%20border%20line%20will%20appear%20between%20C%20and%20D.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-02-28%20at%2013.32.17.png%22%20style%3D%22width%3A%20502px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F174031iC15BBBA2C4097BCE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screenshot%202020-02-28%20at%2013.32.17.png%22%20alt%3D%22Screenshot%202020-02-28%20at%2013.32.17.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1200626%22%20slang%3D%22en-US%22%3ERe%3A%20Continuous%20page%20break%20in%20Excel%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1200626%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F570400%22%20target%3D%22_blank%22%3E%40Henri1010%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EContinuous%20page%20breaks%20are%20found%20in%20Word.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1203991%22%20slang%3D%22en-US%22%3ERe%3A%20Continuous%20page%20break%20in%20Excel%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1203991%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20I%20have%20marked%20a%20red%20line%20where%20I%20would%20like%20to%20change%20orientation.%20As%20you%20can%20see%20it%20is%20an%20invoice%20template%2C%20at%20the%20bottom%20you%20can%20see%2C%20that%20columns%20are%20overwriting%20rows.%20What%20would%20be%20the%20best%20fix%20for%20that%20option%3F%20I%20would%20need%20to%20be%20able%20to%20add%20new%20rows%20with%20automated%20settings.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1204351%22%20slang%3D%22en-US%22%3ERe%3A%20Continuous%20page%20break%20in%20Excel%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1204351%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F570400%22%20target%3D%22_blank%22%3E%40Henri1010%3C%2FA%3E%26nbsp%3BSorry%20to%20say%20I%20don't%20understand.%20What%20do%20you%20mean%20be%20%22columns%20over-writing%20rows%22%3F%20How%20would%20you%20like%20the%20invoice%20to%20look%20like%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F428790%22%20target%3D%22_blank%22%3E%40Patrick2788%3C%2FA%3E%26nbsp%3Bindicated%2C%20%22continuous%20page%20breaks%22%20are%20found%20in%20Word.%20I%20hardly%20ever%20use%20Word%20and%20don't%20really%20know%20what%20such%20breaks%20are%20are%20or%20what%20they%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, I am creating invoice template in excel and I need to add a continuous break to readjust information columns from ABCDE to only ABC. Unable to find command, please help. Latest MS Excel on Mac. 

4 Replies
Highlighted

@Henri1010 You can select cell D1 and then on the Page Layout ribbon, Breaks, Insert Page Break. But then you still have to restrict that only 1 page should be printed.

Alternatively, just select columns A:C and define these as your Print Area. Anything right of column C will be ignored when printing.

In both cases, a slightly darker border line will appear between C and D.

Screenshot 2020-02-28 at 13.32.17.png

 

Highlighted

@Henri1010 

Continuous page breaks are found in Word.

Highlighted

@Riny_van_Eekelen 

So I have marked a red line where I would like to change orientation. As you can see it is an invoice template, at the bottom you can see, that columns are overwriting rows. What would be the best fix for that option? I would need to be able to add new rows with automated settings. 

Thanks

Highlighted

@Henri1010 Sorry to say I don't understand. What do you mean be "columns over-writing rows"? How would you like the invoice to look like?

 

As @Patrick2788 indicated, "continuous page breaks" are found in Word. I hardly ever use Word and don't really know what such breaks are are or what they do.

 

Related Conversations
Time Sheet Formula Help
masonwood291 in Excel on
0 Replies
Sorting out duplicates.
lesleypohl in Excel on
7 Replies
Excel graphing and trendline bug?
ET_69 in Excel on
0 Replies
Offset
Jrm92 in Excel on
0 Replies
List data validation
Tm81700 in Excel on
1 Replies