Frequently, you may need to wrap the text for some specific reasons especially to avoid overflowing the text. Unfortunately, you might have faced the issue of cutting off some words after applying the Wrap Text option. In this instructive session, I’ll point out 4 issues for cutting off words while doing wrap text in Excel along with their solutions.
Excel Wrap Text Cutting off Words: 4 Solutions
Let’s assume a dataset where some quotes are given by the corresponding authors. What if you apply the Wrap Text option in the case of the dataset? If you see some words are cut off then, what will be the solution to fix the issue?
Let’s check out the issues that you might face by cutting off words and also their suitable solutions.
1. If Row Height Is Fixed
If the row height is predefined, you may confront the problem of cutting off words after wrapping the text in Excel cell.
Let’s say, you want to specify the row height of the cells containing Quotes is 25. To do this, go to the Row Height option from the Format feature.
Next, input the specified row height i.e. 25.
Now, if you apply the Wrap Text option from the Alignment ribbon in the Home tab to wrap the texts.
So, what are you observing in the following screenshot? Some words are cutting off!
Yes. Right, you are. All the words are cut off except for row 7 as it doesn’t exceed the default column width.
Solution: Turn on AutoFit Row Height
The simple but effective way to fix the issue is to turn on the AutoFit Row Height option.
➤ Just click on the drop-down list of the Format feature and choose the AutoFit Row Height option while selecting the cells.
Eventually, you’ll see all words in the output as depicted in the following screenshot.
Read More: Excel Auto Fit Row Height for Wrap Text
2. Horizontal Alignment Related Issue to Wrap Text Cutting off Words
Please look closely at the following image. Though the Wrap Text option is activated, some words are missing. Can you guess what might be the reason for happening this?
➤ To find the reason, open the Format Cells dialog box (just press CTRL + 1). After opening the dialog box, go to the Alignment tab and you’ll see the Horizontal Alignment is specified as Fill.
That’s the reason!
Note: In fact, the Fill alignment is suitable for avoiding the spillover to the next cells.
Solution: Remove the Fill Horizontal Alignment
You can easily fix the issue if you encounter such type of problem.
➤ Go to the Format Cells again and set the Horizontal Alignment as General instead of the Fill alignment.
➤ Besides, you may turn on the Wrap Text (check the box before the option) if necessary.
After pressing OK, you’ll get the fixed output.
3. Cutting off Words Because of Merged Cells
In the following dataset, each Quote covers three adjacent cells.
If you wrap text in merged cells, what will be the output?
Let’s apply two tasks simultaneously.
➤ Firstly, open the Format Cells dialog box and go to the Alignment tab.
➤ Subsequently, check the box before the Wrap text under the Text Control category to wrap text, and then check the box before the Merge cells option to merge three cells.
You’ll get the following output.
Solution: Unmerge Cell the Wrap Text
If you are able to skip the merging cell issue, try to avoid that.
➤ So, you need to pick the Unmerge Cells option from the Merge & Center option while keeping your cursor over any quote.
➤ Later, if you apply the AutoFit Row Height over the unmerged cells, you’ll get the following output where all texts are displayed within the cells. More importantly, you have to activate the Wrap Text option if you turn off the wrapping text while unmerging cells.
Luckily, there are several methods to fix this issue e.g. inserting line breaks, using the VBA code, and so on.
4. Wrap Text by Cutting off Words When Have a Large Font Size
Sometimes, you may have a larger font size in your dataset as shown in the following screenshot. Obviously, you have at least two options to fix the problem. These are as follows-
- Activate the Wrap Text option.
- Apply the Shrink to Fit option.
If you turn on wrapping the text and then the AutoFit Row Height, you’ll get that rows are expanding automatically which you don’t want in some cases. Let’s apply another method.
Solution: Apply Shrink to Fit Option
Let’s say you want to reduce the font size except for expanding the rows.
➤ To apply this option, go to the Alignment tab of the Format Cells dialog box. Next, check the box before the Shrink to fit option under the Text control category.
Shortly, you’ll get the output having the reduced font size.
Download Practice Workbook
That’s the end of today’s session. This is how you may fix the wrap text by cutting off words in Excel. I strongly believe this article will articulate your Excel journey. Anyway, if you have any queries or recommendations, please share them in the comments section.
- How to Wrap Text in Excel Cell
- Wrap Text Shortcut Key in Excel
- How to Make Text Automatically Wrap Around in Excel
- How to Unwrap Text in Excel