XL98: Error Dragging Merged Cell Over Another Merged Cell

• Microsoft Excel 98 Macintosh Edition

SYMPTOMS

When you drag and drop a merged cell in Microsoft Excel 98 Macintosh Edition, you may receive the following error message:

   Cannot change part of a merged cell.

CAUSE

This problem 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.

RESOLUTION

To prevent this problem 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.

STATUS

This behavior is by design of Microsoft Excel 98 Macintosh Edition.

MORE INFORMATION

Microsoft Excel 98 Macintosh Edition includes a new feature that enables you to merge a range of cells into a single, merged cell. To use this feature, select the cells that you want to merge, and then perform either of the following steps:

• On the Format menu, click Cells. Click the Alignment tab. Click to select the Merge Cells check box, and then click OK.

      -or-
  

• Click the Merge And Center tool on the Formatting toolbar.