Microsoft® Office Excel® 2007 Inside Out

Adjusting Page Breaks

Breaking pages across printed sheets of paper is often challenging using word-processing programs, but it can be even more challenging when planning the printing strategy for large spreadsheet models. Office Excel 2007 makes it easy to 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

Clicking the Page Break Preview button results in a view of your worksheet like the one shown in Figure 11-10. You can move page breaks by dragging them. You can even edit your worksheet while in Page Break Preview mode. Page Break Preview mode zooms out to give you a bird’s-eye view of the entire ...