MrExcel Publishing
Your One Stop for Excel Tips & Solutions

UNmerge cells

Posted by philipsmith on December 12, 2001 1:24 PM

Can someone please advise me how to UNmerge cells that have been "merged & centred" from the toolbar

Posted by Dan on December 12, 2001 1:27 PM

right-click on the cell, choose Format Cell, uncheck Merge Cells on the alignment tab.

Posted by Michael on December 12, 2001 1:28 PM

The easiest way is to select the merged cell, right click, go to format cells -> alignment -> and under the text control, de-select the merge cell check box.

Posted by Aladin Akyurek on December 12, 2001 1:29 PM

Activate merged cells that you want to unmerge.
Activate Format|Cells.
Uncheck Merged Cells under Text Control on the Alignment tab.