Microsoft KB Archive/102955

Microsoft Knowledge Base

Excel: Print Titles for Columns Print Twice on First Page

Last reviewed: September 12, 1996
Article ID: Q102955

The information in this article applies to:

• Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a
• Microsoft Excel for OS/2, version 2.2, 3.0
• Microsoft Excel for the Macintosh, version 2.x, 3.0, 4.0

SYMPTOMS

When you use the Print Titles feature in Microsoft Excel, the resulting printout may show the print titles for the columns printed twice on the first page of the worksheet.

In the case where the print titles are located lower down on the first page, they may print at the top of the page as well. If the print titles are at the top of the page, they may be printed twice in a row.

CAUSE

The print titles are being printed the first time because they are the print titles; they are printed the second time because they are part of the defaulted print area.

The following is an explanation of this behavior for various versions of Microsoft Excel.

Version 4.0

Print Titles Printed Twice:

Page 534 of the "User's Guide 1," version 4.0, states:

   The print titles will first print in the range in which they appear
   on the worksheet. They will print at the top of each subsequent
   page.

However, print titles will be printed twice on the first page in the following situation:

• Print_Titles are defined as rows other than the first row or rows, and the Print_Area is defined to include the rows contained in the Print_Titles. (Similar to behavior in Microsoft Excel 2.x, 3.0.)

Print Titles NOT Printed Twice:

In Microsoft Excel, version 4.0, the print titles will NOT be printed twice on the first page in either of the following situations:

• Print_Titles are defined (no matter which rows), but no Print_Area is defined. -or-
• Print_Titles are defined as the first row or rows, and any Print_Area is defined. (Similar to behavior in Microsoft Excel 3.0.)

Version 3.0

Print Titles Printed Twice:

In Microsoft Excel, version 3.0, the print titles will be printed twice on the first page in either of the following situations:

• Print_Titles are defined (no matter which rows), but no Print_Area is defined. (Similar to behavior in Microsoft Excel 2.x.) -or-
• Print_Titles are defined as rows other than the first row or rows, and the Print_Area is defined to include the rows contained in the Print_Titles. (Similar to behavior in Microsoft Excel 2.x, 4.0.)

Print Titles NOT Printed Twice:

In Microsoft Excel, version 3.0, the print titles will NOT be printed twice on the first page in the following situation:

• Print_Titles are defined as the first row or rows, and any Print_Area is defined. (Similar to behavior in Microsoft Excel 4.0.)

Versions 2.x

Print Titles Printed Twice:

In Microsoft Excel, versions 2.x, the print titles will be printed twice on the first page in either of the following situations:

• Print_Titles are defined (no matter which rows), but no Print_Area is defined. (Similar to behavior in Microsoft Excel 3.0.) -or-
• Print_Titles are defined (no matter which rows), and the Print_Area is defined to include the rows contained in the Print_Titles.

Print Titles NOT Printed Twice:

In Microsoft Excel, versions 2.x, the print titles will NOT be printed twice on the first page in this situation:

• Print_Titles are defined as the first row or rows, and the Print_Area is defined to exclude the rows contained in the Print_Titles.

WORKAROUNDS

Workaround for Print Titles NOT in the First Row or Rows

Version 4.0:

Follow the methods provided for versions 2.x and 3.0 below, or do the following:

1. Select the entire worksheet by pressing CTRL+SHIFT+SPACEBAR (in Windows), or COMMAND+A (on the Macintosh).
2. Remove the print area by choosing Remove Print Area from the Options menu.
3. Print the worksheet.

Versions 2.x and 3.0:

1. Print the entire worksheet, except for page one, by choosing Print from the File menu and specifying Pages Starting From 2.
2. Select the entire worksheet by pressing CTRL+SHIFT+SPACEBAR (in OS/2 or Windows), or COMMAND+A (on the Macintosh).
3. Remove the Print Titles by choosing Remove Print Titles from the Options menu.
4. Set a new print area for the first page only, or select Print from the File menu and specify Pages From 1 To 1.
5. Print the first page.

Workaround for Print Titles Defined as First Row or Rows

Version 3.0:

Follow the method provided for version 2.x below, or do the following:

1. Set a print area by choosing Set Print Area from the Options menu. The print area you select may contain the rows of your print titles.
2. Print the worksheet.

Versions 2.x:

1. Select everything you want printed, except what you have set as the print titles.
2. Set the print area by choosing Set Print Area from the Options menu.
3. Print the entire worksheet.

REFERENCES

"User's Guide 1," version 4.0, pages 533-534 "User's Guide," version 3.0, pages 533-534

KBCategory: kbprint KBSubcategory: Additional reference words: 2.00 2.01 2.10 2.20 2.21 3.00 4.00 4.00a double twice THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Last reviewed: September 12, 1996 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.