How To Unmerge Cells In Excel. You will know when you have selected a group of merged cells when you see the row and column numbers change color. Unmerge Cells and Copy the Original Value to Each Unmerged Cell.
A video explanation on how to unmerge cells in Microsoft Excel. Click on the cell group you wish to unmerge. So the shortcut to unmerge cells is Alt- H- M- U.
Select the columns that have merged cells.
Being able to merge and unmerge cells greatly improves reporting and presentation. See also this tip in French. Similarly you can click the arrow next to Merge and Center to access the drop-down menu and then click Unmerge Cells. Click the triangle to the right of the Merge Center button.