Microsoft KB Archive/119271

{|
 * width="100%"|

Excel: Gridlines Not Displayed in Picture of Copied Cells

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0

-

SYMPTOMS
When you copy a range of cells as a picture (hold down the SHIFT key and choose Copy Picture from the Edit menu), the gridlines in the pasted picture may not be displayed on your screen (this problem also occurs in print preview). This problem occurs even when the Gridlines option is selected in the Page Setup dialog box.

Note that even though the gridlines are not displayed correctly on the screen, they are visible in the printed document.

CAUSE
This behavior occurs because Microsoft Windows cannot handle lines in metafiles if the lines are a quarter of the width of a screen pixel.

WORKAROUND
To see the gridlines, resize the pasted picture.

STATUS
This behavior is by design of Microsoft Excel and Microsoft Windows.