Microsoft Knowledge Base

XL: Patterned Double Underline Printed Incorrectly in Titles
Last reviewed: August 4, 1997
Article ID: Q118980
4.00 4.00a 5.00 5.00c 7.00 7.00a | 4.00 5.00 5.00a 
WINDOWS                          | MACINTOSH
kbprint

The information in this article applies to:

  • Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 4.0, 5.0, 5.0a
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a

SYMPTOMS

In Microsoft Excel, the border for your print titles may not be printed correctly when the following conditions are true:

  • The print titles are formatted with a double-underline border.

    -and-

  • The print titles are formatted with a pattern.

    -and-

  • The formatting occurs either in the last row of the print titles or directly before a page break.

When these conditions are true, you will receive the following results when you print your document or view it in print preview:

Microsoft Excel versions 5.0, 7.0

  • The first double-underline border is printed correctly, but the following pages appear as if they have only a single-underline border.

Microsoft Excel version 4.0
  • The double-underline is printed as a single underline on all pages.

WORKAROUND

To display the double-underline border in your print titles, include a blank row without a pattern directly below the border in the print title. For example if the print title is set to include rows one through three ($1:$3), insert a blank row as row four and change the print titles to rows one through four ($1:$4).

REFERENCES

For more information about Print Titles, choose the Search button in Help and type: 

   print titles

KBCategory: kbprint
KBSubcategory:

Additional reference words: 4.00 4.00a 5.00 7.00 double-border double-
underline
shade shading
Keywords : kbprint
Version : 4.00 4.00a 5.00 5.00c 7.00 7.00a
Platform : MACINTOSH WINDOWS

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: August 4, 1997
©1997 Microsoft Corporation. All rights reserved. Legal Notices.