We use the Wrap Text feature in Excel quite often in our daily work life. While using this tool, we may encounter some issues. Such as after applying this command, the wrapped text may not fit in the cell or not show up completely. In this article, you will learn 4 solutions to fix wrap text not showing all text in Excel.
Download Practice Workbook
You can download the Excel file from the following link and practice along with it.
4 Solutions to Fix Wrap Text Not Showing All Text in Excel
1. Apply AutoFit Row Height Command to Fix Wrap Text Not Showing All Text
After applying the Wrap Text command, if the wrapped texts don’t show up completely, then you should consider changing the cell height.
I have applied the Wrap Text command in the Book Name column. Here, those texts are not showing up completely.
Now let’s apply the AutoFit Row Height to fix the problem. For that,
❶ Select all the texts first. Here, I selected the range B5:B12.
❷ Then go to Home >> Cells >> Format >> AutoFit Row Height.
After applying the AutoFit Row Height command, all the wrapped text will be visible completely.
2. Set Horizontal Alignment to Fix Wrap Text Not Showing All Text in Excel
Another approach to fix the wrapped text visibility issue is to adjust the Horizontal Alignment.
If the Horizontal Alignment is set to Fill in the Format Cells dialog box, then the wrapped texts will not be visible completely.
Now follow the steps below to update the settings.
❶ Select all the texts first where you’ve applied the Wrap Text command.
❷ Then press CTRL + 1 to avail the Format Cells dialog box.
❸ Go to the Alignment tab in the Format cells dialog box.
❹ Set Fill from the Horizontal drop-down list.
❺ Finally hit the OK button.
After that, you see the issue is wiped out. And all the wrapped texts are visible now completely.
3. Unmerge the Merged Cells to Display All the Wrapped Text in Excel
In general, to fix the issue after applying the Wrap Text command, we generally apply the AutoFit Row Height command.
But if your cells are merged cells, then the AutoFit Row Height command won’t be applicable.
Let’s see the effect by applying the AutoFit Row Height command.
For that select the texts and then go to Home >> Cells >> Format >> AutoFit Row Height.
Now see that the issue is not wiped out yet.
Thus you will need to unmerge those cells first and then apply the AutoFit Row Height command again.
Here’s how to do that.
❶ Select all the texts first having visibility issues. Here, I selected the range B5:B12.
❷ Then go to Home >> Alignment >> Merge & Center.
This will unmerge all the merged cells.
Now you can apply the AutoFit Row Height command.
To do so,
❶ Select all the texts again.
❷ Then go along with Home >> Cells >> Format >> AutoFit Row Height.
This time the command will work perfectly. Thus you will see all the wrapped texts are visible now completely as in the picture below:
4. Manually Resize Cells to Fit Wrapped Text in Excel
If none of the above methods work for you, then you can follow this method.
So the last solution is to change all the cell widths manually.
Look at the following picture. I have a small data table where two of the cells have visibility issues due to applying the Wrap Text command. Now you will manually fix this issue.
❶ Place your mouse cursor at the line border of the cells having issues.
❷ Then press and hold the left mouse button.
❸ After that drag the adjustment icon downward until all the texts are visible.
❹ Repeat this process for all the cells having visibility issues.
Thus, you will get out of the visibility issue due to applying the Wrap Text command just like the following screenshot.
You will get an Excel sheet like the following screenshot, at the end of the provided Excel file. Where you can practice all the methods discussed in this article.
To sum up, we have discussed 4 approaches to fix wrap text not showing all in Excel. You are recommended to download the practice workbook attached along with this article and practice all the methods with that. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap. And please visit our website Exceldemy to explore more.