How to Add a Background Image to an Excel 2007 Worksheet
Hiding and Unhiding Excel 2007 Worksheets
Previewing Excel 2007 Formatting with Live Preview

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
Applying Conditional Formatting in Excel 2007
How to Hide and Unhide Rows and Columns in Excel 2007
Applying a Table Style to an Excel 2007 Table
Renaming an Excel 2007 Worksheet
Copying Excel 2007 Formatting with Format Painter
Advertisement

Inside Dummies.com