You can change a row’s height or a column’s width, but this might not be the best way to improve your worksheet’s usability. For instance, a label might not fit within a single cell, and increasing that cell’s width, or every cell’s width, might throw off the worksheet’s design. One solution to this problem is to merge two or more cells. Merging cells allows you to treat a group of cells as a single cell as far as content and formatting go.
Merge Several Cells into One
Select the cells you want to merge.
Click the Home tab.
In the Alignment group, click the Merge And Center button.
Split a Merged Cell
Click the merged cell.
Click the Home tab.
Click the down arrow at the right edge of the Merge And Center button.
Click Split Cells.
Caution
If the cells you selected have data in more than one cell, only the data in the upper-left cell will remain after you merge the cells.
Tip
If you do not want the merged data centered, click a different alignment from the Alignment group on the Home tab.