Microsoft KB Archive/44397

{| = Excel: Rows and/or Columns Printing Twice on First Page =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q44397

SUMMARY
In Microsoft Excel, if the same rows and/or columns are repeated on every page of the document when a worksheet is printed, you might be using print titles. Print titles automatically print the selected rows and/or columns on every page.

For example, if the print title is set up as row 1, and if no print area is selected, page 1 will contain the print title (row 1) and row 1 of the worksheet.

To avoid repeating the rows and/or columns in a worksheet, do one of the following depending on your needs:

Method 1 -- To Use Print Titles

 * 1) Select the row and/or column headings that you want to use as print titles.
 * 2) From the Options menu, choose Set Print Titles.
 * 3) Select the area of the worksheet that you want printed; be careful not to select the rows and/or columns you selected as print titles.
 * 4) From the Options menu, choose Set Print Area.

Method 2 -- To Remove Existing Print Titles

 * 1) From the Formula menu, choose Define Name.
 * 2) Select the name Print_Title.
 * 3) Click Delete in the Define Name box.

Method 3 -- To Remove an Existing Print Area

 * 1) From the Formula menu, choose Define Name.
 * 2) Select the name Print_Area.
 * 3) Click Delete in the Define Name box.
 * }