Excel 2007

Aligning Text

Changing text control

Text control allows you to control the way Excel 2007 presents information in a cell. There are two common types of text control: Wrapped text and merged cells.

Wrapped Text wraps the contents of a cell across several lines if it's too large than the column width. It increases the height of the cell as well.

Text Wrap Example

Merge Cells can also be applied by using the Merge and Center button on the Home tab.

Merge Example

To change text control:

Select a cell or range of cells.
Select the Home tab.
Click the Wrap Text command or the Merge and Center command.

If you change your mind, click the drop-down arrow next to the command, then choose Unmerge cells.

1 2 3 4 5