Microsoft Office Tutorials and References
In Depth Information
Using Page Break Preview
border indicates the print area
indicates area not
selected for printing
3. Click the OK button to close the dialog box before you change the dimensions of the
printed area to include the other table.
4. Position the pointer at the bottom border of the print area (located at row 19) until the
pointer changes to , and then click the border and drag it down to row 26 . The print area
has now been expanded to the cell range A1:H26.
Trouble? If you are unsure of the location of the bottom border, click row 19 to make the
border easier to see, and then repeat Step 3.
5 . Click View on the menu bar, and then click Normal to switch back to Normal view.
Another approach that Joan might take is to place the two tables on separate pages. You
can do this for her by inserting a page break , which forces Excel to place a portion of a
worksheet on a new page. Before you insert a page break, you need to indicate where in
the worksheet you want the break to occur. If you select a cell in the worksheet, the page
break will be placed directly above and to the left of the cell. Selecting a row or a column
places the page break directly above the row or directly to the left of the column. You will
place a page break directly above row 20, which will separate the first sales table from
To insert a page break:
1. Click row 20 , click Insert on the menu bar, and then click Page Break . Another black dot-
ted line appears—this time above row 20, indicating there is a page break at this point in
the print area.