Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Data in target cells is lost when you use the "Paste Special" command in Excel


View products that this article applies to.

This article was previously published under Q287102

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


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.

↑ Back to the top


Keywords: KB287102, kbpending, kbbug, kbexpertisebeginner

↑ Back to the top

Article Info
Article ID : 287102
Revision : 3
Created on : 1/10/2007
Published on : 1/10/2007
Exists online : False
Views : 266