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.
I have a similar problem. I have cleared print area and added page breaks between lines. I want the page to print on 11 X 17 paper and have selected that. When I do a print preview only half the width of the paper is used. I would like to widen some of the columns but not matter what settings I chose, the program auto-paginates at only a portion of the width of the paper. I tried printing to a pdf in case the problem was that my printer does not take this size paper, but that did not help.