Define what part of the worksheet to print

Microsoft Office Excel 2003

previous page next page
  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 selection is also saved.

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

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

ShowClear a print area

  • On the File menu, point to Print Area, and click Clear Print Area.
previous page start next page