Setting Up Margins for Printing

Margins are the blank spaces at the top, bottom, left, and right of a printed page. Excel's default margins are typically 1 inch for the top and bottom, and 0.75 inches for the left and right. Using the Page Setup dialog box, you can easily adjust these margins.



To adjust the margins for a document:

  1. Click Page Setup... on the File menu.
  2. Click the Margins tab.
  3. Click the arrows to adjust the top, bottom, left, and right margins.
  4. The Preview box shows you which part of the page you are changing.
  5. Click OK.


Be sure to use the Print Preview button to see what your printed worksheet will look like.

The Margins tab also allows you to adjust the placement of the header and footer. Further, you can choose to horizontally and/or vertically center the information on the printed page.

In the Page Setup dialog box, you can type numbers directly in the text boxes instead of using the arrows to increase or decrease the margin values.