Forum Discussion
Solved
Excel page break not working
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?
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.
I have tried numerous things to drag and drop the page breaks. The arrows on the excel spreadsheets to drag and drop do not show. They were working. I reset, checked my settings, shut off and back on the computer, still do not function any suggestions?
Did you switch to Page Break Preview?
That is the only view in which you can drag page breaks.
- Thanks for asking the question! I had never come across this situation before and it was driving me nuts!
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.
HansVogelaar This doesn't work. It's a simple spreadsheet - a list, and I've tried to do what I normally do for any spreadsheet that needs a one-row header line and one page break. When I insert the page break, Excel thinks the text from the SECOND row of the spreadsheet is being repeated (along with the first row) and overwrites the text on the second page. I've tried all the 'solutions' and work arounds with no success. Microsoft needs to fix this. I'd attach a screen shot, but this forum won't allow it.
If you wish, click on my user picture and send me a message. You should be able to attach a screenshot, or even better, a sample workbook to the message.
- 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?
You'll have to set Height to Automatic instead of 2 pages. The manually inserted page break below row 38 should then work.
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.
