Changing Page Breaks

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.

click to view at full size.

FIGURE 17-20. In Normal view, Excel indicates page breaks with bold, dashed lines.

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.

Using Page Break Preview

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:

  1. Choose Page Break Preview from the View menu. Excel starts Page Break Preview mode, as shown in Figure 17-21.
  2. If you see a dialog box that displays a welcome message, read the instructions about modifying page breaks, and then click OK. (You can suppress this dialog box by clicking Do Not Show This Dialog Again.)
  3. Examine the page breaks in your worksheet by using the vertical and horizontal scroll bars. Individual pages will be marked with large labels, and page breaks will be marked with bold lines.
  4. TIP
    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.

    click to view at full size.

    FIGURE 17-21. To change a page break, simply drag a break line to a new location.

  5. To change a page break marked with a bold line, drag the break line with the mouse to a new location in the worksheet. When you release the mouse button, Excel will repaginate the worksheet and display the new page break. (If you want to reverse the change, you can reinstate the old page break by simply clicking the Undo button on the Standard toolbar.)
  6. When you're finished working in Page Break Preview, choose Normal from the View menu.

Running Microsoft Office 2000 Small Business
Running Microsoft Office 2000
ISBN: 1572319585
EAN: 2147483647
Year: 2005
Pages: 228 © 2008-2017.
If you may any questions please contact us: