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.

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.