Text wrapping in excel

What is wrap text?

Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break. There are two ways of entering multiple line of text.

  1. Wrap text automatically
  2. Enter a line break (Manual)

 

Wrap text automatically

  1. In a worksheet, select the cells that you want to format.
  2. On the Home tab, in the Alignment group, click Wrap Text.

Notes
– Data in the cell wraps to fit the column width, so if you change the column width, data wrapping adjusts automatically.
– If all wrapped text is not visible, it may be because the row is set to a specific height or that the text is in a range of cells that has been merged.

 

Adjust the row height to make all wrapped text visible
  1. Select the cell or range for which you want to adjust the row height.
  2. On the Home tab, in the Cells group, click Format.

Under Cell Size, do one of the following:

  • To automatically adjust the row height, click AutoFit Row Height.
  • To specify a row height, click Row Height, and then type the row height that you want in the Row height

Tip: You can also drag the bottom border of the row to the height that shows all wrapped text.

 

 

Entering Multiple Lines of Text (Manual)

There are two ways of entering multiple line of text. First, auto wrapping option and second manual wrapping option.

  • Click the cell in which you want to enter the text
  • Type the first line of text
  • For each additional line of text, press the Alt+Enter keys and then type the text
  • Select “Wrap Text” from the Alignment Group under Home Tab

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment