Print margins bespeak how much white space Excel 2010 places betwixt the worksheet data and the border of the folio. The Normal margin settings that Excel applies to a new workbook have top and bottom margins of 0.75 inches and left and right margins of 0.7 inches. You too can specify margins for the header and footer and center your worksheet horizontally or vertically on the page to improve the appearance of a printed report.

In improver to the Normal margin settings, Excel enables you to select ii other standard margins from the Margins button's drop-downwards menu on the Page Layout tab of the Ribbon:

  • Wide margins with 1-inch top, bottom, left, and right margins and 0.5 inches separating the header and footer from the acme and lesser margins.

  • Narrow margins with top and bottom margins of 0.75 inches, and left and right margins of 0.25 inches with 0.three inches separating the header and footer from the superlative and bottom margins.

    Excel 2010 provides a few margin presets on the Margins drop-down menu.

    Excel 2010 provides a few margin presets on the Margins driblet-down carte du jour.

Yous also can manually adjust the margins of a report either from the Margins tab of the Folio Setup dialog box or by dragging the margin markers in the Print panel of Excel's Backstage view (printing Ctrl+P and so click the Evidence Margins icon). To get more columns on a folio, try reducing the left and right margins. To become more rows on a page, try reducing the top and bottom margins.

Follow these steps to suit margins using the Page Setup dialog box:

  1. On the Folio Layout tab, in the Folio Setup group, click the Margins button and select the Custom Margins command from the drop-downwardly bill of fare.

    You can also click the Folio Setup dialog box launcher in the bottom-right corner of the Page Setup grouping. The Folio Setup dialog box appears.

  2. Click the Margins tab.

    Adjust your report margins from the Margins tab in the Page Setup dialog box.

    Adjust your report margins from the Margins tab in the Page Setup dialog box.

  3. Enter the new margin settings in the Top, Lesser, Left, and Right text boxes.

    You besides can use the spin buttons to alter the margin settings in small increments.

  4. (Optional) Select 1 or both Heart on Page check boxes to center the data between the current margin settings.

  5. Click OK.

Y'all can click the Print Preview push button in the Folio Setup dialog box at any time to see how the changes you lot brand bear upon the preview of your report.

If you select the Show Margins icon near the bottom-correct corner of the Print panel in Backstage view, you can modify the margins by dragging margin markers. When you release the mouse button, Excel redraws the page, using the new margin setting. (You tin also adjust column widths like this.)

Drag a marker to adjust its margin in the Print panel when the Show Margins icon is selected.

Elevate a marker to conform its margin in the Print panel when the Show Margins icon is selected.

About This Article

About the volume author:

Greg Harvey, PhD, is president of Heed Over Media, Inc. He is the author of all editions of Excel For Dummies, Excel All-in-Ane For Dummies, Excel Workbook For Dummies, and Windows For Dummies Quick Reference. He'southward besides an experienced educator.

This article can be found in the category:

  • Excel ,