Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to autosize/wrap large text block?
I have a column that contains large blocks of text in each row (like 20-50
lines). I can't get it to autosize the cell to show all the text. If I make the cell width like 400 and set AutoWrap on, I get maybe 15 lines showing then it stops wrapping. Clicking on the cell shows all the text. Then if I manually adjust the height, no matter what height I drag it to, it stops filling in the cell with text at some point. The last bit it displays looks cut off in fact. Dragging the height any large just yields empty space after the part where the text is cutoff. Is there some limit to a cell's ability to display its own contents, regardless of height, width, and AutoWrapOn? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to autosize/wrap large text block?
Tim
Excel Help on "limits" or "specifications" reveals that Excel will allow 32,767 characters to be entered in a cell. However, it goes on to state that "only 1024 characters will be visible or can be printed" To work around this limitation, stick a few ALT + ENTERs in at appropriate spots, about every 100 characters.. The ALT + ENTER forces a line-feed and expands the 1024 limit. How far is not really known. Just experiment. .........From Dave Peterson.......... I put this formula in A1: ="xxx"& REPT(REPT("asdf ",25)&CHAR(10),58)&"yyy" And adjusted the columnwidth, rowheight and font size and I got about 7300 characters to print ok. .........End Dave P................. Failing that, use a Text Box to store the text or MS Word which is a word processing application, unlike Excel which is not. Gord Dibben Excel MVP On Wed, 18 Oct 2006 17:22:01 -0700, Tim Johnson wrote: I have a column that contains large blocks of text in each row (like 20-50 lines). I can't get it to autosize the cell to show all the text. If I make the cell width like 400 and set AutoWrap on, I get maybe 15 lines showing then it stops wrapping. Clicking on the cell shows all the text. Then if I manually adjust the height, no matter what height I drag it to, it stops filling in the cell with text at some point. The last bit it displays looks cut off in fact. Dragging the height any large just yields empty space after the part where the text is cutoff. Is there some limit to a cell's ability to display its own contents, regardless of height, width, and AutoWrapOn? Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return a block of text based on a single "short name" entry | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Excel,Auto fit - does work for large text fields | Excel Discussion (Misc queries) | |||
cannot view all of text in large cell, even though I have it to w. | Excel Discussion (Misc queries) |