Manual pagebreaks

Occasional Visitor

I'm running Excel 2013 on Win 7 Enterprise. When I'm adding manual page breaks does it show in the manual page break view, but not in the normal, or page layot. And, especially, it doesn't give me the page breaks when printing. Is there some settings I need to change?

1 Reply
Most likely, in the Page Layout, the worksheet is set to print to 1 page wide by 1 page tall. Set them to Automatic and then go to Page Break Preview (lower right corner of the screen, just next to the zoom bar, or the button on the View tab as well).