To automatically wrap text:
1. Type the following text into a cell: Get the Most out of Excel 2007.
2. Select Home -> Wrap Text (in Alignment Group).
Click the dialog box Launcher arrow symbol in the bottom-right corner of the Alignment Group to open the Format Cells dialog box -> Alignment tab
3. In the Alignment tab in Text control section check the Wrap text box and click OK.