Help with Page break in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1948066%22%20slang%3D%22en-US%22%3EHelp%20with%20Page%20break%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1948066%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EAny%20chance%20if%20you%20can%20help%20me%20with%20the%20following.%3C%2FP%3E%3CP%3EThe%20page%20break%20feature%20in%20Excel%20works%20vertically.%20Meaning%3A%3C%2FP%3E%3CP%3EPage%201%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BPage%203%3C%2FP%3E%3CP%3EPage%202%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BPage%204PageBreak%3C%2FP%3E%3CP%3Eand%20so%20on...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20make%20it%20work%20across%3F%3C%2FP%3E%3CP%3EPage%201%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BPage%202%3C%2FP%3E%3CP%3EPage%203%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BPage%204%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20so%20on...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Echeers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1948066%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1948374%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Page%20break%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1948374%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F888322%22%20target%3D%22_blank%22%3E%40BSigm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EActivate%20the%20Page%20Layout%20tab%20of%20the%20ribbon.%3C%2FP%3E%0A%3CP%3EClick%20the%20arrow%20in%20the%20lower%20right%20corner%20of%20the%20Page%20Setup%20group.%3C%2FP%3E%0A%3CP%3EActivate%20the%20Sheet%20tab%20of%20the%20Page%20Setup%20dialog.%3C%2FP%3E%0A%3CP%3EUnder%20'Page%20order'%2C%20select%20'Over%2C%20then%20down'.%3C%2FP%3E%0A%3CP%3EClick%20OK.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0019.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F237319i1702C0665E6FFCB8%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0019.png%22%20alt%3D%22S0019.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello

Any chance if you can help me with the following.

The page break feature in Excel works vertically. Meaning:

Page 1     Page 3

Page 2     Page 4PageBreak

and so on...

 

Is it possible to make it work across?

Page 1     Page 2

Page 3     Page 4 

and so on...

 

cheers

2 Replies

@BSigm 

Activate the Page Layout tab of the ribbon.

Click the arrow in the lower right corner of the Page Setup group.

Activate the Sheet tab of the Page Setup dialog.

Under 'Page order', select 'Over, then down'.

Click OK.

 

S0019.png

Thank you Hans. You're a legend