Microsoft Office Tutorials and References
In Depth Information
Managing Worksheet Views
Drag to Adjust
Type In One of the Header Boxes
to Add Header Information
Checking the Page Layout
If you move a page break to include more
rows or columns on a single page, you won’t
really see much of a change to data size
onscreen. You will notice a difference,
however, when you print the worksheet.
If you want to see in advance how much
the text will be reduced in order to cram in
those extra rows or columns on a page in
which you’ve moved the page break, check
the Scale percentage, located on the Page
Layout tab, in the Scale to Fit group.
Page Break Preview
Page Layout view displays your data
as it will look when printed.
Page breaks are displayed as blue dashed lines
on the worksheet; each page is marked with
the text Page , followed by some number so you
know which page you are viewing. (See Figure
6-29.) If you drag a page break and drop it
elsewhere in the sheet, you are telling Excel to place
the break there. The page break becomes solid, so
you can tell your manual page breaks from Excel’s
automatic ones. In addition, page numbers and
the size of data are automatically adjusted so
everything fits on the pages you have designated.
To remove a page break, drag it off the printout. To
remove all manual page breaks and return to
automatic page breaks, click the Breaks button
on the Page Layout tab and select Reset All Page
Breaks from the pop-up menu.
Page Break Preview allows you to view
and change page breaks.