Text is cutoff when printed or previewed, but is fine in norm view

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel worksheet with 5 columns and 76 rows. I chose to autofit the
rows for my text so I don't have to constantly adjust rows as I add new text.
While I'm working in the program, everything shows on the screen the way it
is supposed to. When I go to print preview or if I actually print it, the
text in the last column is distorted (shifted?) and does not resemble the
text from the input screen. For example, in the input screen the first line
may have 10 words, the second line may have 10 words. In the preview screen,
the first line only has 8, as does the second and the four remaining words
are shifted to a third line. Then the final row is cut off or only half
viewable.

I do not have any merged cells, I do not have more than 402 characters in
any cell, or any manual page breaks. I have tried to add manual page breaks
as well as with and without hard line breaks. The only thing that I can see
affecting this is that text in the last column is bolded and colored, but
have not found any information in any discussion or knowledge base threads
that discuss this fluke. If I remove the bold formatting and click autofit
again, the text is correct and viewable. I 've even tried copying the text
and special pasting value only and reformatting with the same results. Any
advice (aside from removing the bold formatting :-)
 
Sorry...forgot to add that I do have wrap text selected and I do not have any
angled text, so the shrink to fit option is also not selected!
 
Back
Top