Increase cell limit from 1004
 

Hi there, Is there any way (perhaps programatically) to increase the cell
limit from 1004 without having to add in ALT + enter every 80-100 words?

I am putting text into a cell from a data source. Users are not experienced
enough to put in alt + enter and edit the text in cell realiably.

I want the form I have to display and print 1004 characters.

I would prefer not to use a text box. but is this the only option?

Thanks int anicipation

--
Message posted via http://www.officekb.com

Increase cell limit from 1004
 

will this cell not effect the entire worksheet??

Maybe you could use the comments
but I don't know if it is able to handle that much text as I have never
tested it to do so
I suppose you could use autoshapes and reference it to a cell with that
much info though, instead of having one cell several screen pages large


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=542724