Part I: Getting Started with Excel
180
Note
Even though Excel displays a variety of paper sizes, your printer may not be capable of using them. n
Printing multiple copies of a report .........................................................................
Use the Copies control at the top of the Print tab in Backstage View to specify the number of copies
to print. Just enter the number of copies you want and then click Print.Tip
If you’re printing multiple copies of a report, make certain that the Collated option is selected so that Excel
prints the pages in order for each set of output. If you’re printing only one page, Excel ignores the Collated
setting. n
Adjusting page margins ...........................................................................................
Margins are the unprinted areas along the sides, top, and bottom of a printed page. Excel provides
four “quick margin” settings, and you can also specify the exact margin size you require. All
printed pages have the same margins. You can’t specify different margins for different pages.In Page Layout view, a ruler is displayed above the column header and to the left of the row
header. Use your mouse to drag the margins in the ruler. Excel adjusts the page display immedi-
ately. Use the horizontal ruler to adjust the left and right margins, and use the vertical ruler to
adjust the top and bottom margins.From the Page Layout ➪ Page Setup ➪ Margins drop-down list, you can select Normal, Wide,
Narrow, or the Last custom Setting. These options are also available when you choose File ➪ Print.
If none of these settings does the job, choose Custom Margins to display the Margins tab of the
Page Setup dialog box, shown in Figure 9.4.To change a margin, click the appropriate spinner (or you can enter a value directly). The margin
settings that you specify in the Page Setup dialog box will then be available in the Page
Layout ➪ Page Setup ➪ Margins drop-down list, referred to as Last Custom Setting.Note
The Preview box in the center of the Page Setup dialog box is a bit deceiving because it doesn’t really show you
how your changes look in relation to the page; rather, it displays a darker line to let you know which margin
you’re adjusting. n
In addition to the page margins, you can adjust the distance of the header from the top of the page
and the distance of the footer from the bottom of the page. These settings should be less than the
corresponding margin; otherwise, the header or footer may overlap with the printed output.By default, Excel aligns the printed page at the top and left margins. If you want the output to be
centered vertically or horizontally, select the appropriate check box in the Center on Page section
of the Margins tab.