Excel > Excel 2007 Foundation > Printing a Worksheet

Adjusting Sheet Margins and Orientation

Margins are the empty space between the worksheet data and the top, bottom, left and right edges of the page. These can be adjusted as necessary to create a larger or smaller gap between the worksheet data and the edges of the page.

There are two different types of orientation of the page. Portrait (tall and thin), the default page orientation and landscape (short and wide), which is useful for spreadsheets with many columns.

Portrait and landscape pages

Adjusting the margins

Margins in Excel 2007 are 1.9 cm (0.75 inches) from the top and bottom, and 1.8 cm (0.7 inches) to the left and right by default.

  1. Click the Page Layout tab on the Ribbon
  2. Click the Margins button from the Page Setup group
  3. Changing sheet margins
  4. Select the desired page margin settings from the list or click Custom Margins and set the measurements for each margin by adjusting the necessary list box
  5. Setting margins in page setup

Changing the page orientation

You can change the page orientation between portrait and landscape.

  1. Click the Page Layout tab on the Ribbon
  2. Click the Orientation button from the Page Setup group
  3. Changing the page orientation

  4. Select the desired page orientation

Follow us on

Facebook  Twitter  You Tube