[Fix]: Excel Wrap Text Cutting off Words

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.


Download Practice Workbook


4 Issues and Solutions to Wrap Text Cutting off Words in Excel

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?

Dataset

Let’s check out the issues for what you might face 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.

Let’s say, you want to specify the row height of the cells containing Quotes is 25. For doing this, go to the Row Height option from the Format feature.

Excel Wrap Text Cutting off Words If the Row Height is Fixed

Next, input the specified row height i.e. 25.

Defining Row Height Manually

Now, if you apply the Wrap Text option from the Alignment ribbon in the Home tab to wrap the texts.

If the Row Height is Fixed

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.

Excel Wrap Text Cutting off Words If the Row Height is Fixed

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.

Excel Wrap Text Cutting off Words If the Row Height is Fixed

Eventually, you’ll see all words in the output as depicted in the following screenshot.

If the Row Height is Fixed

Read More: Excel Auto Fit Row Height for Wrap Text (4 Methods)


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?

Excel Wrap Text Cutting off Words Horizontal Alignment Related Issue

➤ 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!

Because of Merged Cells

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.

Horizontal Alignment Related Issue

After pressing OK, you’ll get the fixed output.

Horizontal Alignment Related Issue

Read More: [Fix] Wrap Text Not Working in Excel: 4 Possible Solutions


3. Cutting off Words Because of Merged Cells 

In the following dataset, each Quote covers three adjacent cells.

Excel Wrap Text Cutting off Words Cutting off Words Because of Merged Cells

If you apply the Wrap Text option after merging the cells, what’ll 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.

Because of Merged Cells

You’ll get the following output.

Excel Wrap Text Cutting off Words Cutting off Words Because of Merged Cells

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.

Unmerged Cells

➤ 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.

Excel Wrap Text Cutting off Words Cutting off Words Because of Merged Cells

Luckily, there are several methods to fix this issue e.g. inserting line breaks, using the VBA code, and so on.

Read More: [Solution:] Excel Wrap Text Not Working for Merged Cell


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.

Excel Wrap Text Cutting off Words When Have a Large Font Size

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.

Shrink to Fit to Excel Wrap Text Cutting off Words

Shortly, you’ll get the output having the reduced font size.

Excel Wrap Text Cutting off Words When Have a Large Font Size

Read More: [Fixed] Wrap Text Not Showing All Text in Excel (4 Solutions)


Conclusion

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.


Related Articles

Md. Abdul Kader

Md. Abdul Kader

Hi! I am Abdul Kader and presently working as ‘Excel & VBA Content Developer’ at Exceldemy. I publish my articles related to Microsoft Excel here. In 2019, I completed my graduation in Urban and Regional Planning from Chittagong University of Engineering and Technology. Having extreme eagerness to learn, I want to develop my skills and capabilities higher.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo