XL97: Copy Picture Loses Lower-Right Pixel of Gridline

• Microsoft Excel 97 for Windows

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. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

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.