Specifying Margin Print Options

The Margins tab of the Page Setup dialog box allows you to set margins for your worksheet in the units of your choice. It also allows you to center your worksheet horizontally or vertically.

To set margins and page centering for the active worksheet:

1. Select File > Page Setup, then click the Margins tab, shown below.

   

2. Click Apply to see your changes or OK to accept your changes.

Note When you enter margin lengths, be aware that if the header or footer margin is larger than the top or bottom margin, the header or footer will overwrite the worksheet data on the page.