Previewing Pages in Excel 2007 with Print Preview
Selecting a Printer in Excel 2007
How to Repeat Row and Column Headings When You Print in Excel 2007

How to Change the Print Margins in Excel 2007

Print margins indicate how much white space Excel 2007 places between the worksheet data and the edge of the page. The Normal margin settings that Excel applies to a new workbook use top and bottom margins of 0.75 inches and left and right margins of 0.7 inches. You also 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 addition to the Normal margin settings, Excel enables you to select two other standard margins from the Margins button’s drop-down 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 top and bottom margins.

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

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

You also can manually adjust the margins of a report either from the Margins tab of the Page Setup dialog box or by dragging the margin markers in the Print Preview window. 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.

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

  1. On the Page Layout tab, click the Custom Margins command on the Margins drop-down menu or click the Page Setup dialog box launcher.

    The Page 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, Bottom, Left, and Right text boxes.

    You also can use the spin buttons to change the margin settings in small increments.

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

  5. Click OK.

You can click the Print Preview button in the Page Setup dialog box at any time to see how the changes you make affect the preview of your report.

If you select the Show Margins check box on the Print Preview tab in the Print Preview window, you can modify the margins. 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 in the appropriate direction. When you release the mouse button, Excel redraws the page, using the new margin setting.

Drag a marker to adjust its margin in the Page Preview window when the Show Margins check box is se
Drag a marker to adjust its margin in the Page Preview window when the Show Margins check box is selected.
  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Adding a Standard Header or Footer in Excel 2007
How to Use Excel 2007’s Scale to Fit Printing Options
Printing Gridlines and Row and Column Headings in Excel 2007
Adjusting Page Breaks in Excel 2007
Printing a Worksheet in Excel 2007
Advertisement

Inside Dummies.com