Tip Printed from ExcelTip.com

---

Automatically Wrapping Text in a Cell in Excel 2007


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).
Or
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
Or
Press Ctrl+1.
3. In the Alignment tab in Text control section check the Wrap text box and click OK.