Part I: Getting Started with Excel
File ➪ Print. If none of these settings does the job, choose Custom Margins to display the
Margins tab of the Page Setup dialog box, as shown in Figure 7.4.
FIGURE 7.4
The Margins tab of the Page Setup dialog box
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.
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; instead, it displays a darker line to let you know which margin you’re
adjusting.
You can also adjust margins in the preview window in Backstage view (choose File ➪ Print).
Click the Show Margins button in the bottom-right corner to display the margins in the
preview pane. Then drag the margin indicators to adjust the margins.
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.
