Microsoft Office Tutorials and References
In Depth Information
Inserting Page Breaks
4. In the Page Setup group on the Page Layout tab, click the Print Area button, and
then click Set Print Area . The print area changes to cover only the range A1:K19.
The rest of the worksheet content is shaded to indicate that it will not be part of
the printout.
5. In the Page Setup group, click the Print Area button, and then click Clear Print
Area . The print area is reset to cover the entire contents of the worksheet.
Inserting Page Breaks
Often the contents of a worksheet do not fi t onto a single page. By default, Excel prints
as much of the content that fi ts on single page without resizing the content, and then
inserts automatic page breaks to continue printing the remaining worksheet content on
successive pages. This can result in page breaks that leave a single column or row on a
separate page or split worksheet content in awkward places such as within a table.
One way to fi x this problem is to scale the printout by reducing the font size to fi t on
a single sheet of paper. However, if you have more than one or two columns or rows to
fi t onto the page, the resulting text is often too small to read comfortably. The better fi x
is usually to split the worksheet into logical segments, which you can do by inserting
manual page breaks that specify exactly where the page breaks occur. A page break is
inserted directly above and to the left of a selected cell, directly above a selected row, or
to the left of a selected column.
Inserting and Removing Page Breaks
To insert a page break:
• Select the first cell below the row where you want to insert a page break.
• In the Page Setup group on the Page Layout tab, click the Breaks button, and then
click Insert Page Break.
To remove a page break:
• Select any cell below or to the right of the page break you want to remove.
• In the Page Setup group on the Page Layout tab, click the Breaks button, and then
click Remove Page Break (or click Reset All Page Breaks to remove all the page breaks
from the worksheet).
Tom wants the three tables in the Monthly Sales worksheet to print on separate pages.
You’ll insert page breaks to accomplish this.
To insert page breaks between the tables:
1. Click cell A20 . With this cell selected, a page break will be inserted between
rows 19 and 20.
In Page Break Preview, a
dashed blue line indicates
an automatic page break
and a solid blue line
indicates a manual page break.
2. In the Page Setup group on the Page Layout tab, click the Breaks button, and
then click Insert Page Break . A page break separates row 19 from row 20.
3. Click cell A35 , and then repeat Step 2 to insert a page break that splits the
second table from the third. The printout is now three pages. See Figure 2-38.
Search JabSto ::




Custom Search