Wrap text in a cell

If you want text to appear on multiple lines in a cell, you can format the cell so that the text wraps automatically, or you can enter a manual line break.

What do you want to do?

Wrap text automatically

Enter a line break

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 Button image.

    Excel Ribbon Image

    Notes   

    • Data in the cell wraps to fit the column width. When 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.

      How to adjust the row height

      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.

        The Cells group on the Home tab

      3. 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 box.

Top of Page

Enter a line break

  • To start a new line of text at a specific point in a cell, double-click the cell, click the location where you want to break the line in the cell, and then press ALT+ENTER.

Top of Page

Applies To: Excel 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language