Microsoft Office Tutorials and References
In Depth Information
Merging cells is a simple concept: Join two or more cells to create a larger single cell. To merge
cells, just select them and choose Home
Merge & Center. Excel combines the
selected cells and displays the contents of the upper left cell, centered.
Merging cells is usually done as a way to enhance the appearance of a worksheet. Figure 56-1, for
example, shows a worksheet with four sets of merged cells: C2:I2, J2:P2, B4:B8, and B9:B13. The
merged cells in column B also use vertical text.
Figure 56-1: This worksheet has four sets of merged cells.
Remember that merged cells can contain only one piece of information: a single value, text, or a
formula. If you attempt to merge a range of cells that contains more than one non-empty cell,
Excel prompts you with a warning that only the data in the upper leftmost cell will be retained.
To unmerge cells, just select the merged area and click the Merge and Center button again.
Notice that the Merge and Center button is a drop-down menu. If you click the arrow, you see
three additional commands:
h Merge Across: Lets you select a range and then creates multiple merged cells — one for
each row in the selection.
h Merge Cells: Works just like Merge and Center, except that the content of the upper left
cell is not centered. (It retains its original horizontal alignment.)
h Unmerge Cells: Unmerges the selected merged cell.