Adjusting Page Breaks

Excel makes it easy to adjust the positions of page breaks. You can do this by selecting View, Page Break Preview. The resulting preview is shown in Figure 11-7. You can move page breaks by dragging them with the mouse. You can even edit your worksheet while in Page Break Preview mode.

Page Break Preview shows default page breaks with dashed lines, which you can reposition by dragging with your mouse.

Figure 11-7. Page Break Preview shows default page breaks with dashed lines, which you can reposition by dragging with your mouse.

Using Page Break Preview allows you to see both the positions of your page breaks and the page numbers Excel will use when you print. Default page breaks—the ones that Excel proposes to use if you don't intervene—appear ...

Get Microsoft® Office Excel 2003 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.