Microsoft KB Archive/169248: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - """ to """)
 
Line 55: Line 55:
<br />
<br />


* You hold down SHIFT, click Copy Picture on the Edit menu, and then click to select &quot;As shown on screen&quot; and Picure. -and-<br />
* You hold down SHIFT, click Copy Picture on the Edit menu, and then click to select "As shown on screen" and Picure. -and-<br />
<br />
<br />


Line 90: Line 90:
# On the worksheet or chart sheet, select the cells or click the chart or object you want to copy as a picture.
# On the worksheet or chart sheet, select the cells or click the chart or object you want to copy as a picture.
# Hold down SHIFT and click Copy Picture on the Edit menu.
# Hold down SHIFT and click Copy Picture on the Edit menu.
# For the best picture quality, click to select &quot;As shown on screen&quot; and Picture, and then click OK.
# For the best picture quality, click to select "As shown on screen" and Picture, and then click OK.
# Click the worksheet or other document in which you want to paste the picture.
# Click the worksheet or other document in which you want to paste the picture.
# Click Paste.
# Click Paste.

Latest revision as of 10:04, 21 July 2020

Knowledge Base


Article ID: 169248

Article Last Modified on 10/22/2000



APPLIES TO

  • Microsoft Excel 97 Standard Edition



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.


Additional query words: bottom XL97 drops disappear

Keywords: kbui kbprb KB169248