What is wrap text in excel

Method 1. Method 2. Compared to the first method, this one takes a couple of extra clicks, but it may save time in case you wish to make a few changes in cell formatting at a time, wrapping text being one of those changes.

Whichever method you use, the data in the selected cells wraps to fit the column width. If you change the column width, text wrapping will adjust automatically.

The following screenshot shows a possible result:. Sometimes you may want to start a new line at a specific position rather than have lengthy text wrap automatically. To enter a line break manually, just do the following:.

Inserting a manual line break turns on the Wrap Text option automatically. However, the line breaks entered manually will stick in place when the column is made wider. If you turn off text wrapping, the data displays in one line in a cell, but the inserted line breaks are visible in the formula bar. The following screenshot demonstrates both scenarios a line break in entered after the word "owl" :.

The format cells dialog box contains all the formatting options you can apply to a cell in your spreadsheet, including the wrap text option. This is a great option when you want to apply wrap text and other formatting options at the same time. If your row height does not properly adjust to fit all the text and is either too small or too big, then you will need to adjust it. You can do this manually by clicking and dragging the row but there is an easy option to auto-adjust the height.

You can also do this by double clicking on the edge of the row heading. The wrap text option will automatically format your text with line breaks based on the available width of the cell.

If you want to choose where the line breaks appear, then you can do this by manually adding line break characters to your text data. Place the cursor in the text at the point where you want to add a line break then hold the Alt key and press Enter. This will add a line break character into your text data and the data will appear on multiple lines in the sheet. Select the cells from which you want to remove the formatting and then perform any of these methods.

If you have used the above two options before doing wrap text, you will not observe any change in the row height or column width when you click the Wrap Text button.

If accidentally any changes are seen, then simply double-click the bottom border of a row header to fix this. This has been a guide to Excel Wrap Text. Here we discuss how to Wrap Text in excel using the format cells option and wrap text option along with practical examples and downloadable excel template.

You can also go through our other suggested articles —. Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped.