Microsoft KB Archive/287102

= Data in target cells is lost when you use the &quot;Paste Special&quot; command in Excel =

Article ID: 287102

Article Last Modified on 1/10/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q287102





SYMPTOMS
When you use the Paste Special command in Microsoft Excel to copy column widths or validation criteria, the data in the target cells may be lost.



CAUSE
This problem occurs if the following conditions are true:
 * You select and copy cells that are not a continuous range.
 * You use the Paste Special command with either the Validation or Column Widths option.



WORKAROUND
To work around this problem, select a continuous range of cells rather than selecting discontinuous cells as a group, or select the cells individually and then copy them and use the Paste Special options.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
This problem occurs only when you use the two Paste Special options Validation and Column widths, and only when you select a group of cells that form a discontinuous group by pressing CTRL while you select them. It does not occur with other Paste Special options, nor when you select a continuous range of cells.

Additional query words: XL2002 contiguous discontiguous noncontiguous noncontinuous blocks ranges XL2003 XL2007

Keywords: kbexpertisebeginner kbbug kbpending KB287102

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.