Md. Abdur Rahim Rasel
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.
- 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.
- 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
- While pressing on the AutoFit Row Height option, you will be able to read the text easily and clearly.
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.
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.
- 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.
- 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
- While clicking on the AutoFit Row Height option, you’ll be able to fix the wrap text.
Read More: Excel Auto Fit Row Height for Wrap Text (4 Methods)
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.
- Now, type After completing his graduation, he starts working with google. in the merged cells C5 and D5.
- After typing the information of Dalton, press Enter on your keyboard and you will get your desired output.
- Then select the merged cells.
- 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.
- Finally, by clicking on the Wrap Text option, you will be able to wrap the selected text.
Read More: How to Wrap Text in Merged Cells in Excel (5 Ways)
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.
- 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
- After clicking on the OK option, you will solve your problem.
Read More: [Fixed] Wrap Text Not Showing All Text in Excel (4 Solutions)
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.
- Now, we will minimize the length of the cells and apply the Wrap Text option.
- After clicking on the Wrap Text option, you will be able to wrap the text to read the text easily.
Read More: How Do You Wrap The Text In a Cell (5 Easy Ways)
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.
Related Articles
- [Fix]: Excel Wrap Text Cutting off Words
- [Solution:] Excel Wrap Text Not Working for Merged Cell
- How to Wrap Text across Multiple Cells without Merging in Excel
- Wrap Text in Excel Shortcut Key (2 Hotkeys)
- How to Unwrap Text in Excel (4 Methods)
- Excel VBA: Autofit Row Height with Wrap Text (5 Effective Ways)
