The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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.
|