Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get all text to print in merged and wrapped cells.
Once I enter text in a merged and wrapped group of cells I find that not all
the text shows up when print previewing or printing. How do I get it to show up? Why does it not all show up? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get all text to print in merged and wrapped cells.
A search of the Help for 'Excel specifications and limits' explains that only 1024 characters is displayed or printed, and that to a Row height limit of 409 points. Is your data more than 1k in size? note: 32k will display in the formula bar. 10-S-C Wrote: Once I enter text in a merged and wrapped group of cells I find that not all the text shows up when print previewing or printing. How do I get it to show up? Why does it not all show up? -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=490513 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get all text to print in merged and wrapped cells.
You can get more than the document 1000 characters to show up in a cell by
inserting alt-enters (to force new lines within the cell) every 80 to 100 characters. And if you manually adjust the rowheight, widen the column, and change the font size, you may be able to see and print much, much more. 10-S-C wrote: Once I enter text in a merged and wrapped group of cells I find that not all the text shows up when print previewing or printing. How do I get it to show up? Why does it not all show up? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - merged cells w/wrapped text auto row height doesn't work. | Excel Discussion (Misc queries) | |||
How do I automatically expand a merged cell with wrapped text? | Excel Discussion (Misc queries) | |||
Auto fit wrapped and merged cells | Excel Discussion (Misc queries) | |||
How can I display and print all the data in a wrapped merged cell. | Excel Discussion (Misc queries) | |||
Wrapped text appears as xxxxxx | Excel Discussion (Misc queries) |