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. .
Trackback this post | Subscribe to the comments via RSS Feed