Microsoft® Office Excel® 2007 Plain & Simple

Merging or Splitting Cells or Data

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

1. Select the cells you want to merge.

2. Click the Home tab.

3. In the Alignment group, click the Merge And Center button.

Split a Merged Cell ...