Excel: Broken Cell Border with Copy Picture As Printed Option

 Last reviewed: September 13, 1996
Article ID: Q114322
The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0
  • Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Excel, when you use the Copy Picture command to copy a cell that has an Automatic color border applied, and you choose the As Shown When Printed Appearance option, the pasted cell has a broken or dashed border, and does not display in color.

CAUSE

This behavior occurs when your Window Text color in Microsoft Windows is a light color, such as Cyan. This behavior does not occur when you format a cell with a light color border.

WORKAROUND

To work around this problem, do either of the following: 

  - Use a PostScript printer driver.

   -or-
  • To display a cell border as a solid line and in color when you use the Copy Picture command with the As Shown When Printed option, do either of the following before you use the Copy Picture command: 

        - Format the cell border for a color other than Automatic.


          -or-


        - Change your Window Text color in Windows to a darker color, such as
      Blue.

    NOTE: The dashed border problem does not occur in Microsoft Excel versions 5.0 and 7.0, although the pasted object in this case still does not appear in color.

    • KBCategory: kbdisplay kbprb
    KBSubcategory: xlwin

    Additional reference words: 3.00 4.00 4.00a 5.00



    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 13, 1996
    © 1998 Microsoft Corporation. All rights reserved. Terms of Use.