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.
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?
RCully I suspect that you are looking under File, Page Setup. There you will indeed not find the "Automatic" option. But, 100% sizing is the same as automatic.
But, look on the Page Layout ribbon. There you should see the Automatic options for Height and Width in the Scale to Fit group.
If not, please state your Excel version. Can't really remember if this is something that existed in older versions of Excel for Mac.
HansVogelaar 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...
Thank you, Hans. That did the trick.
