Microsoft KB Archive/211821

= XL2000: "Cannot Change Part of a Merged Cell" Error When You Drag a Merged Cell Over Another Merged Cell =

Article ID: 211821

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211821





SYMPTOMS
When you drag and drop a merged cell in Microsoft Excel 2000, you may receive the following error message:

Cannot change part of a merged cell.



CAUSE
This error message occurs if either of the following conditions is true:
 * The location to which you are dragging the merged cell overlaps the original location of the merged cell.

-or-
 * The location to which you are dragging the merged cell overlaps another merged cell without completely covering it.

NOTE: If the new location of the merged cell completely covers another merged cell, the error message does not occur.



RESOLUTION
To prevent this behavior from occurring, make sure that when you drag and drop a merged cell, the new location of the merged cell does not overlap any existing merged cells without completely covering them.



MORE INFORMATION
You can merge a range of cells into a single merged cell. To do this, select the cells that you want to merge, and then perform either of the following steps:
 * On the Format menu, click Cells. On the Alignment tab, click to select the Merge cells check box, and then click OK.

-or-
 * Click the Merge and Center button on the Formatting toolbar.

Additional query words: XL2000

Keywords: kberrmsg kbprb KB211821

-

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

© Microsoft Corporation. All rights reserved.