Excel 2013

Wrapping text and merging cells

Whenever you have too much cell content to be displayed in a single cell, you may decide to wrap the text or merge the cell rather than resizing a column. Wrapping the text will automatically modify a cell's row height, allowing cell contents to be displayed on multiple lines. Merging allows you to combine a cell with adjacent, empty cells to create one large cell.

To wrap text in cells:

In our example below, we'll wrap the text of the cells in column D so the entire address can be displayed.

1. Select the cells you wish to wrap. In this example, we'll select the cells in column D.
   
   Selecting cells to wrap
2. Select the Wrap Text command on the Home tab.
   
   Clicking the Wrap Text command
3. The text in the selected cells will be wrapped.
   
   The wrapped text

Click the Wrap Text command again to unwrap the text.

To merge cells using the Merge & Center command:

In our example below, we'll merge cell A1 with cells B1:E1 to create a title heading for our worksheet.

1. Select the cell range you want to merge together.
   
   Selecting cell range A1:E1
2. Select the Merge & Center command on the Home tab.
   
   Clicking the Merge & Center command
3. The selected cells will be merged, and the text will be centered.
   
   Cell A1 after merging with B1:E1

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 will appear. From here, you can choose to:

• Merge & Center: Merges the selected cells into one cell and centers the text
• Merge Across: Merges the selected cells into larger cells while keeping each row separate
• Merge Cells: Merges the selected cells into one cell, but does not center the text
• Unmerge Cells: Unmerges selected cells

Accessing more Merge options