Adjust Page Settings

Before you print a worksheet, you can change page layout settings such as page margins, page orientation, paper size and specify whether gridlines and headings should be printed in a worksheet.

Set Page Margins

1. Click a worksheet for which you wish to set the page margins.

2. In the Page Setup group within the Page Layout tab, click the Margins button and select the margin sizes to be set for the current worksheet.

   

Set Page Orientation

1. Click a worksheet for which you wish to specify page orientation.

2. In the Page Setup group within the Page Layout tab, click the Orientation button and select Portrait or Landscape from the invoked drop-down list.

   

Change Paper Size

1. Click a worksheet for which you wish to set the paper size.

2. In the Page Setup group within the Page Layout tab, click the Size button and select one of the predefined paper sizes from the invoked drop-down list.

   

Print Gridlines and Headings

1. Click a worksheet for which you wish to print gridlines and/or headings.

2. In the Print group within the Page Layout tab, select the Gridlines and/or Headings check boxes.