Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Excel Errors / December 2005

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Smiley - 28 Dec 2005 17:27 GMT
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 :-)
Smiley - 28 Dec 2005 17:42 GMT
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!

> 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.
[quoted text clipped - 16 lines]
> and special pasting value only and reformatting with the same results.  Any
> advice (aside from removing the bold formatting :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.