XL97: Copy Picture Loses Lower-Right Pixel of Gridline (169248)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
This article was previously published under Q169248

SYMPTOMS

When you paste a picture of a copied cell, the picture of the cell appears to be missing the lower-right pixel.

CAUSE

This problem occurs when the following conditions are true:
  • You click a cell in a series of cells. -and-

  • You hold down SHIFT, click Copy Picture on the Edit menu, and then click to select "As shown on screen" and Picure. -and-

  • You paste the cell on the worksheet.

RESOLUTION

To resolve this problem, change the gridline color before you copy the cell. To change the gridline color, use the following steps:

  1. On the Tools menu, click Options.
  2. In the Options dialog box, click the View tab. On the View tab, change the gridline color by clicking a color in the Color list.

    The color black generally works well and prevents the problem.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

In Microsoft Excel, you can create a picture of a chart, cells, or an object. Cell gridlines appear in the picture if they are displayed. To omit gridlines, click Options on the Tools menu, click the View tab, and then clear the Gridlines check box. For example, use the following steps:
  1. On the worksheet or chart sheet, select the cells or click the chart or object you want to copy as a picture.
  2. Hold down SHIFT and click Copy Picture on the Edit menu.
  3. For the best picture quality, click to select "As shown on screen" and Picture, and then click OK.
  4. Click the worksheet or other document in which you want to paste the picture.
  5. Click Paste.
NOTE: To paste information you copied from another program as a picture in Microsoft Excel, hold down SHIFT and click Paste Picture or Paste Picture Link on the Edit menu.
Modification Type:MajorLast Reviewed:10/22/2000
Keywords:kbprb kbui KB169248
©2002 Microsoft Corporation. All rights reserved.