Page 57 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

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 resize 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:

1. Select the cells you want to wrap. In this example, we'll select the cells in column C.

2. Click the Wrap Text command on the Home tab.

TIP
Wrapping the text will
automatically modify a
cell's row height,

3. The text in the selected cells will be wrapped.

Click the Wrap Text command again to unwrap the text.

48 | P a g e