Microsoft Office Tutorials and References
In Depth Information
2. Click cell A1 to remove the selection, click View on the menu bar, click Page Break
Preview , and then click the OK button to close the Welcome to Page Break Preview dialog
box. As shown in Figure 3-36, the second table will now appear on page 2 of the printout.
Inserting a page break
3. Click View on the menu bar, and then click Normal to return to Normal view.
As Joan reviews the preview of the worksheet, she notices that the name of the com-
pany, “NewGeneration Monitors,” and the two subtitles appear on the first page, but not
on the second. That is not surprising because the range that includes the titles and subti-
tles is limited to the first page of the printout. However, Joan would like to have this infor-
mation repeated on the second page.
You can repeat information, such as the company name, by specifying which cells in
the print area should be repeated on each page. This is particularly useful in long tables
that extend over many pages. In such cases, you can have the column titles repeated for
each page of the printout.
To set rows or columns to repeat on each page, you will open the Page Setup dialog
box from the worksheet window.
To repeat the first three rows on each page:
1. Click File on the menu bar, click Page Setup , and then click the Sheet tab. The Sheet tab
displays options you can use to control how the worksheet is printed. Note that the print
area you have defined is already entered into the Print area box. Because Joan wants the
first three rows of the worksheet to be repeated on each printed page, you will have to
2. Click the Rows to repeat at top box, move your pointer over to the worksheet, and then
click and drag over the range A1:A3 . A flashing border appears around the first three rows
in the worksheet. This is a visual indicator that the contents of the first three rows will be
repeated on all pages of the printout. In the Rows to repeat at top box, the cell reference
$1:$3 appears. See Figure 3-37.