Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Text Manipulation > Wrapping Text< Previous | Next > 

 

Step 1 - What is Text Wrap ?

 
 

It is possible to make text wrap to multiple lines in a cell rather than appearing as one long line of text.

 

 

Now choose (Format > Cells)(Alignment tab, Wrap Text) check box, then click OK.

 
 

SS

 

 

Text entered into the selected cell automatically wraps to fit the cell. If you need to force a wrap at any given point, press Alt-Enter.

 

 

Allows you to wrap text in multiple lines with a cell. Wraps text into multiple lines in a cell. The number of wrapped lines is dependent on the width of the column and the length of the cell contents.

 
 

Text can be wrapped in a cell (Format > Cells) (Alignment tab, “Wrap text checkbox”). This will increase the row height as more text is entered. If the row height is then set to a fixed height text will not split over to adjacent cells.

 
   

 

Step 4 - Things to Remember

 


 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.< Previous | Top | Next >