Last text line inside a cell, always shown half cut when printing Excel 2007 document

Excel Help for Last Text Line Inside A Cell, Always Shown Half Cut When Printing Excel 2007 Document in Analyzing Corporate Financial Data

Last Text Line Inside A Cell, Always Shown Half Cut When Printing Excel 2007 Document

Rate this: (3/5 from 1 vote)

	Hi,   My problem is the last text line inside a cell, which persist to be 'cut' half (I have tried to format the cell information, by clicking ‘centre’ for vertical alignment, but nothing happens…), when printing the Excel 2007 document. Though, in the Excel worksheet, all the text lines are just fine, all the words show up correctly.   The more amazing thing is that when opening the same document in Excel 2003 - after doing 'Format cell'\'alignment'\'vertical alignment' and choose 'centre' for the problematic cells -, when I print the document, everything is ok.   How can I resolve this problem definitively for Excel 2007?   Regards,     Tomaz
	tomaz99
	Posted by tomaz99 on 06 Apr 2009

Replies - Displaying 1 to 2 of 2

Order Replies By: Most Recent | Chronological | Highest Rated

	Line break character or cell sizing Rate this: (3/5 from 1 vote) It could be that the text inside the cell has a line break causing the second line to be cut off when printing n Excel 2007. Perhaps you have copied this text from another application that retains the line break even though it is not visible within the cell in Excel 2007. I suggest that you copy the text that you want to print into a new worksheet and choose Paste Special > Values. This should remove any erroneous characters such as line breaks.
	Excel Business Forums Administrator
	Posted by Excel Helper on 07 Apr 2009

	Re: Last text line inside a cell, always shown half cut when printing Excel 2007 document Rate this: (3/5 from 1 vote) Russell, your solution worked perfectelly! Thank you very much, Tomaz
	tomaz99
	Posted by tomaz99 on 07 Apr 2009

Displaying page 1 of 1