Any text in the cell will move to the first row and column of the previously merged cells. Click on the 'Alignment' tab, if necessary, and then uncheck the box next to 'Merge Cells'.The information below describes how you can access that menu. In the screenshot above, it shows rows 1 - 2 and columns A - U selected. You will know when you have selected a group of merged cells when you see the row and column numbers change color. Click on the cell group you wish to unmerge.
The second method to unmerge cells in Microsoft Excel involves the 'Format Cells' menu, which can be accessed multiple ways. A screenshot showing how to unmerge cells using the 'Format Cells' menu.ĭavid Livermore Using the Format Cells Menu to Unmerge Cells in Excel
