#Excel for mac page breaks manual

When you move a page break that Excel had inserted (i.e., an automatic page break), it becomes a manual one. You might notice that, when you move a dashed line, it becomes a solid one in its new location. To move a page break, you simply drag its line to the desired location.

If you do not like how the spreadsheet is breaking across the pages, you can move, add, or delete page breaks. Solid lines signify the page breaks manually added by users. 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. Click the “Page Break Preview” button on the left side of the ribbon.Open the spreadsheet you want to print.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.

Excel for mac page breaks