SOLVED

Excel page break not working

%3CLINGO-SUB%20id%3D%22lingo-sub-2907587%22%20slang%3D%22en-US%22%3EExcel%20page%20break%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2907587%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20created%20page%20breaks%20in%20Excel%20spreadsheets%20many%20times%2C%20but%20all%20of%20a%20sudden%20the%20feature%20isn't%20working%20in%20Excel%20365.%26nbsp%3B%20Any%20suggestions%3F%26nbsp%3B%20I%20go%20to%20Page%20Break%20Preview%2C%20where%20everything%20is%20on%20the%20one%20page.%26nbsp%3B%20I%20then%20position%20the%20cursor%20about%20halfway%20down%20the%20sheet%20in%20Column%20A%2C%20go%20the%20Page%20Layout%20and%20click%20on%20Insert%20Page%20Break.%26nbsp%3B%20Absolutely%20nothing%20happens.%26nbsp%3B%20Even%20if%20I%20select%20the%20Remove%20Page%20Breaks%20option%20beforehand%20it%20still%20doesn't%20work.%3C%2FP%3E%3CP%3EIs%20there%20a%20bug%20in%20Excel%20365%3F%26nbsp%3B%20How%20can%20I%20overcome%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2907587%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2907820%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20page%20break%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2907820%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1201844%22%20target%3D%22_blank%22%3E%40Spydah%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EOn%20the%20Page%20Layout%20tab%20of%20the%20ribbon%2C%20click%20the%20little%20arrow%20in%20the%20lower%20right%20corner%20of%20the%20Page%20Setup%20group.%3C%2FP%3E%0A%3CP%3EIn%20the%20Page%20tab%20of%20the%20Page%20Setup%20dialog%2C%20check%20whether%20the%20sheet%20has%20been%20set%20up%20to%20fit%20into%201%20page%20wide%20by%201%20page%20tall.%3C%2FP%3E%0A%3CP%3EIn%20the%20Sheet%20tab%20of%20this%20dialog%2C%20check%20whether%20a%20print%20area%20has%20been%20specified.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I've created page breaks in Excel spreadsheets many times, but all of a sudden the feature isn't working in Excel 365.  Any suggestions?  I go to Page Break Preview, where everything is on the one page.  I then position the cursor about halfway down the sheet in Column A, go the Page Layout and click on Insert Page Break.  Absolutely nothing happens.  Even if I select the Remove Page Breaks option beforehand it still doesn't work.

Is there a bug in Excel 365?  How can I overcome it?

2 Replies
best response confirmed by Spydah (New Contributor)
Solution

@Spydah

On the Page Layout tab of the ribbon, click the little arrow in the lower right corner of the Page Setup group.

In the Page tab of the Page Setup dialog, check whether the sheet has been set up to fit into 1 page wide by 1 page tall.

In the Sheet tab of this dialog, check whether a print area has been specified.

@Hans Vogelaar 

Many thanks.  That did solve it.  I didn't realise there was a setting, accessible only via the ribbon, which specified 1 page wide by 1 page tall and that it overrides the equivalent option within the print settings.