Page Setup (Worksheet) - Margins

Use the Margins page in the Page Setup dialog to set page margins, header and footer positions, and centering. Click the File | Page Setup command in the worksheet to open the Page Setup dialog.

Change page margin properties on the Page Setup dialog Margins page.

Margins

Use the Margins (inches) group to set the page margins for all sides of the printed page. Set the Left, Right, Top, and Bottom values in inches to any limits the printer will allow. The margins are for the worksheet printout and are independent of the settings used for Headers or Footers.

Center on Page

The Center on Page group options automatically center the printout Horizontally, Vertically, or both. If neither option is selected, the worksheet prints in the upper left corner of the page.

From Edge (inches)

Headers and Footers are the only items that print outside of the margins. The From Edge (inches) group options controls how far the Header or Footer is printed from the edge of the page. If these values are greater than the Top or Bottom margins, it is possible that the worksheet data can print over the header or footer. The text that is printed for the header and footer is controlled on the Options page.

Printer

The active printer can be changed by clicking the Printer button at the bottom of the Page Setup dialog.

See Also

Page

Options

File | Page Setup