Excel 2003
Text and Cell Alignments
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.
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 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.
