Microsoft KB Archive Search

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.

  1. Home
  2. XL2000: "Cannot Change Part of a Merged Cell" Error When You Drag a Merged Cell Over Another Merged Cell

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

View products that this article applies to.

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: KB211821, kbprb, kberrmsg

↑ Back to the top

Article Info
Article ID : 211821
Revision : 5
Created on : 11/5/2003
Published on : 11/5/2003
Exists online : False
Views : 270