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.
You have to follow the following steps to wrap the text in merged cells.
- Firstly, select the cell and right-click. When the context menu opens, select the Format cells.
- Next, when the Format cells dialog box opens, go to Alignment, and then check the Wrap Text And click on OK.
Finally, you will get the output like the following where text is wrapped in the cells.
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.
- At first, select the cells and go to the Home tab, select Alignment, and finally select Wrap Text.
Finally, you will get the output like the following:
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.
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.
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.
- 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.
- 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.
By following the above process, you will get the following output.
💬 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.
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!