Microsoft Office Tutorials and References
In Depth Information
Previewing the Page Break: Getting a Bird’s-Eye View of the Printout
Now your printout will result in two pages. If you decide to reconsider this two-page
motif, you can remove the page break by clicking the worksheet where you’ve instituted
the break (in row 9, on Dodsworth’s record), and clicking Remove Page Break—the option
which appears right beneath Insert Page Break on the Breaks button. Doing so will return
you to the original one-page printout.
NOTE: The Reset All Page Breaks option under the Breaks button allows you to remove multiple
page breaks at one time, if you’ve introduced more than one break to the printout.
Previewing the Page Break: Getting a Bird’s-Eye View of
If the data you want to print contains many records and will likely result in a multipage
print, or if you’ve inserted your own page breaks as illustrated previously, you may want
to get a global idea of how the printout will look in its entirety. Realizing that the normal
worksheet view may not be able to display all the data at one time without you having to
scroll down and/or across repeatedly, Excel offers a page break preview , which presents
the printout-to-be in a curiously miniaturized form (see Figure 10–27).
Figure 10–27. The page break preview: The two-page salesperson printout, with the page break inserted by
Note the watermark-like Page 1 and Page 2 indicators, superimposed on the data. The
page break preview does two things:
It shrinks the print preview so you can see all, or at least considerably
more, of the data on one screen.
It lets you move the current position of the page break.