Setting Up the Page

You can set up the worksheet page to print just the way you want. With the Page Setup dialog box, you can choose the page orientation , which determines whether Excel prints the worksheet data portrait (vertically) or landscape (horizontally). You can also adjust the print scaling (to reduce or enlarge the size of printed characters ), change the paper size (to match the size of paper in your printer), and resize or realign the left, right, top, and bottom margins (the blank areas along each edge of the paper). Changes made in the Page Setup dialog box are not reflected in the worksheet window. You can see them only when you preview or print the worksheet.

Change Page Orientation

Click the File menu, and then click Page Setup.

Click the Page tab.

Click the Portrait (8.5 x 11 inches) option (the default) or click the Landscape (11 x 8.5 inches) option to select page orientation.

Click OK.

Change the Margin Settings

Click the File menu, and then click Page Setup.

Click the Margins tab.

Click the Top, Bottom, Left, and Right up or down arrows to adjust the margins.

Select the Center On Page check boxes to automatically center your data.

Click OK.