How to do a word wrap in Excel

In Excel 2016, 2013 and 2010 when the typed text is larger than the width of the cell the text entered will appear as single line of text. If you want to align this text to the width of the cell then you can use excel 2010 word-wrap feature. If you want to do the alignment for whole column then you can right click the selected column and select Format Cells from the menu list.


Navigate to Alignment tab in the Format Cells windows and tick the check box Wrap text under the Text Control section. Click OK to save the changes.



This would do a word wrap of the text entered as shown below



If you want to apply the word wrap only for the selected cell then you can also use the Keyboard combination.Take your cursor to end of the text entered and press Alt + Enter simultaneously.


In Category: Excel 2010, Excel 2013, Excel 2016

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 4 Comments
  • William Ball August 7, 2012, 12:17 am

    Followed instructions and tested Word Wrap at on various cells in column on spreadsheet and it does not work.

  • Gene Hatfield May 26, 2013, 7:55 am

    Link was supposed to get to information on MS Word 2010 not Excel!!!!!!!!!!!!!!!!!

  • Simon Says June 4, 2013, 7:51 am

    Hey, Gene, try reading the link before you act…it CLEARLY says EXCEL – not Word in the link

  • Carol September 27, 2013, 4:59 pm

    In a sort of the document how do I get the wrapped cell to stay wrapped? When I sort the information that was wrapped might be moved within the sort and be in another cell that was not wrapped.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.