Excel: Rows and/or Columns Printing Twice on First Page

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.