View your worksheet in Print Preview mode. If the data in your worksheet appears toward the top or on the far left of the page, click the Setup button.
Click the Margins tab in the Page Setup dialog box, and then click the Horizontally and/or Vertically check boxes in the Center on Page area.
Click OK.
Your worksheet appears in Print Preview mode, centered.
INTRODUCTION
If you want a cleaner, more professional-looking printout for a presentation, you can center your worksheet data on the page before you print it. This is a particularly good idea if you plan to print your worksheet on one page.
TIP
Centering Vertically or Horizontally
You don't have to center your data both vertically and horizontally. You can choose one or the other, depending on how you want your printed worksheet to look.