[Fix] Wrap Text Not Working in Excel: 4 Possible Solutions

When the text of a cell is longer than the cell’s length then it needs to wrap. We can apply wrap text in Excel to see all text in a cell at once and make the text more readable. But in several cases, wrap text does not work in Excel. In this article, we’ll get to learn how to wrap text not working in Excel and four possible solutions to this problem.


Download Practice Workbook

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


How the Wrap Text Feature Works in Excel

In Excel, Wrap Text is a crucial tool to make the text more readable. Here, we’ll learn how to use the Wrap Text option in Excel. Let’s say, we have a dataset where some person’s Name and their Personal Information are given in columns B and C respectively. Now, Have a look at column C, you can not read the full information of the person that has been given in column B. Wrap text feature can help you out in this situation easily. Let’s follow the instructions below to learn!

Steps:

  • First of all, look at our dataset. The texts are hard to read in the description column.

How the Wrap Text Works in Excel

  • Now, we’ll apply the Wrap Text option to make the text readable. To do that, firstly select cells C5 to C9. After that, from your Home Tab, go to,

Home → Alignment → Wrap Text

  • After clicking on the Wrap Text option, you will be able to wrap the text which has been given in the below screenshot.

How the Wrap Text Works in Excel

  • Though we apply the Wrap Text option, the text is not readable clearly because of Row height. To give row height, go to,

Home → Cells → Format → AutoFit Row Height

How the Wrap Text Works in Excel

  • While pressing on the AutoFit Row Height option, you will be able to read the text easily and clearly.

How the Wrap Text Works in Excel


4 Ways to Solve the Wrap Text Not Working Problem in Excel

In our dataset, let’s discuss the reasons and its solutions why wrap text not working in excel. Today, in this article, we will discuss the four possible reasons why wrap text does not work in Excel and the solutions to this problem. Here’s an overview of the dataset for our today’s task.

Wrap Text not working in Excel


1. Apply the AutoFit Row Height Option to Fix the Wrap Text in Excel

One of the reasons behind the wrap text not working in excel is due to the Row Expansion problem. From our dataset, “Dalton is graduated from MIT.” is the data of cell C5. The data of cell C5 is already wrapped. Now we want to add information about Dalton in cell C5. To add some more extra information about Dalton in cell C5, follow the steps below.

Steps:

  • Here, we’ll update information about Dalton in cell C5. For that, first, select cell C5.

Apply the AutoFit Row Height Option to Fix the Wrap Text in Excel

  • After selecting cell C5, Type the text which has been given in the double quotation and the text is “ Now he is working at Google.”.

  • Then simply press Enter on your keyboard and you will be able to update Dalton’s information in cell C5.

Apply the AutoFit Row Height Option to Fix the Wrap Text in Excel

  • Now we will see some instructions to fix this problem. To do that, select cells C5 to C9.

  • From your Home Tab, go to,

Home → Cells → Format → AutoFit Row Height

Apply the AutoFit Row Height Option to Fix the Wrap Text in Excel

  • While clicking on the AutoFit Row Height option, you’ll be able to fix the wrap text.

Apply the AutoFit Row Height Option to Fix the Wrap Text in Excel

Read more: How Do You Wrap The Text In a Cell


2. Unmerge Cell to Fix the Wrap Text Feature in Excel

In this method, we’ll learn when cells are merged, wrapping text not working in Excel and its solution. Please follow the instructions below to learn!

Steps:

  • First, select merged cells C5 and D5.

Unmerge Cell to Fix the Wrap Text Feature in Excel

  • Now, type After completing his graduation, he starts working with google. in the merged cells C5 and D5.

Unmerge Cell to Fix the Wrap Text Feature in Excel

  • After typing the information of Dalton, press Enter on your keyboard and you will get your desired output.

  • Then select the merged cells.

Unmerge Cell to Fix the Wrap Text Feature in Excel

  • from your Home Tab, go to,

Home → Alignment → Merge & Center

  • After clicking on the Merge & Center option, you will be able to unmerge the cells.
  • Now, select cells array B4:C9 and press the Wrap Text option.

Unmerge Cell to Fix the Wrap Text Feature in Excel

  • Finally, by clicking on the Wrap Text option, you will be able to wrap the selected text.

Unmerge Cell to Fix the Wrap Text Feature in Excel


3.  Horizontal Alignment to Fix the Wrap Text in Excel

While working with Excel Worksheet, Sometimes our cell data is more than the cell length. We want to avoid data spilling over into the next cells. We can solve this problem by using the Horizontal Text Alignment command. To fix the wrap text by using the Horizontal Alignment command, follow the instructions below.

Steps:

  • To apply the Horizontal Alignment command, press Right-Click on your Mouse, and instantly a window will appear in front of you.

Set Horizontal Alignment to Fix the Wrap Text in Excel

  • From that window, select the Format Cells By clicking on the Format Cells option, a dialog box Format Cells pops up. From the Format Cells dialog box, go to,

Alignment → Text Alignment → Horizontal → General → Ok

Set Horizontal Alignment to Fix the Wrap Text in Excel

  • After clicking on the OK option, you will solve your problem.


4. Resize Cells to Fix the Wrap Text Feature in Excel

When the length of the cell is more than the cell’s text length, wrap text does not work in that case. In this case, to fix the wrap text in your dataset, you should resize your columns or cells. Then apply the wrap text feature. Let’s follow the steps below.

Steps:

  • Look at our dataset. We can see the length of the cell is more than the cell’s text length.

Resize Cells to Fix the Wrap Text Feature in Excel

  • Now, we will minimize the length of the cells and apply the Wrap Text option.

Resize Cells to Fix the Wrap Text Feature in Excel

  • After clicking on the Wrap Text option, you will be able to wrap the text to read the text easily.


Things to Remember

👉 To apply the Wrap Text option in merged cells, first unmerge it and then apply the Wrap Text option.

👉 Resize your column’s length to apply the Wrap Text feature.


Conclusion

I hope all of the suitable methods mentioned above while wrapping text not working will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.


Further Readings

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo