After you format your worksheet, you might want to adjust where the page breaks fall, particularly for longer worksheets. A page break is a formatting code that tells your printer to stop printing information on one page and start printing on the next page. Excel adds a page break to your worksheet when a page is full and identifies the division with a light dashed line. (Excel adds both vertical and horizontal page breaks.) If you don't want to see these breaks as you work, choose Options from the Tools menu, click the View tab, and then deselect the Page Breaks option in the Window Options area.
You can set your own page breaks manually in the worksheet. For example, you might choose to place a page break above a table to keep all the table entries on the same page. To set a manual page break in the worksheet, follow the steps shown in Figure 17-20.
The highlighted cell will become the upper left corner of the new page, and the manual page break will appear as a bold dashed line.
FIGURE 17-20. In Normal view, Excel indicates page breaks with bold, dashed lines.
ON THE WEB
The Invoice.xls example is on the Running Office 2000 Reader's Corner page.
Remove a Manual Page Break
To remove both the bottom and right edges of a page break, click the cell below and to the right of the page break, and choose Remove Page Break from the Insert menu. You can also remove just the bottom of the page break or just the right side by clicking any cell directly below or directly to the right of the page break.
Excel also provides a special worksheet view called Page Break Preview that quickly identifies the page breaks in your worksheet and allows you to easily manipulate them. Page Break Preview shows you a miniature version of your worksheet (a little like the Print Preview command on the File menu), but marks page breaks with a thick bold line and highlights page numbers with giant labels so that you can quickly find your place. (See Figure 17-21.) To select the page break preview, choose Page Break Preview from the View menu; to deselect it, choose Normal from the View menu.
To view and modify page breaks in Page Break Preview, follow these steps:
Page Break Preview is an active editing mode, so you can add information to worksheet cells, select ranges, issue commands, or edit individual entries while you preview your page breaks. However, you'll probably find it easier to read the contents of worksheet cells in Normal view.
FIGURE 17-21. To change a page break, simply drag a break line to a new location.