Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/174239

From BetaArchive Wiki
Knowledge Base

Article ID: 174239

Article Last Modified on 9/7/2001


  • Microsoft Excel 97 Standard Edition
  • Microsoft Windows 95

This article was previously published under Q174239


When you print a worksheet in Microsoft Excel 97, drawing objects and AutoShapes that are filled with a diagonal gradient fill may be printed incorrectly. Specifically, the gradient fill may "bleed," or appear outside of the drawing object or AutoShape.


This problem may occur when the following conditions are true:

  • You are printing to a non-PostScript printer that uses Printer Command Language version 5.0 (PCL5). These printers include the following:

    Hewlett-Packard LaserJet 4M
    Hewlett-Packard LaserJet 5Si
    Lexmark LaserPrinter 4039


  • You are using Microsoft Windows 95. -and-

  • The printer driver is configured to print in vector mode.

Note that this problem does not occur when you print to PostScript printers, when you print to printers that do not use PCL5, or when you print an object that is filled with a nondiagonal gradient fill.


You can work around this problem by changing the default print mode to raster mode. To do this, follow these steps:

  1. Save your work and quit any running programs.
  2. On the Start menu, point to Settings, and click Printers.
  3. In the list of printers, right-click the printer driver for the printer. On the shortcut menu, click Properties.
  4. Click the Graphics tab.
  5. Click Use Raster Graphics.
  6. Click OK.

To print a single document in raster mode, follow these steps:

  1. Switch to the document that you want to print.
  2. On the File menu, click Print. Then, click Properties.
  3. Click the Graphics tab.
  4. Click Use Raster Graphics.
  5. Click OK. Then, click OK again to print the document.

Note that if you print in raster mode, text or other objects behind the AutoShape may appear through the AutoShape. For this reason, do not use this workaround if text or other objects are behind the AutoShape.

Note that you may also be able to prevent this problem from occurring by installing a newer version of the printer driver for your printer if one is available. To determine whether a driver is available, contact the printer manufacturer.


This problem occurs when you use Microsoft Excel 97 and you print objects that are filled with a diagonal gradient fill to a printer that uses PCL5. This problem no longer occurs in Microsoft Excel 2000.


In Microsoft Excel 97, you can fill a drawing object or AutoShape with a gradient fill. To do this, follow these steps:

  1. Click to select the object. On the Format menu, click Object or AutoShape.
  2. Click the Colors And Lines tab. Under the Fill section, click Fill Effects in the Color box.
  3. Click the Gradient tab.
  4. Under Colors, click one or two colors. Under Shading Styles, click one of the six options (Horizontal, Vertical, Diagonal Up, Diagonal Down, From Corner, or From Center). When you are done, click OK.
  5. Click OK again.

The AutoShape is filled with a gradient fill.

If you fill an AutoShape with diagonal fill, the problem described in the "Symptoms" section in this article may occur when you print the worksheet or chart that contains the AutoShape. The workaround in this article may prevent the problem from occurring; however, it may cause another problem if text or another object is behind the AutoShape.

For more information about printing problems in Microsoft Excel 97, please see the following article in the Microsoft Knowledge Base:

159227 XL97: Drawing Objects and AutoShapes Printed Incorrectly

Additional query words: XL97

Keywords: kbprint KB174239