Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
merged cells
I have a large block of merged cells that is set up to wrap, but not all of
the text will appear... even when there is plenty of room remaining in the cell. What do I do? -- pj |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
merged cells
Although you can place upto 37,767 characters in a cell, Excel limits the
display to 1,024 characters. You can view more than 1,024 if you use <Alt + Enter to insert line breaks in the cell, instead of letting it word wrap. Hope this helps... -- Kevin Backmann "PJ" wrote: I have a large block of merged cells that is set up to wrap, but not all of the text will appear... even when there is plenty of room remaining in the cell. What do I do? -- pj |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
merged cells
Thank you for the info. While fooling with it, I found out about the
Alt/enter, so I wondered if there was some other "secret". Even though I would have rather had a "solution", it is still very good to know my limit! Thanks again & have a good weekend! -- pj "Kevin B" wrote: Although you can place upto 37,767 characters in a cell, Excel limits the display to 1,024 characters. You can view more than 1,024 if you use <Alt + Enter to insert line breaks in the cell, instead of letting it word wrap. Hope this helps... -- Kevin Backmann "PJ" wrote: I have a large block of merged cells that is set up to wrap, but not all of the text will appear... even when there is plenty of room remaining in the cell. What do I do? -- pj |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
merged cells
Excel 2007 will display about 32000, prior versions about 1000
"PJ" wrote in message ... I have a large block of merged cells that is set up to wrap, but not all of the text will appear... even when there is plenty of room remaining in the cell. What do I do? -- pj |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
Merged cells | Excel Discussion (Misc queries) | |||
Merged Cells | Excel Discussion (Misc queries) | |||
how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |