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 pa...
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.
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?