ARCHIVED: In Microsoft Excel, how do I adjust the page margins on a printed spreadsheet?

This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.

To adjust the page margins on a printed spreadsheet in Excel, you can use several different methods.

Excel 2010

  • Use the File menu:
    1. From the File menu, select Print.
    2. Under "Settings", select the Normal Margins drop-down menu.
    3. Choose a different pre-set option, or select Custom Margins..., adjust the values for each margin that you want to change, and click OK.

  • Use the Page Layout tab:
    1. On the Page Layout tab, click Margins, and then select Custom Margins....
    2. Use the arrows to increase or decrease the margin sizes, or enter the desired size in the appropriate box. When you're done, click OK.

  • Select your data:
    1. Highlight the area of your spreadsheet that you want to print.
    2. Click the Page Layout tab.
    3. Click Print Area, and choose Set Print Area.

Excel 2007

  • Use the Page Layout tab:
    1. On the Page Layout tab, click Margins, and then select Custom Margins....
    2. Use the arrows to increase or decrease the margin sizes, or enter the desired size in the appropriate box. When you're done, click OK.

  • Adjust the margins graphically:
    1. In the upper left, click the Office Button.
    2. Select Print, and then Print Preview.
    3. Check Show margins, and then drag the margins to the desired size.

  • Select your data:
    1. Highlight the area of your spreadsheet that you want to print.
    2. Click the Page Layout tab.
    3. Click Print Area, and choose Set Print Area.

Excel 2003

  • Use the Page Setup option:
    1. From the File menu, select Page Setup.
    2. Select the Margins tab. You can then enter the desired margin sizes.

  • Adjust the margins graphically:
    1. From the File menu, select Print Preview.
    2. In the Preview window, click Margins. You can move the margins manually with the mouse by dragging the handles.

This is document abhn in the Knowledge Base.
Last modified on 2018-01-18 10:47:57.

Contact us

For help or to comment, email the UITS Support Center.