Excel Wrap Text Cutting off Words: 4 Solutions

Fix 1 – If the Row Height Is Fixed

If the row height is predefined, you get the problem of cutting off words after wrapping the text in Excel cell.

We went to the Row Height option from the Format feature.

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

The specified row height for the example is 25.

Defining Row Height Manually

We applied the Wrap Text option from the Alignment ribbon in the Home tab to wrap the texts.

Some words are cut off since the content doesn’t fit in a single line but the row height isn’t enough to show them.

Solution: Turn on AutoFit Row Height

Click on the drop-down list of the Format feature and choose the AutoFit Row Height option while selecting the cells.

Here’s the result.

Fix 2 – If Horizontal Alignment Is Turned On

Though the Wrap Text option is activated, some words are missing.

Open the Format Cells dialog box (just press CTRL + 1). Go to the Alignment tab to see the Horizontal Alignment is specified as Fill.

Note: In fact, the Fill alignment is suitable for avoiding the spillover to the next cells.

Solution: Remove the Horizontal Alignment

Go to Format Cells again and set the Horizontal Alignment as General instead of Fill alignment.
You may turn on the Wrap Text (check the box before the option).

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

Fix 3 – If There Are Merged Cells

Each Quote covers three adjacent cells.

Open the Format Cells dialog box and go to the Alignment tab.
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 Cells then Wrap Text

Pick the Unmerge Cells option from the Merge & Center settings.

If you apply AutoFit Row Height over the unmerged cells, you’ll get the following output where all texts are displayed within the cells. You have to activate the Wrap Text option if you turn off the wrapping text while unmerging cells.

Fix 4 – If You Use a Large Font Size

You may have a larger font size in your dataset as shown in the following screenshot. You have at least two options to fix the problem.

Activate the Wrap Text option.
Apply the Shrink to Fit option.

If you turn on wrapping the text in the AutoFit Row Height, you’ll get that rows are expanding automatically, which you don’t want in some cases. Let’s apply the second solution.

Solution: Apply Shrink to Fit