Define what part of the worksheet to print

Try Office 2010 In Excel 2010, new user interface has been added to make printing even easier.
Watch a video or try Office 2010!

By defining a print area on a worksheet, you can control which part of the worksheet is printed and prevent columns or rows that you don’t want printed from appearing in your report.

Print a selected area of a worksheet

   
  1. On the View menu, click Page Break Preview.
  2. Select the area you want to print.
  3. On the File menu, point to Print Area, and then click Set Print Area.

When you save the document, your print area (print area: One or more ranges of cells that you designate to print when you don't want to print the entire worksheet. If a worksheet includes a print area, only the print area is printed.) selection is also saved.

Add cells to an existing print area

   
  1. On the View menu, click Page Break Preview.
  2. Select the cells you want to add to the print area.
  3. Right-click within the selection, and then click Add to Print Area.

Center worksheet data on the printed page

   
  1. Click the worksheet.
  2. On the File menu, click Page Setup, and then click the Margins tab.
  3. 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.

Clear a print area

   
  • On the File menu, point to Print Area, and click Clear Print Area.
 
 
Applies to:
Excel 2003