Checking and Adjusting Page Breaks

As you create your worksheet, Excel displays dotted lines to indicate where it is going to divide the pages. You can insert your own page breaks by choosing the Insert, Page Break command. However, Excel has a feature called Page Break Preview that displays page breaks more clearly and enables you to easily move page breaks by dragging them.

To turn on Page Break Preview, either open the View menu and select Page Break Preview , or click the Page Break Preview button in Print Preview. Excel displays page breaks as thick blue lines and displays the page number in big gray type on each page. You can then drag the lines with your mouse to move them, as shown in Figure 10.8. Although this feature does not help you fit the worksheet on a page, it does give you control over the way Excel divides the columns and rows that make up your worksheet. When you're finished, open the View menu and select Normal .

Figure 10.8. You can drag the blue lines in Page Break Preview to move the page breaks.

graphics/10fig08.gif

To insert a new page break, follow these steps:

  1. Click the cell below and to the right of the point where you want the new page break inserted. Excel inserts a horizontal page break above the cell and a vertical page break to the left of the cell.

  2. Open the Insert menu and choose Page Break . Excel inserts a horizontal page break above the selected cell and a vertical page break to the left of the cell. The page breaks appear as dotted lines.

To remove a page break that you inserted, right-click the cell below the horizontal page break or to the right of the vertical page break, open the Insert menu, and choose Remove Page Break .

Note

graphics/nman.gif

To insert only a horizontal page break, click the cell in column A that's below the point where you want the page break inserted. To insert only a vertical page break, click the cell in row 1 that's to the right of the place where you want the page break inserted.




Absolute Beginner's Guide to Microsoft Office Excel 2003
Absolute Beginners Guide to Microsoft Office Excel 2003
ISBN: 0789729415
EAN: 2147483647
Year: 2002
Pages: 189

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net