Excel 2010

Wrapping Text and Merging Cells

If a cell contains more text than can be displayed, you can choose to wrap the text within the cell or merge the cell with empty, adjoining cells. Wrap text to make it display on multiple lines of the cell. Merge cells to combine adjoining cells into one larger cell.

To Wrap Text:

1. Select the cells with text you want to wrap.
   Selecting cells
2. Select the Wrap Text command on the Home tab.
   Selecting the Wrap Text command
3. The text in the selected cells will be wrapped in your worksheet.
   Cells with wrapped text

If you change your mind, re-click the Wrap Text command to unwrap the text.

To Merge Cells Using the Merge & Center Command:

1. Select the cells you want to merge together.
   Selecting A1:D1 (A1, B1, C1, D1)
2. Select the Merge & Center command on the Home tab.
   Selecting the Merge & Center command
3. The selected cells will be merged and the text will be centered.
   A1 after merging with B1:D1

If you change your mind, re-click the Merge & Center command to unmerge the cells.

To Access More Merge Options:

Click the drop-down arrow next to the Merge & Center command on the Home tab. The merge drop-down menu appears.

• Merge & Center: Merges selected cells into one cell and centers the text.
• Merge Across: Merges each row of selected cells into larger cells. This command is useful if you are merging content across multiple rows of cells and do not want to create one large cell.
• Merge Cells: Merges selected cells into one cell.
• Unmerge Cells: Unmerges the selected cells.

Accessing more Merge options