August 8, 2008

Wrapping Text

For multiple line entries of labels, comments, notes, or descriptions in Microsoft Excel, select the cells (or an entire row or column), choose Format > Cells, pick the Alignment Tab, and check the option for Wrap Text, finish with OK. The column width will determine how many lines are needed to display the text. Choose this over multiple rows for lengthy text entries for greater readability and for any lists of data.

Once text is formatted to enable wrapping, you can further control the layout by pressing [Alt] + [Enter] to force a line break within the same cell.

Entry Filed under: MS Excel Tricks & Tips. .

Leave a Comment

Required

Required, hidden

Some HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Trackback this post  |  Subscribe to the comments via RSS Feed


Categories

Recent Posts

Pages

 

August 2008
M T W T F S S
« Dec    
 123
45678910
11121314151617
18192021222324
25262728293031

Spam Blocked