Microsoft Office Tutorials and References
In Depth Information
Chapter 11: Printing and presenting
Printing and presenting
Controlling the appearance of your pages...........437
Controlling what and where to print. . . . . . . . . . . . . . . . 455
Adjusting page breaks............................457
Using Print Preview ..............................459
Creating portable documents .....................461
MICROSOFT E XCEL makes it easy for you to produce polished, professional-looking
reports. In this chapter, we explain how to define the layout of your printed
pages, control page breaks, and preview your pages for printing.
Controlling the appearance of your pages
The options used most often to affect the appearance of your printed pages are available
on the Page Layout tab on the ribbon, shown in Figure 11-1. This is the central control
panel for setting up paper sizes, margins, and page orientation, as well as for working with
page breaks, print areas, and other printing options. For even more control over the page
layout, click the dialog box launcher in the Page Setup group on the Page Layout tab to
display the Page Setup dialog box, also shown in Figure 11-1.
The Print category of the File tab (also known as the Backstage view) now includes the
most-often-used options as well, and it provides some visual feedback about what all these
things actually do. A print preview is displayed on the right side of the screen and
dynamically displays the settings you select from the options on the left side. Click the File tab, and
then click Print to display a screen similar to the one shown in Figure 11-2.
Setting page options
The settings you use most frequently are duplicated in several places. Most of what you
need is on the Page Layout tab of the ribbon, in the Print category on the File tab, and, of
course, in the Page Setup dialog box. These settings control page orientation, scaling, paper
size, print quality, and page numbering.