1. Home
  2. MS Office
  3. Excel 2010 how to wrap text in cell

Excel 2010: How To Wrap Text In Cell

While entering text into cell, sometimes you might need to wrap it up in order to set the same width/height for all the cells. If the text length is larger than the pre-defined height/width of cell, it is necessay to wrap up the text. Excel 2010 provides an option on ribbon to quickly wrap up the text in a cell. Lets see how to do it.

44d1273426853-how-wrap-text-cell-

To wrap text in cell, select the cell and navigate to Home tab, from Alignment group, click Wrap Text button.

45d1273426855-how-wrap-text-cell-

As shown in the screenshot below that text is wrapped-up in the cell.

43d1273426852-how-wrap-text-cell-

6 Comments

  1. But if the large text string is the result of a formula will the row height automatically change? Does not seem to work for me.

  2. As my understanding of thing, wrap text is applied by excel when you type in the cell. Let say you got a spead sheet that has a thousand rows with text on each of them and a bunch of columns. Wrap text is already applied in the cell. Now you decide to put larger columns. The text gets adjusted, although the row height remain untouch. How could you trigger that in excel so that it adjust each of the row height?

    • Nevermind, found it. Ctrl-A the Sheet and double click between a row will autofit all rows

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.