Change page margin properties on the Page Setup dialog Margins page.
Use the Margins page in the Page Setup dialog to set page margins, header and footer positions, and centering.
The Margins Page
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