Text and Cell Alignments

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 2003 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

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

Shrink-to-Fit shrinks the text so it fits into the cell; the more text in the cell, the smaller it will appear in the cell.

Merge Cells 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 Format Cells from the menu bar.
  • The Format Cells dialog box opens.
  • Click the Alignment tab.
  • Click on either the Wrapped Text, Shrink-to-Fit, or Merge Cells check boxes—or any combination of them—as needed.
  • Click the OK button.