How to Wrap Text in Excel (4 Easy Techniques)

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 is 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 Excel.


Download the 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 a single-line text into multiple-line text with a view to better showcasing the cell contents to the users.

what is wrap text in excel


4 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 in Excel.

4 Techniques to Wrap Text in Excel: Sample Dataset

So, without having any further discussion let’s get into all the methods one by one.


1. Wrap Text in Excel Using the Wrap Text Feature

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.

Wrap Text in Excel Using the Wrap Text Feature

When you are done with all the steps mentioned above, you will the result as follows:


2. Excel Wrap Text Keyword Shortcut

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

Excel Wrap Text Keyword Shortcut

When you are done with all the steps mentioned above, you will the result as follows:


3. Wrap Text Using the Format Cells Feature in Excel

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.

Wrap Text Using the Format Cells Feature in Excel

As you are done with all the steps above, you will see the result as follows:


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.

Use Line Break to Wrap Text Manually in Excel

❷ 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, first, select the cell and then,

❶ Go to the Home ribbon.

❷ Click on Format.

❸ From the drop-down menu select AutoFit Row Height.

AutoFit Row Height


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-

❶ Select the cell.

❷ Go to the Home ribbon.

❸ Click on Merge & Center.

Merge & Center


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.


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-

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

Fill for Horizontal Alignment


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.


Read More

Mrinmoy

Hi! This is Mrinmoy. I write about Excel and VBA stuff for Exceldemy. I have my graduation completed from Khulna University of Engineering & Technology, Bangladesh. I have an immense interest in Datascience and Machine Learning. I like to play guitar and watch Tedtalks in my leisure time. I used to be an indie filmmaker and a wedding photographer. I'm liberal to any kind of constructive criticism and inclined towards expanding my learnings.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo