Gridlines missing from printed worksheet even though printing of gridlines is turned on

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q303263
This article has been archived. It is offered "as is" and will no longer be updated.
When you print a worksheet, the gridlines are missing even though printing of gridlines is turned on.
This behavior can occur if you print the worksheet in Draft mode. The gridlines in Excel worksheets are graphics, and most printers do not print graphics when printing is set to Draft mode.
To resolve this behavior, clear the Draft quality check box. To do this, follow these steps:
  1. On the File menu, click Page Setup, and then click the Sheet tab.
  2. Under Print, click to clear the Draft quality check box, and then click OK.
  3. Reprint the worksheet.
Gridlines also may not be printed if either Draft quality or a low resolution is specified on the Page tab under Page Setup.
XL2001 XL98 XL2001KB mac print quick lost line border enabled economy document layout spreadsheet

Article ID: 303263 - Last Review: 12/06/2015 03:52:20 - Revision: 2.2

Microsoft Office Excel 2003, Microsoft Excel 2002 Standard Edition, Microsoft Excel 2000 Standard Edition, Microsoft Excel 2001 for Mac, Microsoft Excel 98 for Macintosh

  • kbnosurvey kbarchive kbgraphic kbprb kbprint kbui KB303263