How to Use Text Wrap in Excel

Use Excel to create a report in spreadsheet form. You may need to make the text wrap around within a single cell or in all of the cells on the page. You can create your spreadsheet once you know the rules for wrapping text in Excel.

Things You'll Need

• Microsoft Excel

Instructions

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.

Tips & Warnings

• In the event the row does not automatically adjust the height, you must do it manually by clicking on the bottom margin of the cell and moving it down with your mouse. The "AutoFit" feature doesn't always automatically adjust the height after text wrapping.