How can you wrap text in excel

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. Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy. Download Wrap Text Excel Template. To force the text to wrap, toggle the Excel Wrap Text button off and on again. Sometimes, people want to prevent text from spilling over into next cells.

This can be done by setting Fill for horizontal alignment. If later on you enable the Wrap Text feature for such cells, nothing will change - text will still be truncated at the cell's boundary.

To resolve the issue, remove the Fill alignment:. This is how you wrap text in Excel to display longer text on multiple lines. I thank you for reading and hope to see you on our blog next week!

How to wrap text in Excel by Svetlana Cheusheva updated on March 10, What is wrap text in Excel? How to wrap text in Excel automatically How to insert a line break manually Excel wrap text not working - reasons and solutions What is wrap text in Excel? When the data input in a cell is too large fit in it, one of the following two things happens: If columns to the right are empty, a long text string extends over the cell border into those columns.

If an adjacent cell to the right contains any data, a text string is cut off at the cell border. 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. The exact same commands used to apply the formatting can be used to remove the formatting as well!

For example, if you change the width of the cell, the data wrapping will automatically adjust to fit the new space. If your wrapped text isn't all visible, it could be because the row is set to a specific height that can't accommodate the amount of text, or that the text is in a range of cells that's been merged. To manually break up the text to move it onto another line, first double click on the cell, in the spot where you want to make the line break.

For you. World globe An icon of the world globe, indicating different international options. Get the Insider App. Click here to learn more. A leading-edge research firm focused on digital transformation.