Microsoft KB Archive/44397

Excel: Rows and/or Columns Printing Twice on First Page 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 Select the row and/or column headings that you want to use as print titles. From the Options menu, choose Set Print Titles. 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. From the Options menu, choose Set Print Area. Method 2 -- To Remove Existing Print Titles From the Formula menu, choose Define Name. Select the name Print_Title. Click Delete in the Define Name box. Method 3 -- To Remove an Existing Print Area From the Formula menu, choose Define Name. Select the name Print_Area. Click Delete in the Define Name box.

KBCategory: kbother KBSubcategory: Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20 3.00 Last reviewed: November 2, 1994 © 1998 Microsoft Corporation. All rights reserved. Terms of Use.