Microsoft Office Tutorials and References
In Depth Information
Gimme a (Page) Break—Another View
Gimme a (Page) Break—Another View
Whe n y ou se t a pr i n t a r e a for a mul ti - pa g e pr i n tout of the wor k she e t, Exce l wi l l n a tur a l l y occupy
the entire first page with data and then move on to page two when it runs out of space, and so on across
all the printed pages. But sometimes you want a next page to start with a particular row on top, for the
sake of appearances—but Excel can’t know that, at least not by default (Note: We’re not referring to the
rows-to-repeat-on-top issue here. Here we want the row to appear just once, but at the top of a specific
pr i n te d pa g e .) You ca n , howe v e r , i n str uct Exce l to r e l oca te the poi n t a t whi ch a pa g e br e a k s—a t l e a st
within limits, with the Page Break Preview option. By clicking the View tab Page Break Preview in
the Workbook Views button group, you’ll see (Figure 9-29):
Figure 9–29. The Page Break Preview
This is an old Excel option, with a curiously shrunken image of the worksheet (to enable you to get
a bird’s eye view of the print breaks) and a quaint dialog box to boot (I mean, how many of them start
with “Welcome to…”?). Click OK, and you can then begin to adjust your page break settings.
The dotted line you see above at row 61 represents the current point at which Page 1 breaks (note
the watermark reference to the page number), and if you click on that line and drag it either upwards
or downwards , y ou’ l l be abl e to mov e the pag e br e ak poi n t to a di ffe r e n t r ow. (If y ou dr ag down war ds,
you’ll naturally be adding rows to the page—requiring Excel to rescale the page downwards in order to
accommodate those rows in view of the existing print margins. There’s only so much physical space on
the page!) Drag, say to row 56, release the mouse, and you’ll see (Figure 9-30):
Search JabSto ::

Custom Search