Page 297 - Excel 2013 All-in-One For Dummies

Working with the Page Setup Options 279
In addition to the Normal margin settings, the program enables you to choose two other standard margins from the Margins button’s drop-down menu in the Print screen (Ctrl+P):
✦ Wide margins with 1-inch top, bottom, left, and right margins and 1⁄2
inch separating the header and footer from the top and bottom margins, respectively.
✦ Narrow margins with top and bottom margins of 3⁄4 inch, and left and right margins of 1⁄4 inch with slightly more than 1⁄4 inch separating the header and footer from the top and bottom margins, respectively.
Frequently, you find yourself with a report that takes up a full printed page and then just enough to spill over onto a second, mostly empty, page. To squeeze the last column or the last few rows of the worksheet data onto Page 1, try choosing Narrow from the Margins button’s drop-down menu.
If that doesn’t do it, you can try manually adjusting the margins for the report either from the Margins tab of the Page Setup dialog box or by drag- ging the margin markers in the print preview area on the Print screen in the Excel Backstage view. To get more columns on a page, try reducing the left and right margins. To get more rows on a page, try reducing the top and bottom margins.
To open the Margins tab of the Page Setup dialog box (shown in Figure 5-5), open the Page Setup dialog box (Alt+PSP) and then click the Margins tab. There, enter the new settings in the Top, Bottom, Left, and Right text boxes — or select the new margin settings with their respective spinner buttons.
Figure 5-5:
Adjust
your report margins from the Margins tab in the Page Setup dialog box.
Book II Chapter 5
Printing Worksheets