Microsoft Office Tutorials and References
In Depth Information
Page Break Preview: A Bird’s-Eye View of Your Worksheet
Controlling
Pagination
entire worksheet so that everything fits into one page. This scaling is tricky to get
right (and can lead to hopelessly small text), so make sure you review your
worksheet in the Page Layout view before you print it.
Tip: Page Break Preview mode, described next, gives you yet another way to squeeze more data onto a
single page.
Page Break Preview: A Bird’s-Eye View of Your Worksheet
You don’t must be a tree-hugging environmentalist to want to minimize the number
of pages you print out. Enter the Page Break Preview, which gives you a bird’s-eye
view of how an entire worksheet’s going to print. Page Break Preview is particularly
useful if your worksheet has lots of columns. That’s because Page Break Preview
zooms out so you can see a large amount of data at once, and it uses thick blue
dashed lines to show you where page breaks will happen, as shown in Figure 14-45.
In addition, the Page Break Preview numbers every page, placing the label “Page X”
(where “X” is the page number) in large gray lettering in the middle of each page.
Figure 14-45:
This example shows
a large worksheet in
Page Break Preview
mode. The worksheet
is too wide to fit on
one page (at least in
portrait orientation),
and the thick dotted
line clearly indicates
that the page breaks
after column G and
after row 47. (Excel
never breaks a
printout in the middle of a
column or row.)
 
Search JabSto ::




Custom Search