Dashed lines indicate page breaks that Excel automatically added. In the Page Break Preview screen, you can see how the rows and columns will break across the pages. The Page Break Preview feature is available in Excel 2007 and later versions. Plus, you can adjust any page breaks that are causing problems while in the preview screen.
The preview screen gives you a much more detailed view than the one you would see using print preview. You can be left with large gaps on your pages, especially if the height of your rows varies.įortunately, Excel has the Page Break Preview feature, which lets you view how the pages in a spreadsheet will break before you print it.
While it is easy to manually insert a page break, it can often affect how the remaining pages flow. Printing a multiple-page Microsoft Excel spreadsheet can be frustrating when the pages do not break where you want them to.
