Aligning Text

In Excel alignment is important to be able to easily read data. Learn to format text and tables in various ways in Excel.

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:

Text Control

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