If Page break is not working in Excel, check the Page Setup to ensure that the “Fit to” option is not set to fit the entire sheet on one page. You could also Reset Page Breaks by going to the ...

Before someone suggests just going into page setup and changing it to what I want, Excel does this on a per-tab basis. I need to go in and do this for every tab (there could be 20 or more).

This is the easiest way to change the orientation of a page in Microsoft Excel. Dashed vertical lines will appear on the worksheet, giving you an idea about how many columns will be covered ...

However, if you don't manage your print setup, this can create print jobs with page breaks where you don't want them and reams of blank pages as Excel works its way down to the random character ...