How to Wrap Text in Merged Cells in Excel (5 Ways)

Get FREE Advanced Excel Exercises with Solutions!

If you are searching for some special tricks to wrap text in merged cells in order to avoid the difficulty of reading the long text in Excel cells, you are in the perfect place. In Microsoft Excel, there are numerous ways to wrap text in merged cells. In this article, we’ll discuss five methods to wrap text in merged cells. Let’s follow the complete guide to learn all of this.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


5 Methods to Wrap Text in Merged Cells in Excel

Here, we have a dataset containing five items and item descriptions where the item description has long text which crossed the border of the cell. Now, we are going to wrap text in these cells.

In the following section, we will use 5 methods to wrap text in merged cells.


1. Using Format Cells Option to Wrap Text in Merged Cells

In the below dataset we can see that all the text of the item description column is not shown because of the long text. Now, we are going to avoid this difficulty by using the Format cells option to wrap the text.

Using Format Cells Option to Wrap Text in Merged Cells

You have to follow the following steps to wrap the text in merged cells.

📌 Steps:

  • Firstly, select the cell and right-click. When the context menu opens, select the Format cells.

Using Format Cells Option to Wrap Text in Merged Cells

  • Next, when the Format cells dialog box opens, go to Alignment, and then check the Wrap Text And click on OK.

Using Format Cells Option to Wrap Text in Merged Cells

Result:

Finally, you will get the output like the following where text is wrapped in the cells.

Read More: How to Wrap Text across Multiple Cells without Merging in Excel


2. Using Home Tab to Wrap Text in Merged Cells

You have to follow the following steps to wrap the text by using the Home tab.

📌 Steps:

  • At first, select the cells and go to the Home tab, select Alignment, and finally select Wrap Text.

Using Home Tab to Wrap Text in Merged Cells

Result:

Finally, you will get the output like the following:

Using Home Tab to Wrap Text in Merged Cells

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


3. Keyboard Shortcut to Wrap text in Merged Cells

By using the keyboard shortcut we can easily and quickly wrap the texts in merged cells. For this purpose, you have to select the cell and press ALT+H+W. As a result, you will get the following output.

Keyboard Shortcut to Wrap text in Merged Cells

Read More: Wrap Text in Excel Shortcut Key (2 Hotkeys)


4. Using Line Break To Wrap Text in Merged Cells in Excel

Another simplest way to wrap the text in merged cells is to use Line Break manually. For this purpose, we have to click on the cell and put the cursor on the place where we want to use a line break. Next, we will press ALT+ENTER.

Keyboard Shortcut to Wrap text in Merged Cells

Result:

By following the above process, we will get the following output.


5. Excel VBA to Wrap Text in Merged Cells

You have to follow the following steps if you want to wrap text in merged cells in Excel with VBA.

📌 Steps:

  • Firstly, press ALT+F11 or you have to go to the tab Developer, select Visual Basic to open Visual Basic Editor and click Insert, select Module.

Excel VBA to Wrap Text in Merged Cells

  • Next, you have to type the following code:
Sub VBA_wrap_text_merged()

Range("C5:D9").WrapText = True

End Sub
  • Now, press F5 or select Run, and click on Run Sub/UserFrom.

Excel VBA to Wrap Text in Merged Cells

Result:

By following the above process, you will get the following output.

Read More: Excel VBA: Autofit Row Height with Wrap Text (5 Effective Ways)


💬 Things to Remember

✎ If you are using a keyboard shortcut, remember to press it one by one. Not altogether.

✎ You have to adjust row height after following each method.


Conclusion

That’s the end of today’s session. I strongly believe that from now you may wrap text in merged cells. If you have any queries or recommendations, please share them in the comments section below.

Don’t forget to check our website Exceldemy.com for various Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Saquib Ahmad Shuvo

Saquib Ahmad Shuvo

Welcome to my Profile. I am working on and researching Microsoft Excel right now, and I will be posting articles about it here. I received a B.Sc. in Naval Architecture and Marine Engineering from the Bangladesh University of Engineering and Technology (BUET). Having studied naval architecture, I have a strong interest in research and development. Always try to learn from different sources and come up with creative solutions.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo