In certain cases, the cells in a worksheet contain text bigger than the default width. For example, you have a description cell for a product sheet or remarks/feedback in a customer sheet.
In that case, the cell’s width/height remains the same while the text is hidden.
In this tutorial, I will show you ways of wrapping the text in a larger cell than the default cell’s width.
You may auto-wrap the cell to show all text or add line breaks in a cell – see how with screenshots below.
The example of Excel wrap text (auto)
First, let us have a look at the example of making a cell with auto-wrap text. So, if the size of the text is greater than the cell’s width then it goes to the next line and the whole text is visible.
For making a cell auto wrap text, do this:
Select the cell that you want to enable the auto wrap text feature as shown below:
You can see, the text of many cells is hidden in the above graphic. However, we want to wrap the text for only the selected cell (for this example).
Go to “Home” tab in the ribbon
In the Alignment group, click the “Wrap Text” button:
As you press the button, the cell text should look like this:
You saw, only the height of the selected cell is increased and all text is visible while other cell’s text in the same column is not. If you enter more text in that column, the height of the cell will increase so that the whole text is visible.
Making whole column auto wrap text enabled
Follow this step to make all cells in a column with “Wrap Text” feature enabled.
Select the column by clicking on the letter e.g. A, B, C, D, etc. For example, I selected the “C” column:
Same as in the above example, go to the “Home” tab in the ribbon.
In the “Alignment” group, press the “Wrap Text” button.
The result of the above sheet is as shown below:
You can see that all text is visible for the column C. One thing to notice is that the cell’s height increased while the width remained the same.
Manually adding a line break example
You may also add a line break in a cell as entering the long text. For adding a line break in existing text or while writing the text, do the following.
Double click on the text area where you want to add a line break and press:
Alt + Enter
If you are writing text then simply press the Alt + Enter to add a new line.