Microsoft Office Tutorials and References
In Depth Information
My Page Was Set Up!
Massaging the margins
The Normal margin settings that Excel applies to a new report use standard
top, bottom, left, and right margins of 3 ⁄ 4 inch with just over a 1 ⁄ 4 inch
separating the header and footer from the top and bottom margin, respectively.
In addition to the Normal margin settings, the program enables you to select
two other standard margins from the Margins button’s drop-down menu:
✓ 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 margin,
✓ Narrow margins with a top and bottom margin of 3 ⁄ 4 inch and a left and
right margin of 1 ⁄ 4 inch with 0.3 inch separating the header and footer
from the top and bottom margin, 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
selecting Narrow on the Margins button’s drop-down menu.
If that doesn’t do it, you can try manually adjusting the margins for the report
from the Margins tab of the Page Setup dialog box or by dragging the margin
markers in the preview area of the Print screen in the Backstage view (Press
Ctrl+P and click the Show Margins button). 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-4),
click Custom Margins on the Margins button’s drop-down menu. 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.
Select one or both Center on Page options in the Margins tab of the Page Setup
dialog box (refer to Figure 5-4) to center a selection of data (that takes up less
than a full page) between the current margin settings. In the Center on Page
section, select the Horizontally check box to center the data between the left
and right margins. Select the Vertically check box to center the data between
the top and bottom margins.
When you click the Show Margins button in the Print screen in the Excel
Backstage view (Ctrl+P) to modify the margin settings directly, you can also
massage the column widths as well as the margins. (See Figure 5-5.) To change
one of the margins, position the mouse pointer on the desired margin marker
(the pointer shape changes to a double-headed arrow) and drag the marker
with your mouse in the appropriate direction. When you release the mouse
button, Excel redraws the page, using the new margin setting. You may gain
or lose columns or rows, depending on what kind of adjustment you make.
Changing the column widths is the same story: Drag the column marker to the
left or right to decrease or increase the width of a particular column.