Trouble displaying all data in Merged Cells

MG · Mar 19th, 2002, 08:18 PM

I created a "box" to enter lengthy text comments by merging numerous cells (10 columns across and 7 rows down). Formatted the merged area to wrap. Everything works great until about 1,100 characters are entered, and then text stops wrapping. Doesn't matter how wide or tall I make cells... it won't display all the text. I tried formatting with shrink-to-fit and tried combining more cells in the merged area, but the same result occurs.
Any ideas?

anno · Mar 19th, 2002, 08:35 PM

depending on what version of excel you have i think you've hit the character limit. could you use a text box (drawing toolbar)instead?

Juan Pablo González · Mar 19th, 2002, 08:36 PM

Do you REALLY need all that text in one cell ? you could use more than one that "appear" as one...

Or you could use a Textbox, as anno suggested.

MG · Mar 19th, 2002, 11:49 PM

Juan Pablo G./Anno-
Thanks for the quick replies. Text box is not an option, as I'm using webquery to pass the data from excel into a database. Also, the answer is yes to do we really need the all that data. I'm using Excel 2002, but am confused about the character limitation: since I've combined 70 cells, doesn't that increase the limitation to 255x70? Again though, I am not running into a limitation re: entry; it's the dispalay that I can't seem to show.

Mar 19th, 2002, 08:36 PM	#3
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Do you REALLY need all that text in one cell ? you could use more than one that "appear" as one... Or you could use a Textbox, as anno suggested. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 08:18 PM	#1
MG New Member Join Date: Mar 2002 Posts: 2	I created a "box" to enter lengthy text comments by merging numerous cells (10 columns across and 7 rows down). Formatted the merged area to wrap. Everything works great until about 1,100 characters are entered, and then text stops wrapping. Doesn't matter how wide or tall I make cells... it won't display all the text. I tried formatting with shrink-to-fit and tried combining more cells in the merged area, but the same result occurs. Any ideas?

Mar 19th, 2002, 08:35 PM	#2
anno Board Regular Join Date: Feb 2002 Posts: 202	depending on what version of excel you have i think you've hit the character limit. could you use a text box (drawing toolbar)instead?

Mar 19th, 2002, 11:49 PM	#4
MG New Member Join Date: Mar 2002 Posts: 2	Juan Pablo G./Anno- Thanks for the quick replies. Text box is not an option, as I'm using webquery to pass the data from excel into a database. Also, the answer is yes to do we really need the all that data. I'm using Excel 2002, but am confused about the character limitation: since I've combined 70 cells, doesn't that increase the limitation to 255x70? Again though, I am not running into a limitation re: entry; it's the dispalay that I can't seem to show.