Forum Discussion
Excel page break not working
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.
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.
HansVogelaar Under Page Setup/Page/Scaling, there isn't an option for 'Automatic' as it just gives me a dropdown box to insert figures for both 'width' and 'tall'.
This may be because I'm using the Mac version but am having exactly the same issue as Stuart.
Any ideas?
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.
