Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
XL2000: Cells in a Protected Worksheet May Become Unmerged
Article ID: 211710 - View products that this article applies to.
This article was previously published under Q211710
In Microsoft Excel, if you cut and paste or drag a range of cells from one worksheet to another worksheet, you may receive the following error message:
When you click OK, merged cells in the destination worksheet may become unmerged. If you click the Edit menu, you cannot undo the operation.
The cell or chart you are trying to change is protected and therefore read-only.
To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (Tools menu, Protection submenu). You may be prompted for a password.
This problem occurs if the following conditions are true:
To work around this problem, use either of the following methods.
Method 1Manually merge the unmerged cells. To do this, select the cells and either click Merge and Center on the Formatting toolbar or click to select the Merge cells check box on the Alignment tab of the Format Cells dialog box.
Method 2Close the destination workbook without saving it, and then reopen the workbook.
WARNING: Use this method with caution because you may lose other changes to the workbook.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.