LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Return a block of text based on a single "short name" entry cindee Excel Worksheet Functions 5 October 5th 05 08:43 PM
Sort or Filter option? Mcobra41 Excel Worksheet Functions 3 February 23rd 05 07:22 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
Excel,Auto fit - does work for large text fields ancastle Excel Discussion (Misc queries) 4 January 6th 05 12:15 AM
cannot view all of text in large cell, even though I have it to w. sydme Excel Discussion (Misc queries) 1 December 27th 04 03:26 PM


All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"