Forums Home

Thread Tools Display Modes
Old 28-Sep-2010, 9:33 am   #1
FaultWire's Avatar
Join Date: Mar 2008
Posts: 14,386
Invalid Microsoft Excel - Cannot change part of a merged cell. This ...

Dialog text:
Cannot change part of a merged cell.

This message appears when you try to:
Paste a mismatched range of cells into a merged cell. For example, if you merge eight cells and try to paste a range of six cells onto the merged cell, the alert appears. To fix this problem, copy and paste a range of cells that matches the size of the merged cell.
Cut or delete a row or column that includes a merged cell.
Clear the contents of a row or column that includes a merged cell.
Apply a filter to a column containing a merged cell, and then try to delete the merged cell.
To fix problems with cutting or deleting, split the merged cell and repeat the cut, delete, or clear operation. To split merged cells:
Locate and select the merged cell.
On the Formatting toolbar, click Merge and Center.
On the Format menu, click Cells, click the Alignment tab, clear the Merge cells check box, and then click OK.
Note When you split a merged cell, Excel writes the data from the merged cell into the upper-left split cell and leaves the adjoining split cells blank.

Issued by: Microsoft Office 2003
Vendor: Microsoft Corporation

Jump to the FaultWire page for Solutions and Fixes for this topic...

FaultWire is offline   Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -7. This page opened at 6:23 am.

  Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2016, Jelsoft Enterprises Ltd.