Wrap text in a cell (2024)

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.

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. (On Excel for desktop, you can alsoselect the cell, and then pressAlt + H + W.)

   See Also

   Scale a worksheet - Microsoft SupportCell shape and size remain the same when the solution outside isFix data that is cut off in cellsHow do you change column width to fit the contents

   

   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.

Enter a line break

To start a new line of text at any specific point in a cell:

1. Double-click the cell in which you want to enter a line break.

   Tip:You can also select the cell, and then press F2.

2. In the cell, click the location where you want to break the line, and press Alt+ Enter.

Need more help?

You can always ask an expert in the Excel Tech Communityor get support inCommunities.