Adjusting Page Breaks

Breaking pages across printed sheets of paper is often challenging using word-processing programs, and it can be even more challenging when planning the printing strategy for large spreadsheet models. Excel 2010 helps you adjust the positions of page breaks by offering a couple of approaches: the Breaks button on the Page Layout tab on the ribbon and the Page Break Preview button on the View tab.

Using Page Break Preview

image with no caption

Clicking the Page Break Preview button results in a view of your worksheet like the one shown in Figure 11-14. You can move page breaks by dragging them. You can even edit your worksheet while in Page Break Preview ...

Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.