See all How-To Articles

How to Use Word Wrap in Excel & Google Sheets

This tutorial demonstrates how to use word wrap in Excel and Google Sheets.

 

word wrap initial data

 

Word Wrap

If your text length doesn’t fit the width of the cell, Excel won’t display the whole text or will display it over the nearby cells. To avoid this, and display the whole text in a cell, without changing its width, you can wrap the text into multiple rows. Say that you have the following texts in cells A1:C1.

 

word wrap initial data

 

To apply word wrap, select the cell or a range of cells where you want to wrap text (in this case A1:C1), and in the Ribbon, go to Home > Wrap Text (or use the keyboard shortcut).

 

word wrap 1

 

As a result, text in the selected range is wrapped to fit cell width. Excel will automatically split the text into multiple rows to fit the whole text.

 

word wrap final data

 

Word Wrap in Google Sheets

As in Excel, you can also use the word wrap functionality in Google Sheets.

Just select the cell or range of cells where you want to wrap text (in this case A1:C1), and in the Toolbar, go to Text Wrapping > Wrap.

 

google sheets word wrap 1

 

The result is similar: All selected text is split into multiple rows to fit the cell widths.

 

google sheets word wrap 2