Saturday, August 18, 2012

How to Use Text Wrap in Excel


1. Open a new workbook in Excel by choosing 'File,' and then 'Page Setup.'
2. Select the small square at the top left corner of the screen of the new page. This highlights the entire workbook for formatting. If you want to format only a single cell, select that cell and continue with Step 3.
3. Right-click your mouse and select 'Format Cells,' 'Alignment' and then click the 'Wrap Text' box listed under 'Text Control.'
4. Resize the width of any Excel columns as necessary. Type in the text you need into each column of the spreadsheet. Whenever you get to the right margin of a particular cell, your text will wrap to the next line and continue to do so until you finish typing in that cell. Note that wrapped text automatically adjusts the row height of the cell.

Blogger news