Gridlines not printing as expected in Excel
When printing a workbook or worksheet, and gridlines are set to print, Excel is not printing the gridlines as expected.
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).
The workbook is printed and saved with these print settings.
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.
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).
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
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