Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to print all text in a cell? - It cuts off the last few lines.
When printing a matrix with long text write-ups - The last few lines of a
cell will be cut off. Is there a way to extend the parameters of a cell to not do this? Or - are there other solutions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to print all text in a cell? - It cuts off the last few lines.
your question is not clear. perhaps you need to fix the print area. try following click on cell or cells with long text in it, right click Format Cells... on Alignmen tab, check the option Wrap text. this will adjust your text within a cell. select the range you want to print, go to File menu Print Area Set Print Area. now take a look at print preview to what is going to print. hope this would help. Sgutsell Wrote: When printing a matrix with long text write-ups - The last few lines of a cell will be cut off. Is there a way to extend the parameters of a cell to not do this? Or - are there other solutions? -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=574186 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to print all text in a cell? - It cuts off the last few li
Sorry I wasn't clear. I've performed the below. The cell with 2 long
paragraphs in it is wrapped and I've widened the column. The last 10 lines of the second paragraph are cut off at the end. The do not print either. It is as if the cell has a limited number of characters it can display; however, when I double click ont he cell the formula box contains all of the text?.? "starguy" wrote: your question is not clear. perhaps you need to fix the print area. try following click on cell or cells with long text in it, right click Format Cells... on Alignmen tab, check the option Wrap text. this will adjust your text within a cell. select the range you want to print, go to File menu Print Area Set Print Area. now take a look at print preview to what is going to print. hope this would help. Sgutsell Wrote: When printing a matrix with long text write-ups - The last few lines of a cell will be cut off. Is there a way to extend the parameters of a cell to not do this? Or - are there other solutions? -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=574186 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to print all text in a cell? - It cuts off the last few lines.
Perhaps it quits appearing because you have reached the cell limit for
viewable/printable characters. Excel Help on "limits" or "specifications" reveals that Excel will allow 32,767 characters to be entered in a cell. However, it goes on to state that "only 1024 characters will be visible or can be printed" To work around this limitation, stick a few ALT + ENTERs in at appropriate spots, about every 100 characters.. The ALT + ENTER forces a line-feed and expands the 1024 limit. How far is not really known. Just experiment. .........From Dave Peterson.......... I put this formula in A1: ="xxx"& REPT(REPT("asdf ",25)&CHAR(10),58)&"yyy" And adjusted the columnwidth, rowheight and font size and I got about 7300 characters to print ok. .........End Dave P................. Failing that, use a Text Box to store the text or MS Word which is a word processing application, unlike Excel which is not. Gord Dibben Excel MVP On Tue, 22 Aug 2006 07:10:03 -0700, Sgutsell wrote: When printing a matrix with long text write-ups - The last few lines of a cell will be cut off. Is there a way to extend the parameters of a cell to not do this? Or - are there other solutions? Gord Dibben MS Excel MVP |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to print all text in a cell? - It cuts off the last few li
See answer at the other section of this thread.
Gord Dibben MS Excel MVP On Tue, 22 Aug 2006 08:00:01 -0700, Sgutsell wrote: Sorry I wasn't clear. I've performed the below. The cell with 2 long paragraphs in it is wrapped and I've widened the column. The last 10 lines of the second paragraph are cut off at the end. The do not print either. It is as if the cell has a limited number of characters it can display; however, when I double click ont he cell the formula box contains all of the text?.? "starguy" wrote: your question is not clear. perhaps you need to fix the print area. try following click on cell or cells with long text in it, right click Format Cells... on Alignmen tab, check the option Wrap text. this will adjust your text within a cell. select the range you want to print, go to File menu Print Area Set Print Area. now take a look at print preview to what is going to print. hope this would help. Sgutsell Wrote: When printing a matrix with long text write-ups - The last few lines of a cell will be cut off. Is there a way to extend the parameters of a cell to not do this? Or - are there other solutions? -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=574186 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert two lines of text into one cell? | Excel Discussion (Misc queries) | |||
how do I copy several lines of word text into one excel cell? | New Users to Excel | |||
Multiple lines of text in a cell | Excel Discussion (Misc queries) | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
How can I print a cell that contains large amounts of text? | Excel Discussion (Misc queries) |