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.

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. 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

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. Select the desired page orientation

Add a header and footer Adjusting size and scale

Guides