Text and Cell Alignments

In Excel XP 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 XP presents information in a cell. There are three types of text control: wrapped text, shrink to fit, and merge cells.

Examples of Text Control Alignments

The wrapped text feature wraps the contents of a cell across several lines if it's too large than the column width. It also increases the height of the cell.

The shrink-to-fit feature shrinks the text so it fits into the cell; the more text in the cell, the smaller it will appear in the cell.

The merge cells feature can also be applied by using the Merge button Merge and Center button on the Standard toolbar.

To change text control using the Format Cells dialog box:

  • Select a cell or range of cells.
  • Choose FormatCells from the menu bar.
  • The Format Cells dialog box opens.
  • Click the Alignment tab.
  • Click the Wrapped Text, Shrink-to-Fit, or Merge Cells check boxes—or any combination of them—as needed.
  • Click OK.