Microsoft KB Archive/68269

= Contents of Cells Show Through Objects with HP Printers =

Article ID: 68269

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0c
 * Microsoft Excel 4.0c
 * Microsoft Excel 3.0a
 * Microsoft Windows 3.1 Standard Edition
 * Microsoft Windows 3.0 Standard Edition

-



This article was previously published under Q68269



SUMMARY
When an object is placed on top of a cell that contains information, the contents of the cell will show (bleed) through when the worksheet is printed from a Hewlett-Packard (HP) printer. The object will block the gridlines but the cell contents or data will print over the object. Print preview appears correctly.

This is due to the way that the HP Printer Control Language (PCL) is written (any printer driver using PCL will display this way).

Workarounds
There are several ways to work around this problem. If the cells are formatted using Modern, Roman, or Script, text does not bleed through. If you format the text as white, the text will not display.

There is also another workaround available. If you have Adobe Type Manager (ATM) fonts version 1.1 or Bitstream fonts version 1.2, you can format the cells with one of the ATM or Bitstream fonts to prevent the text from bleeding through.

You can also avoid the problem if you are using an HP Laserjet IIP, by setting true-type as graphics which also prints the text box as an opaque box.

An alternate workaround is to use a TrueType font and print TrueType as Graphics. From the File menu choose Page Setup. From the Page Setup dialog, choose Printer Setup, then choose Setup and then Options. Select Print TrueType as Graphics.

Keywords: KB68269

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.