Contents of Cells Show Through Objects with HP Printers (68269)
The information in this article applies to:
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for Windows 4.0c
- Microsoft Excel for Windows 3.0a
- the operating system: Microsoft Windows 3.1
- the operating system: Microsoft Windows 3.0
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.
Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
---|
Keywords: | KB68269 |
---|
|