Gridlines not printing as expected in Excel

Symptoms
When printing a workbook or worksheet, and gridlines are set to print, Excel is not printing the gridlines as expected.

Cause
This is seen in the following scenario:

The default printer driver with a Universal Printer Driver connected to a printer that is capable and set to a high resolution setting (e.g. 1200 dpi).

AND

The workbook is printed and saved with these print settings.

AND

From the same system, or another system, using the same Universal Printer Driver, but connected to a different printer, which has a lower resolution capability (e.g. 600 dpi) the workbook is then printed to this printer.
Resolution
Option 1: Prior to printing the workbook or worksheet, open the printing preferences, and select the printer properties option. Within the printer properties, set the print quality to 600 dpi, and save the file to retain the 600 dpi setting for future printing.

Option 2: Install and load the model-specific driver for the printer rather than the Universal Printer Driver. (Example: When printing from an HP Laserjet 4020, install and use the Laserjet 4020 printer driver, not the Universal Printer Driver)

Option 3: Print to a printer that is 1200 dpi capable if using a Universal Printer Driver (e.g. HP LaserJet 9040). 


More information
Microsoft is aware of this issue. When saving the file, Excel stores printer related information within the workbook.  This cached information is then compared to the client’s default printer information when the workbook is printed.  If the information is different, Excel will use the client’s default printer information. 

However, in the scenario described above, since the same Universal Printer Driver is being used in both cases, Excel does not consider the lower resolution printer to be different, and as such uses the cached information when printing the workbook.  This results in the workbook being printed at a higher resolution than the printer supports and this leads to the issue described within the Symptoms section.

HP, UPD, Universal Printer Driver, Hewlett Packard, Excel, Gridlines
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 2893418 - Last Review: 09/23/2015 08:59:00 - Revision: 4.0

Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Office Excel 2007, Excel 2016

  • kbprint KB2893418
Feedback