Home > Forum Home > Analyzing Corporate Financial Data > Last text line inside a cell, always shown half cut when printing Excel 2007 document Share

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


Forum TopicPost Reply Login

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

Rate this:
(3/5 from 1 vote)
Confused 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 on
 
Replies - Displaying 1 to 2 of 2Order Replies By: Most Recent | Chronological | Highest Rated
Oops
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 on
ConfusedRussell, your solution worked perfectelly!

Thank you very much,

Tomaz

 tomaz99
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Last text line inside a cell, always shown half cut when printing Excel 2007 document in the