Microsoft KB Archive/64803

Cells Formatted with Shade Option Do Not Copy Correctly PSS ID Number: Q64803 Article last modified on 08-23-1993 PSS database name: W_eXceL

2.00 2.01 2.10 2.10c 2.10d

WINDOWS

Summary:

In Microsoft Excel for Windows version 2.10d and earlier:

If cells on a worksheet are formatted with the Shade option, when they are copied to the Clipboard as a metafile, the text or numbers in the cells will show white space rather than shading. The remainder of the cell area will retain the shading. If the cell range is copied as a bitmap, it works correctly.

More Information:

To copy an area as a metafile, do the following:


 * 1) Select the area.
 * 2) While pressing the SHIFT key, from the Edit menu choose Copy Picture.
 * 3) Select the appropriate settings.
 * 4) Release the SHIFT key.
 * 5) Select OK.

To copy an area as a bitmap, do the following:


 * 1) Select the area.
 * 2) While pressing the SHIFT key, from the Edit menu choose Copy Picture.
 * 3) Select the appropriate settings.
 * 4) While pressing the SHIFT key, select OK.

This problem was fixed in version 3.00 of Excel for Windows.

Copyright Microsoft Corporation 1993.