Mrinmoy Roy
When a text length is greater than a cell length, some part of the text becomes invisible due to the lack of enough space allocated for the text. To solve this issue, we need to convert a single-line text into multiple lines which are known as text wrapping. With that kept in mind, in this article, we are going to discuss 4 easy techniques that you can use to wrap up text easily in Microsoft Excel.
Here, I have shown you an overview of a simple yet effective way to wrap text. For more detailed methods, go through the following section.
Download Practice Workbook
You are recommended to download the Excel file and practice along with it.
What Is Text Wrapping?
Text Wrapping refers to the conversion of single-line text into multiple-line text with a view to better showcasing the cell contents to the users.
4 Smart Techniques to Wrap Text in Excel
We will be using a Book List as a data table to demonstrate all the methods to wrap text.
So, without having any further discussion let’s get into all the methods one by one.
1. Wrap Text Using the Wrap Text Feature in Excel
We can use the built-in Wrap Text feature with a view to wrapping up text in Excel. This is super easy to use and quickly accessible. Now follow the steps below to learn to use the Wrap Text feature.
🔗 Steps:
❶ First of all, select the range of cells ▶ where you want to apply the wrap text command.
❷ Go to Home ▶ Alignment ▶ Wrap Text.
When you are done with all the steps mentioned above, you will the result as follows:
2. Wrap Text Keyword Shortcut in Excel
There is a keyboard shortcut to wrap text swiftly. Here’s how to use the hotkey:
🔗 Steps:
❶ First of all, select the range of cells to wrap up texts.
❷ Press the ALT + H + W alltogether.
When you are done with all the steps mentioned above, you will the result as follows:
3. Wrap Text Using the Format Cells Feature
We can wrap up text easily in Excel using the Format Cells feature. Now go through the steps below to see how to use this feature.
🔗 Steps:
❶ First of all, select the range of cells to wrap up texts.
❷ Now press CTRL + 1 to open the Format Cells dialog box.
❸ After that go to the Alignment tab.
❹ Now mark tick on the Wrap text option and hit the OK button.
As you are done with all the steps above, you will see the result as follows:
Read More: [Fix] Wrap Text Not Working in Excel: 4 Possible Solutions
4. Use Line Break to Wrap Text Manually in Excel
In this method, we will use the line break technique to wrap up text in Excel.
At this point, all you need to do is follow the steps below:
🔗 Steps:
❶ Place your cursor on the text where you want to put the line break.
❷ Then press ALT + ENTER to break the line.
❸ Finally press the ENTER button to finish the whole process.
Wrap Text Not Working?
There are situations that might appear that you’ve applied the wrap text command but some part of your text is still invisible and you can’t give them a read. If it is so, then you can try any of the solutions below:
1. AutoFit Row Height
Maybe it’s the row height that is not sufficient enough to showcase the full text within it. To fix this problem, follow the following procedures.
🔗 Steps:
❶ First, select the cell and go to the Home ribbon.
❷ Click on Format.
❸ From the drop-down menu select AutoFit Row Height.
Read More: Excel Auto Fit Row Height for Wrap Text (4 Methods)
2. Merge & Center
If you ever apply the Merge & Center command, then the wrap text command won’t work in that case. All you need to do is, disable the Merge & Center command. To disable the Merge & Center command-
🔗 Steps:
❶ Select the cell.
❷ Go to the Home ribbon.
❸ Click on Merge & Center.
Read More: How to Wrap Text in Merged Cells in Excel (5 Ways)
3. Sufficient Row Height
If you try to apply the wrap text command on a cell that is already sufficient enough to display its content normally, then even after applying the wrap text command no change will appear. To force apply the wrap text feature, toggle the Wrap Text command off and on.
Read More: Excel VBA: Autofit Row Height with Wrap Text (5 Effective Ways)
4. Fill for Horizontal Alignment
To prevent from spilling over into the next cell, people may set Fill for horizontal alignment. In such a case, the wrap text feature won’t work. To disable this functionality-
🔗 Steps:
❶ Open the Format Cells dialog box by pressing the CTRL + 1 keys.
❷ Go to the Alignment tab.
❸ Under this tab, set General under the Horizontal option.
❹ Hit the OK button.
Undo Wrap Text
You can simply undo the wrap text command by following the same procedure as you did while wrapping up the text in the first place. Anyways, you can try the following:
❶ Select the range of the cells to unwrap text in them.
❷ Press the ALT + H + W keys altogether or click on the Wrap Text command under the Home ribbon.
That’s simply it.
Things to Remember
📌 You can open up the Format Cells dialog box by pressing CTRL + 1 .
📌 Press ALT + H + W keys altogether to wrap texts by shortcut.
Conclusion
To sum up, we have discussed 4 easy techniques to wrap up text in Excel. You are recommended to download the practice workbook attached along with this article and practice all the methods with that. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap.
