How to merge cells in excel

Merging Cells

Select the range of cells to merge. Click in the first cell, hold down the mouse button while moving the mouse over or down to the last cell to be merged, and then release. On the Home tab, click "Merge & Center" in the Alignment group if you would like to center information such as a title or heading in the merged cells. If centering is not desired, click on the Merge & Center down arrow and select "Merge Cells."

Remember, Excel only keeps the value in the upper-left cell and deletes all other values.

Unmerging Cells

To unmerge the cells, place the cursor in the merged cell, click the "Merge & Center" down arrow and select "Unmerge Cells." The cells return to the single-cell format, but if Merge & Center was initially selected, the centering formatting remains. To return to the left-aligned, original formatting, place the cursor in the relevant cell and select the "Align Text Left" icon in the Alignment group on the Home tab.