Solutions and training for business users of Microsoft Excel.
Solutions and training for business users of Microsoft Excel.

 Excel User's Home
 ExcelUser Blog      
 Site Map              
 Contact              
 Excel for Business
 Excel Dashboards   
 Excel Solutions   
 Exploring Excel
 BI for Excel    
 Business Tools   
 Excel Catalog   
 Affiliate Program   
 Excel Help Portal  
 
   
     
   
     

Home > Exploring Excel

Two Ways to Wrap Excel Text


"I am seeking to add a second row within a cell. I am having trouble doing this. What procedure do I need to follow?" -- Patricia Z.

Patricia,

The common way to wrap text in Excel is with formatting. To do so, select the cells you want to wrap. Press Ctrl+1 to display the Format Cells dialog. In the Alignment tab, check the Wrap Text box. Then choose OK.

If you prefer to use standard commands to access the dialog...

...in Excel 2003, choose Format, Cells.

...in Excel 2007 and above, choose Home, Alignment, Wrap Text.


Another way to wrap text is to insert a carriage return in the text, forcing it to wrap in a cell. I frequently use this approach when I use two lines of text when I'm setting up a column label.

To use this approach, type the text you want in the first line, press Alt+Enter where you want the line break, then type the remaining text.

All the best,

Charley


 
 
 
 


ExcelUser, Inc.
http://www.ExcelUser.com

Copyright 2004 - 2012 by Charles W. Kyd, all rights reserved. Content, graphics, and HTML code are protected by US and International Copyright Laws, and may not be copied, reprinted, published, translated, hosted, or otherwise distributed by any means without explicit permission. Terms of Use | Privacy Policy | Earnings Policy.

Excel Dashboards

Create professional quality dashboard reports with Excel.