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.
RCully But your initial post was that you didn't have the "Automatic" setting. Now you mention that Excel doesn't automatically print 1 high by 2 wide. Well, isn't that obvious?
Played around a little with page setup and it seems that "Automatic" scaling sets the pages to max 640 pixels wide and max 960 pixels high. Leaving it to Automatic will, in your case, print 8 by 8. If that's not what you want you need to override the Automatic setting and explicitly tell Excel to print 1 wide by 2 high. And when you have done that, you will notice that the scaling percentage will have automatically been set to whatever scaling achieves that. No need to do that by trial and error.
I have gone back and set auto on and 1 wide by 2 tall and it reverts to the original query (not mine) whereby it prints as requested (1x2) but it doesn't take notice of the page break so it breaks where it wants to (after the page break) as opposed to where I want it to (at the page break).
Someone else suggested that a warning should be shown that altering the width x tall figures which I now tend to agree with as it would have stopped having to create a post with this question.
Thanks again and I have now set it back to auto and 45% scaling. It works as I want it to so all's well with the world (for this at least)