Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Gridlines missing from printed worksheet even though printing of gridlines is turned on

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

View products that this article applies to.

Symptoms

When you print a worksheet, the gridlines are missing even though printing of gridlines is turned on.

↑ Back to the top

Cause

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.

↑ Back to the top

Resolution

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.

↑ Back to the top

More information

Gridlines also may not be printed if either Draft quality or a low resolution is specified on the Page tab under Page Setup.

↑ Back to the top

Keywords: KB303263, kbui, kbprint, kbprb, kbgraphic

↑ Back to the top

Article Info
Article ID : 303263
Revision : 4
Created on : 1/31/2007
Published on : 1/31/2007
Exists online : False
Views : 277