SOLVED

Excel page break not working

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?

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

Thanks for asking the question! I had never come across this situation before and it was driving me nuts!
I need a little more information as I still cannot make it work. I have a sheet with A-L columns and 65 rows. Print area is set to that. I want to see rows 1-38 on one page and 39-65 on a 2nd page. If left unconstrained, the sheet takes 9 pages to print. If I set print to fit 1 page wide by 2 pages tall, the page break occurs at row 52, no matter what I do. This happens when I follow your guide. Do you know what I might be doing wrong?

@Stuart_Miller 

You'll have to set Height to Automatic instead of 2 pages. The manually inserted page break below row 38 should then work.

@Hans Vogelaar 

Thank you, Hans.  That did the trick.

@Hans Vogelaar It looks like you’ve been very helpful, not just to me but to others with similar problems.  Surely that’s a fault with Excel if the obvious page break settings can be in conflict with, and be overruled by, some hidden settings?

@Spydah Perhaps Excel should display a warning if you try to specify conflicting settings, but I don't think it's a bug. The default setting for Width and Height is automatic. It requires manual intervention to change them to (for example) 1 page wide by 2 pages tall. By doing so, one effectively tells Excel to override other pagination settings...