![how do i merge and center in excel 2010 how do i merge and center in excel 2010](https://cdn.ablebits.com/_img-blog/unmerge-cells/unmerge-cells-excel.png)
To unmerge all cells on the sheet, you do the following:
#How do i merge and center in excel 2010 how to
How to split all merged cells in a worksheetĪt first sight, the task may seem cumbersome, but in fact it takes only a couple of mouse clicks. The contents of each merged cell will be placed into the upper-left cell, other unmerged cells will be empty: Or, click the drop-down arrow next to the Merge & Center button and select Unmerge Cells.Įither way, Excel will unmerge all the merged cells in the selection. On the Home tab, in the Alignment group, click Merge & Center.Select one or more cells you want to unmerge.Split the contents of the merged cell across several cells.Unmerge cells and fill each cell with the original value.How to unmerge all merged cells in a worksheet.Well, how do you unmerge cells in Excel to get things back to normal? Below, you will find a few simple techniques. Filtering or even selecting a range might also be a problem. For example, you cannot sort data in columns that have at least one merged cell. So, you merge a few smaller cells into a bigger one only to realize that merged cells have made it impossible to perform the simplest tasks on your worksheet. When you have related data in several cells, you may be tempted to combine them into a single cell for alignment or comparison purposes. This short tutorial shows how to quickly unmerge cells in Excel, how to find all merged cells in a worksheet, and how to fill each unmerged cell with the original value from the merged cell.