wrap text in Excel

In this article, we will learn about how to Wrap text in Excel in Excel.

While writing in excel, when values get out of reach of cell length then excel spills text to the adjacent cell. And if there's text in the adjacent cell, then your text in the previous cell gets hidden.

Now here is the solution to this problem. View your content in cell, no matter what length it is.

Here we have a link as values and values are getting spilled over to the adjacent cell.

If we want to view the whole text in one line instead of wrapping it. We can just double click on the right border of Column A as shown in the gif below.

Now back to the problem to wrap text in cell.
Use the Wrap text option as shown in the below snapshot.

Select the cells and then option to wrap text on all those selected cells.

As you can see the wrapped text in the selected cells.

Hope you understood how to find to wrap text from spilling text over formula. Explore more articles on excel text functions here. Please feel free to write your queries to us in the comment box below. We will help you.
Related Articles

How to Remove Text in Excel Starting From a Position

Validation of text entries

Create drop down list in excel with colour

Remove leading and trailing spaces from text in Excel

Popular Articles

50 Excel Shortcut to Increase Your Productivity

Edit a dropdown list

If with conditional formatting

If with wildcards

Vlookup by date

Leave a Reply

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.