You can quickly merge or unmerge a range of cells in an Excel spreadsheet. Note that when you merge several cells, only the upper-right cell value is maintained.
In this article, you will learn the steps to merge and unmerge a range of cells in an Excel worksheet.
Within a worksheet, choose the first cell in the range of cells that you want to merge, then press and hold the [Shift] key.
Example shown here: cell R2 .
From the row and column headers, select the final cell from the range of cells you want to merge, then release the [Shift] key.
Example shown here: click cell U2 then release the [Shift] key.
The selected cells are highlighted.
On the Home tab ribbon, click the Merge & Center drop-down arrow.
From the drop-down menu, click the Merge & Center option.
A dialog message is displayed, notifying you that merging cells only keeps the upper left values and discards other values.
In this example, only the R2 value would be saved.
To complete the process of merging the selected cells, click the OK button.
The selected cells are merged.
To unmerge the cells, click the Merge & Center drop-down arrow again.
Click the Unmerge Cells option.
The selected cells are unmerged.
Note: After unmerging the selected cells, you can edit the data in each cell.