Define what part of the worksheet to print

On the View menu, click Page Break Preview.
Select the area you want to print.
On the File menu, point to Print Area, and then click Set Print Area.
When you save the document, your print area selection is also saved.

Click the worksheet.
On the File menu, click Page Setup, and then click the Margins tab.
To center worksheet data horizontally on the page between the left and right margins, select the Horizontally check box under Center on page.
To center worksheet data vertically on the page between the top and bottom margins, select the Vertically check box under Center on page.