2
1
Is it possible to fit a large amount of text within a cell in Excel 2007?
I have 1,890 words - consisting of 10,110 characters (without spaces) - that I need to put into a single cell in Excel. I have set the cell to the maximum size (column width of 255 and row height of 409.5), yet it fails to contain all of the text. I have also set the text to the minimum size - size 1 (even though it is unreadable) - just to see if this helps, but it does not unfortunately.
I am required to keep all of the text in a single cell, so cannot branch into surrounding cells.
Is there a way around this that I am missing or overlooking?
Many thanks.
The closest you can come to what you want is to merge multiple cells, which would act like a single cell. – fixer1234 – 2015-03-17T01:13:04.290
1Curious to know why you need to do this. – Isaac Rabinovitch – 2012-11-08T01:54:26.580
2If you need to place a 5 page text into a cell you're using the wrong tool. – stevenvh – 2013-03-27T13:48:59.407