Microsoft Office Tutorials and References
In Depth Information
Adjusting Page Layout
Chapter 12
Setting Security and Printing Options
Adjusting Page Layout
With just a single click, you can
print your worksheet. But before you
print it, you might want to specify what
paper size you want to use, how large you want the
margins, and whether or not to print the gridlines.
You might also only print a portion of the
worksheet instead of printing it in its entirety.
Managing Manual Page Breaks
As you have probably already noticed, when you
have more data on your worksheet than will fit on
a printed page, Excel automatically starts a new
page for you. Excel indicates page breaks as dotted
lines vertically and horizontally on the screen. You
can, however, tell Excel how to manage these page
breaks. The easiest way to manage page breaks is
through Page Break Preview.
Figure 12-14
Viewing page breaks.
To set page breaks manually, position your mouse
over any blue dotted line. The mouse pointer
turns into a double-headed arrow, and you can
drag the line until it is in the position where you
want the page to break. If you drag the page break
so the page is longer, Excel scales the page to fit
when printing. Manual page breaks appear as
solid blue lines.
Choose View>Workbook Views>Page Break
Preview. Click OK at the Welcome to Page Break
Preview message box. Your worksheet appears in
Page Break Preview mode and shows blue dotted
lines at the natural page breaks (see Figure 12-14).
When you are finished creating manual page
breaks, choose View>Workbook Views>Normal.
Hide Message Box
To hide future occurrences of the Welcome
to Page Break Preview box, check Do Not
Show This Dialog Again.
Search JabSto ::




Custom Search