Merged cell not showing all text

krazyderek

Board Regular
Joined
Feb 17, 2005
Messages
60
So i have a set of merged cells i want to use to write a big note in. It's 4c x 23r in size, and the columns are expanded to 87 pixels.

I have wrap text turned on and it works ok for small to medium sized paragraphs. But if i try to keep writing and fill the box i can only ever get text to fill up to 19r then it cuts off the text and doesn't display anything beyond that.

To be clear, the text is entered in the merged cell, but the lower 4 rows of the merged cell always stay blank regardless of how much text i put in the merged cell. I have tried reproducing this on in a new file, it works, until i expand the column width to 87 pixels then the problem happens.

Help
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
This is a known Excel issue - after a certain number of characters (I think anywhere between 800+ to 1000+) text stops wrapping.
In such situations try usin textboxes.
 
Upvote 0

Forum statistics

Threads
1,214,798
Messages
6,121,635
Members
449,043
Latest member
farhansadik

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top