Hi,
I have an excel file in which some data is written in Row 1.But this data is not appearing properly.When i double click in the row ,the data appears properly.
Please assist how to make it properly readable and printable.
Thank You
Kapil
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Entered Data not properly readable in cell
0
Answers
0
Selected Answer
The height of row 1 is set to 55.25 pt which isn't enough to display the text you wrote into it. When you double-click (enter edit mode) the row expands to show the entire text. I think I cured the problem by adjusting the row height to 72 points.
However, I suspect that this may not be the final solution. Your string in row 1 has 291 characters plus some special formatting. I would be reluctant to enter more than 255 characters into a cell, especially if it is merged and parts of the text has special formatting. Excel isn't really a very good text processor and with the demands you are putting on cell A1 in this regard you just might hit its limits. If increasing the row height doesn't solve the problem try breaking up the cell contents into two or more rows. Consider using a shape to contain the text.